Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- reset bad side of a mysql master-master
- 1) On bad side:
- stop slave;
- On good side:
- stop slave;
- flush tables with read lock;
- reset master;
- show master status;
- *dump dbs
- unlock tables;
- On bad side:
- *load db dump
- /* remove all logging from the loading of the data from the good side */
- reset master;
- /* forget old slave info and get ready to do change master */
- reset slave;
- change master to
- MASTER_HOST = 'goodside',
- MASTER_USER = 'user',
- MASTER_PASSWORD = 'pw',
- MASTER_LOG_FILE = 'goodmasterfile',
- MASTER_LOG_POS = goodmasterpos;
- start slave;
- /* so we can restart the slave on the good side */
- show master status;
- On good side:
- reset slave;
- change master to
- MASTER_HOST = 'badside',
- MASTER_USER = 'user',
- MASTER_PASSWORD = 'pw',
- MASTER_LOG_FILE = 'badmasterfile',
- MASTER_LOG_POS = badmasterpos;
Add Comment
Please, Sign In to add comment