From: Ben Clewett
Date: April 2 2007 7:43am
Subject: Re: Database Replication Fallover
List-Archive: http://lists.mysql.com/mysql/205939
Message-Id: <4610B427.4070207@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I forgot to mention that I am running Linux.

If anybody has some idea of software which can do this, I'd be very 
interested.

Regards,

Ben

Ben Clewett wrote:
> 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.
> 
> 
> 
>