mercredi 25 mars 2015

MySQL Replication Check


we are about to replicate our database servers into several slaves in different physical locations.


The company which is doing replication for us, has asked to give them a sql select statement on one of our tables to check lag and latency like


SELECT id FROM table1 ORDER BY id DESC LIMIT 1


Is it a common practice to check the lag between several instances?


Thank you in advance.





Aucun commentaire:

Enregistrer un commentaire