mysql>change master to master_host='10.33.133.160',master_user='sqlsync',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=517; //注意不要断开,517数字前后无单引号。
#master
mysql>change master to master_host='10.33.133.161',master_user='sqlsync',master_password='123456',master_log_file='mysql-bin.000002',master_log_pos=245;
#slave
change master to master_host='10.33.133.160',master_user='sqlsync',master_password='123456',master_log_file='mysql-bin.000004',master_log_pos=245;
配置中遇到的错误总结:
在配置主主的过程中,因在从服务器之前配置过主–>从的模式,导致start slave无法启动。查看mysql错误日志。
报错Failed to open the relay log ‘./mysqld-relay-bin.000025’ (relay_log_pos 251)。
到mysql主服务器配置文件/var/lib/mysql/master.info
修改之前配置的master_log_file和master_log_pos值为现在主服务器上的值。