Re: Database Replication Fallover

2007-04-03 Thread Ben Clewett
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 cr

Re: Database Replication Fallover

2007-04-02 Thread Scott Tanner
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

Re: Database Replication Fallover

2007-04-02 Thread Ben Clewett
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

Database Replication Fallover

2007-03-30 Thread Ben Clewett
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 soft