mysql主从同步图_MySQL
时间:2021-07-01 10:21:17
帮助过:42人阅读
bitsCN.com
共3个线程参与以上同步过程,他们分别为:
- Master
- Binlog Dump线程:Has sent all binlog to slave; waiting for binlog to be updated;(需同步帐号)
- Slave
- Slave IO线程:Waiting for master to send event;(需system user)
- Slave SQL线程:Has read all relay log; waiting for the slave I/O thread to update it;(需system user)
bitsCN.com