Configure the MySQL master-slave replication, well at the beginning, then over time you will find from the library position didn't keep up with the main library, but from the library Slave_IO_Running Slave_SQL_Running is yes
Slave_SQL_running_state is Slave has read all relay log; Waiting for the slave I/O thread to update it
What is the cause?

CodePudding user response:

No error

CodePudding user response:

Master:
Slave:

CodePudding user response:

Didn't see what's the problem,
Read_master_log_pos difference is very small, basically because main library dump thread sends binlog event of normal delay,