On 11 Apr 2008, at 19:12, Kaushal Shriyan wrote:
> What are the different test cases to test MySQL Master and Slave
> 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.
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