mysql 互为主从

grant replication slave on *.* to backup@192.168.188.128 identified by "123456"; 

grant replication slave on *.* to backup@192.168.188.8 identified by "123456"; 

 

service mysql stop

 

server_id = 1

log-bin = mysql-bin

log-error=mysql-error

master-host = 192.168.188.8

master-user = backup

master-password = '123456'

master-port = 3306

master-connect-retry = 20

replicate-ignore-db= mysql

 

 

server_id = 2

log-bin = mysql-bin

log-error=mysql-error

master-host = 192.168.188.128

master-user = backup

master-password = '123456'

master-port = 3306

master-connect-retry = 20

replicate-ignore-db= mysql

 

stop slave;

reset slave;

start slave;

 

show slave status;