MySQL Master and Slave Database Server

[Kaushal Shriyan-2]

Hi,

what are the different test cases to test MySQL Master and Slave Replication
Database Server.

Thanks and Regards

Kaushal

[Kaushal Shriyan-2]

On Fri, Apr 11, 2008 at 12:11 PM, Kaushal Shriyan <kaushalshriyan@...>
wrote:

> Hi,
>
> what are the different test cases to test MySQL Master and Slave
> Replication Database Server.
>
> Thanks and Regards
>
> Kaushal



Hi,

Reposting to the list again.

What are the different test cases to test MySQL Master and Slave Replication
Database Server.

Thanks and Regards

Kaushal

[Marcus Bointon]

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@... | http://www.synchromedia.co.uk/

[Rick James]

"test" what?

* That stuff is replicated?
* That the replicated stuff is intact?  (Think: the BlackHole bug with
skipped autoincrements)
* Whether the slave is up to date
* Whether ALL slaves are up to date
* "Relay" slaves
* Whether replicate/binlog _ do/ignore is doing the right thing (esp
when explicitly specifying db names in a JOIN).
* Whether DDL statements replicate correctly
* Whether Transactions go thru 'right' (consider subtle diffs between
InnoDB and Falcon)
* Whether stopping/startting slave threads do "the right thing".

> -----Original Message-----
> From: Kaushal Shriyan [mailto:kaushalshriyan@...]
> Sent: Thursday, April 10, 2008 11:41 PM
> To: replication@...
> Subject: MySQL Master and Slave Database Server
>
> Hi,
>
> what are the different test cases to test MySQL Master and
> Slave Replication
> Database Server.
>
> Thanks and Regards
>
> Kaushal
>

--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe:    http://lists.mysql.com/replication?unsub=lists@...