| Replication in 4.0.x |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Slave
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 |
||||||||||||
| Copyright
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |