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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
