List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:April 14 2008 9:24am
Subject:Re: MySQL Master and Slave Database Server
View as plain text  
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
Thread
MySQL Master and Slave Database ServerKaushal Shriyan11 Apr
  • Re: MySQL Master and Slave Database ServerKaushal Shriyan11 Apr
    • Re: MySQL Master and Slave Database ServerMarcus Bointon14 Apr
  • RE: MySQL Master and Slave Database ServerRick James18 Apr