centos7上配置mysql8的双主互写

【主节点1】
开启主从同步
mysql> start slave;

再查看主从同步状态
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.1.131.76
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 178
Relay_Log_File: localhost-relay-bin.000002
Relay_Log_Pos: 322
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

注意看Slave_IO_Running和Slave_SQL_Running，必须都是YES，如果Slave_IO_Running是No，通常都是server-id配置有问题。

centos7上配置mysql8的双主互写

标签：必须   with   read   waiting   主从同步   server-id   host   centos7   xxx