grant replication slave,replication client on *.* to 'jerry'@'192.168.%.%>
change master to master_host='192.168.26.210',master_user='jerry',master_password='jerrypass',master_log_file='mysql-bin.000004',master_log_pos=326;
查看状态:
show slave status\G
服务器A上:
change master to master_host='192.168.26.211',master_user='jerry',master_password='jerrypass',master_log_file='mysql-bin.000005',master_log_pos=326;
启动:start slave
show slave status\G
创建数据库及表数据测试MYSQL双主模式
主服务器:192.168.26.210
执行命令:
create database baidu;
show databases;
主服务器:192.168.26.211
执行命令:
show databases;
create database cdbaidu;
show databases;