Home >Database >Mysql Tutorial >mysql主从同步图_MySQL

mysql主从同步图_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:38:56931browse

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
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn