| Monitoring |
|
|
|
|
|
|
|
|
|
|
|
|
| • | Heartbeat
for performance |
||||||||||
| – | Create
a table to hold timestamps |
||||||||||
| – | Add
records on the master |
||||||||||
| – | Read
them on the slave |
||||||||||
| – | Compare
and compute the delay |
||||||||||
| • | Errors |
||||||||||
| – | Watch
error log on slave |
||||||||||
| – | Or
run a SHOW SLAVE
STATUS |
||||||||||
| Copyright
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |