当前位置:Gxlcms > mysql > mysql主从同步图_MySQL

mysql主从同步图_MySQL

时间:2021-07-01 10:21:17 帮助过:42人阅读

bitsCN.com

mysql主从同步图

共3个线程参与以上同步过程,他们分别为:

  1. Master
    • Binlog Dump线程:Has sent all binlog to slave; waiting for binlog to be updated;(需同步帐号)
  2. 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

人气教程排行