On Tue, Oct 19, 2010 at 19:06, John Daisley wrote:
> You may also want to take a look at MySQL MMM which makes use of
> Active/passive masters to makes MySQL failover very simple.
+1 We could not do much of our daily work without MMM. It makes
the whole HA/Failover thing a breeze. We have it i
The short answer is this: You need special software outside of MySQL to do
this. This software has to
- Keep a heartbeat going between the two servers. Whether or not you do this
by checking only MySQL, or the machines themselves, depends upon what other
applications might be running (web serve
You may also want to take a look at MySQL MMM which makes use of
Active/passive masters to makes MySQL failover very simple.
On 19 October 2010 11:45, Johan De Meersman wrote:
> That's pretty much it, indeed. You need to make absolutely sure that no
> more
> connections can be made to the old,
That's pretty much it, indeed. You need to make absolutely sure that no more
connections can be made to the old, broken master, though - even if you have
to physically pull the network or power cable. Failover services refer to
this as STONITH: Shoot The Other Node In The Head.
Don't think "but it
Quoting Machiel Richards :
The question I have however is how do you fail over to the slave
server in the event that the master server is unavailable and then how
to revert back to the master server once the server is available again.
Hi,
to fail over to the slave, you dont need t
At 09:15 2002-06-05, Ramon Kagan wrote:
>Hi,
>
>(mysql 3.23.49, debian linux 2.4.18)
>
>I am looking at running a program called keepalived so I can monitor
>the availability of my mysql server. Data is stored on a NetApp filers so
>its readily available to multiple machines. What I'd like to d
You would think this would get built into MYSQL though.
Dave
On Tue, Aug 21, 2001 at 03:28:51PM -0700, Jeremy Zawodny wrote:
> On Mon, Aug 20, 2001 at 01:21:22PM -0700, David Turner wrote:
> >
> > It looks like this will only run on Linux and I must either use
> > Sparc Solaris or X86. I hate t
Yes, that's probably where we'll end up.
Thanks, Dave
On Tue, Aug 21, 2001 at 03:28:51PM -0700, Jeremy Zawodny wrote:
> On Mon, Aug 20, 2001 at 01:21:22PM -0700, David Turner wrote:
> >
> > It looks like this will only run on Linux and I must either use
> > Sparc Solaris or X86. I hate to impleme
On Mon, Aug 20, 2001 at 01:21:22PM -0700, David Turner wrote:
>
> It looks like this will only run on Linux and I must either use
> Sparc Solaris or X86. I hate to implement the failover within the
> application.
Perhaps you need some tiny piece of middleware that acts as a MySQL
proxy to do the
It looks like this will only run on Linux and I must either use Sparc Solaris
or X86. I hate to implement the failover within the application.
Thanks anyway, Dave
On Mon, Aug 20, 2001 at 01:04:10PM -0700, Jeremy Zawodny wrote:
> On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote:
> >
Great, thanks, Dave
On Mon, Aug 20, 2001 at 01:04:10PM -0700, Jeremy Zawodny wrote:
> On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote:
> >
> > I have two identical primarily readonly databases that I want to be
> > able to upgrade on the fly. What I want to be able to do is take one
On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote:
>
> I have two identical primarily readonly databases that I want to be
> able to upgrade on the fly. What I want to be able to do is take one
> down and have all my connections redirected to the second database
> automatically. I woul
I'll do all this as soon as possible .
Very best
Constantin Bogomolnyi
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Bogomolnyi Constantin" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 1:50 PM
Subject: Re: Failover and Replication [HOWTO]
>
Hi Bogomolnyi,
I am really interested in your scripts. I don't have a use for them at this
time, but I am planning to use a fallback system myself in the next few
month.
> 5 pc , and I use it for a web cluster (10 pc) so I use 1 slave
> for 2 httpds
Do you have a similar scheme for the web serv
Hi ,
I posted a few considerations about fialover implementation , to the list ,
but i don't recived any feed back , well lets see what we have :
But i write a bunch of perl scripts and now I use them in production and
very happy with the result .
Here what I have :
Baiscly what I want is an sql
On Wed, Mar 14, 2001 at 09:10:42AM -0800, Bryan Coon wrote:
>
> We are implementing a linux cluster, and rather than get gouged by
> oracle (in performance and licensing) would much rather use
> MySQL.
A common solution to a common problem, I suspect.
> If I understand correctly, replicatio
16 matches
Mail list logo
