mysql_master_slave_replication
This is an old revision of the document!
Mysql Master-Slave Replication
Important information:
Binary Logs –>
Replication events are written to the binary logs (on the master). Information stored here will be read by the slave later.
Relay Logs –> Simply a copy of the binary logs. Relay logs are stored on the slave.
IO Thread
Slave connects to master, copies the binary logs over and stores them locally in relay logs.
+------------------+ +------------------+ +--------+ | +---------+ | |MySQL | | |MySQL | | |Master | | |Slave | | +--------+ | IO +---------+ | | Binary Logs | <---------> |Relay Logs | +------------------+ +------------------+
SQL Thread
This thread reads events from the relay logs stored locally on the slave and applies them.
+------------------+ +---------+ | |MySQL | <---+ | |Sla^e | | | SQL Running +---------+ | | |Relay Logs +---+ + +-----------------+
More information can be found: https://www.percona.com/blog/2013/01/09/how-does-mysql-replication-really-work/
mysql_master_slave_replication.1496297574.txt.gz · Last modified: 2024/05/23 07:26 (external edit)