Slave_SQL_Running: Yes
【主节点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