MySQL Master and Slave Database Setup

[Kaushal Shriyan-2]

Hi

I have successfully implemented the Master Slave Replication of MySQL. Its
working fine

Test case: Master host crashes, and need to bring one of the slave as
master, and then point the other slaves to the new master.

How can i implement the above test case.

Thanks and Regards

Kaushal

[Marcus Bointon]

On 22 Apr 2008, at 08:53, Kaushal Shriyan wrote:

> Test case: Master host crashes, and need to bring one of the slave as
> master, and then point the other slaves to the new master.
>
> How can i implement the above test case.


You might find you start getting better responses if you read some  
docs before posting here.
Aside from that, this article has something to say about this:

http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?page=4

Marcus
--
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@... | http://www.synchromedia.co.uk/



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