mysql_master_slave_replication []

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

=== 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.
\\
<code>
+------------------+              +------------------+
+--------+         |              +---------+        |
|MySQL   | -----   |              |MySQL    |        |
|Master  |     |   |              |Slave    |        |
+--------+    \/   |     IO       +---------+        |
|      Binary Logs | <--------->  |Relay Logs        |
+------------------+              +------------------+
</code>
\\
\\
=== SQL Thread ===
\\
This thread reads events from the relay logs stored locally on the slave and applies them. 
\\
<code>
+------------------+
+---------+        |
|MySQL    | <---+  |
|Sla^e    |     |  | SQL Running
+---------+     |  |
|Relay Logs +---+  +
+-----------------+
</code>
\\
More information can be found: [[https://www.percona.com/blog/2013/01/09/how-does-mysql-replication-really-work/]]