 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| • |
Master / Slave replication
|
|
|
| • |
Master records all write queries in the
|
|
|
|
binary log
|
|
|
| • |
Slaves read the binary log from the master
|
|
|
and run the queries locally
|
|
|
| • |
A master can have many slaves
|
|
|
| • |
A slave can have only one master
|
|
|
| • |
A server can be both a master and a slave
|
|
|
|
– |
A relay or “local master”
|
|