Cette page vous donne les différences entre la révision choisie et la version actuelle de la page.
|
mysql_bragon_utils [2012/01/25 16:20] bragon |
mysql_bragon_utils [2012/03/12 10:34] (Version actuelle) bragon |
||
|---|---|---|---|
| Ligne 142: | Ligne 142: | ||
| GRANT REPLICATION CLIENT ON * . * TO 'sdfrance'@'%' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; | GRANT REPLICATION CLIENT ON * . * TO 'sdfrance'@'%' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; | ||
| </code> | </code> | ||
| + | |||
| + | |||
| + | * Maatkit : | ||
| + | <code> | ||
| + | ##### preparation de la bascule #### | ||
| + | |||
| + | Utilisation de maatkit pour virifier le checksum des bases : | ||
| + | |||
| + | create database checksum | ||
| + | use checksum | ||
| + | CREATE TABLE checksum ( | ||
| + | db char(64) NOT NULL, | ||
| + | tbl char(64) NOT NULL, | ||
| + | chunk int NOT NULL, | ||
| + | boundaries char(100) NOT NULL, | ||
| + | this_crc char(40) NOT NULL, | ||
| + | this_cnt int NOT NULL, | ||
| + | master_crc char(40) NULL, | ||
| + | master_cnt int NULL, | ||
| + | ts timestamp NOT NULL, | ||
| + | PRIMARY KEY (db, tbl, chunk) | ||
| + | ); | ||
| + | |||
| + | |||
| + | mk-table-checksum -u root -p`cat /root/.rootdbpass` --replicate checksum.checksum --chunk-size=10M localhost | ||
| + | |||
| + | |||
| + | puis sur le slave : | ||
| + | |||
| + | SELECT db, tbl, chunk, this_cnt-master_cnt AS cnt_diff, | ||
| + | this_crc <> master_crc OR ISNULL(master_crc) <> ISNULL(this_crc) | ||
| + | AS crc_diff | ||
| + | FROM checksum | ||
| + | WHERE master_cnt <> this_cnt OR master_crc <> this_crc | ||
| + | OR ISNULL(master_crc) <> ISNULL(this_crc); | ||
| + | |||
| + | |||
| + | </code> | ||
| + | |||