一、master_db /etc/my.cnf内容
binlog-do-db=zhxq
binlog-do-db=register
binlog-ignore-do=mysql
replicate-do-db=zhxq
replicate-do-db=register
replicate-ignore-db=mysql
log-bin=mysql-bin
server-id=1
log-slave-updates=1
skip-slave-start
二、slave_db /etc/my.cnf内容
binlog-do-db=zhxq
binlog-do-db=register
binlog-ignore-do=mysql
replicate-do-db=zhxq
replicate-do-db=register
replicate-ignore-db=mysql
log-bin=mysql-bin
server-id=2
log-slave-updates=1
skip-slave-start
三、重启主从mysql服务
1.查看master_db的状态,show master status
2.在slave_db上登录mysql
mysql>change master to master_host='192.168.137.11',master_port=3306, master_user='slave', master_password='123456',MASTER_LOG_FILE='mysql-bin.000015',MASTER_LOG_POS=106;
mysql>start slave;
四、mysql宕机恢复之后重置主从
1. 查看mycat日志,主从切换的时间
2. 停止slave_db的主从同步
3. 查看slave_db的二进制日志,找到开始写slave_db的位置position
4. slave_db,mysql>reset slave all
5. 重新启动master_db
6. 在master_db上
mysql>change master to master_host='192.168.137.11',master_port=3306, master_user='slave', master_password='123456',MASTER_LOG_FILE='mysql-bin.000015',MASTER_LOG_POS=106;
mysql>start slave;
7. mycat的schema.xml修改,更换主从
8. mycat的dnindex.property改为0
9. 重启mycat