 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
• |
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”
|
|