current position:Home>What are the reasons for the delay of master-slave synchronization in MySQL?

What are the reasons for the delay of master-slave synchronization in MySQL?

2022-02-04 16:37:42 Alibaba cloud Q & A

MySQL What is the reason for the delay of master-slave synchronization ?




Take the answer 1:

A server is open N A link to the client to connect , In this way, there will be large concurrent update operations , But read from the server binlog There is only one thread for , When a SQL It takes a little longer to execute from the server Or because of some SQL Locking the table will result in , Of the main server SQL Large backlog , Not synchronized to the slave server . This leads to the inconsistency between the master and the slave , That is, master-slave delay .


copyright notice
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/02/202202041637406037.html

Random recommended