mysql主从同步图
共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)
TAG: