mysql_master_slave_replication
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| mysql_master_slave_replication [2017/05/31 11:46] – created luke7858 | mysql_master_slave_replication [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| Important information: | Important information: | ||
| \\ | \\ | ||
| - | Binary Logs --> | + | **//Binary Logs//** --> |
| Replication events are written to the binary logs (on the master). Information stored here will be read by the slave later. | 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. | + | **//Relay Logs//** --> Simply a copy of the binary logs. Relay logs are stored on the slave. |
| \\ | \\ | ||
| === IO Thread === | === IO Thread === | ||
| Slave connects to master, copies the binary logs over and stores them locally in relay logs. | Slave connects to master, copies the binary logs over and stores them locally in relay logs. | ||
| \\ | \\ | ||
| - | <sxh bash> | + | <code> |
| +------------------+ | +------------------+ | ||
| +--------+ | +--------+ | ||
| - | |MySQL | + | |MySQL |
| - | |Master | + | |Master |
| - | +--------+ | + | +--------+ |
| - | | Binary Logs | +---------> | + | | Binary Logs | <---------> |
| - | +------------------+ | + | +------------------+ |
| - | </sxh> | + | </code> |
| \\ | \\ | ||
| \\ | \\ | ||
| Line 26: | Line 26: | ||
| This thread reads events from the relay logs stored locally on the slave and applies them. | This thread reads events from the relay logs stored locally on the slave and applies them. | ||
| \\ | \\ | ||
| - | <sxh bash> | + | <code> |
| +------------------+ | +------------------+ | ||
| +---------+ | +---------+ | ||
| Line 34: | Line 34: | ||
| |Relay Logs +---+ + | |Relay Logs +---+ + | ||
| +-----------------+ | +-----------------+ | ||
| - | </sxh> | + | </code> |
| \\ | \\ | ||
| More information can be found: [[https:// | More information can be found: [[https:// | ||
mysql_master_slave_replication.1496231196.txt.gz · Last modified: 2024/05/23 07:26 (external edit)