List:General Discussion« Previous MessageNext Message »
From:Scott Tanner Date:April 2 2007 6:59pm
Subject:Re: Database Replication Fallover
View as plain text  
Ben,
 
  Check out Linux-ha ( http://linux-ha.org). We are using version 1 at my company, which
is fairly easy to set up and there are a lot of good articles on it.  With this you can
create a virtual address to fail-over between systems, run commands / scripts during a
fail over, and even kill the other node (stonith) if you have supporting hardware. 

  For our setup, we have the client apps accessing the db through the virtual IP address.
We have 2 mysql config files, one for the master and one for the slave (actually we have
one m4'd config file, but you get the idea). During failover, we restart mysql on the
slave using the master config file and transfer the virtual IP over. 

  Here are a couple of key points for setting this up:

  1. Slave must be running with the 'log-slave-updates' option.
  2. After you run a back issue a reset master on the slave server. 


Hope this helps,
Scott Tanner



On Mon, Apr 02, 2007 at 08:43:35AM +0100, Ben Clewett wrote:
> 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.
> >
> >
> >
> >
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 
> 
> 
Thread
Database Replication FalloverBen Clewett30 Mar
  • Re: Database Replication FalloverBen Clewett2 Apr
    • Re: Database Replication FalloverScott Tanner2 Apr
      • Re: Database Replication FalloverBen Clewett3 Apr