mysql_master_slave_replication
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| mysql_master_slave_replication [2017/06/01 06:12] – luke7858 | mysql_master_slave_replication [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 11: | Line 11: | ||
| 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.1496297574.txt.gz · Last modified: 2024/05/23 07:26 (external edit)