List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:April 3 2007 8:14am
Subject:Re: Database Replication Fallover
View as plain text  
Hi Scott,

Thanks for the information.  I'll look into linux-ha seriously.

Regards,

Ben

Scott Tanner wrote:
> 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