1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| stop all slaves;
CHANGE MASTER MASTER_1
MASTER_HOST='192.168.0.1',
MASTER_PORT='3306',
MASTER_USER='user',
MASTER_PASSWORD='passwd',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=1;
CHANGE MASTER MASTER_2
MASTER_HOST='192.168.0.2',
MASTER_PORT='3306',
MASTER_USER='user',
MASTER_PASSWORD='passwd',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=1;
...
CHANGE MASTER MASTER_N
MASTER_HOST='192.168.0.N',
MASTER_PORT='3306',
MASTER_USER='user',
MASTER_PASSWORD='passwd',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=1;
start all slaves; |
Partager