=== 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/]]