mysql主从同步图

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)

posted on 2012-11-07 10:40  浪迹上海滩  阅读(595)  评论(0编辑  收藏  举报

导航