On 11 Apr 2008, at 19:12, Kaushal Shriyan wrote:
> What are the different test cases to test MySQL Master and Slave
> Replication
> Database Server.
There's not a lot to test. The slave server can be up to date, some
way behind, or broken. You can test by doing an insert on the master,
waiting 1 second then trying to fetch it from the slave - if it's not
trailing, it will be there. Next you can keep an eye on
seconds_behind_master field in the "show slave status" output - except
on rare occasions (e.g. immediately after large transactions or slave
outages), this should be 0.
The Maatkit tools have some things for helping monitor slaves, though
I'm not using that at the moment.
Marcus
--
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/
Attachment: [application/pkcs7-signature] smime.p7s

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.