From: Ben Clewett
Date: March 30 2007 4:19pm
Subject: Database Replication Fallover
List-Archive: http://lists.mysql.com/mysql/205921
Message-Id: <460D3878.10205@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear MySql,

I'm looking into availability and wonder if any member might be able to 
help me.

I have two databases, one Primary and one full Replication.

Normally the primary is used for data input, reports are drawn from the 
replication.

If I loose the Primary, do any members have any software they can 
recommend which:

- Stops the replication daemon.
- Sets the replication server to Read/Write.
- Shuts down the primary.
- Routes traffic to the replication.

Any advise or ideas would be very useful...

Regards,

Ben Clewett.