| Replication
in 4.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Slave operation is multi-threaded |
||||||||||||
| • | Relay thread |
||||||||||||
| – | Connects to master and copies queries to local |
||||||||||||
| spool (relay log) without delay |
|||||||||||||
| • | SQL thread |
||||||||||||
| – | Acts like 3.23.xx replication, but uses the local |
||||||||||||
| relay log rather than connecting to the master |
|||||||||||||
| • | Faster than 3.23.xx |
||||||||||||
| • | Less chance of lost queries |
||||||||||||
| • | Transactions replicate properly (?) |
||||||||||||
