So let's assume your master goes down for whatever reason, and you have to make
one of the other slaves a master.
Do you do this manually, or do you have a script that detects the problem and
acts automatically?
> -----Original Message-----
> From: lvs-users-bounces@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:lvs-users-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf
> Of Troy Hakala
> Sent: Tuesday, October 25, 2005 4:49 PM
> To: LinuxVirtualServer.org users mailing list.
> Subject: Re: Using LVS for MySQL traffic
>
>
> That's true, but the master is redundant in itself (RAID
> drives, redundant
> power) to minimize the risk. But yes, we are very
> read-intensive and keeping the master out of the read
> load-balancing further increases the master's lifespan.
>
> We haven't tried master-master replication, but it's pretty
> easy and quick to turn a slave into a master. We prefer
> simplicity to complexity. Besides, we're not a bank and no
> one dies if the master db goes down for a few minutes every 5
> years. :-)
>
> FWIW, our outages have been caused by bandwidth outages more
> than server hardware failure. There's supposed to be
> redundancy there too, but for some reason or another, the
> redundancy never kicks in. ;-)
>
>
> On 10/25/05, Mark <msalists@xxxxxxx> wrote:
> >
> > But you only solve half of the problem - if your master
> goes down you
> > can not do write operations any more... Still better than
> being down
> > completely of course, especially if you have a higher percentage of
> > reads compared to writes, plus you have the load-balancing if your
> > reads are complex load-intensive queries.
> >
> > Did you ever try master-master replication? Some people use
> that, but
> > I think it's not totally trivial, there are some potential pitfalls.
> >
> > MARK
> >
> >
> > > -----Original Message-----
> > > From: lvs-users-bounces@xxxxxxxxxxxxxxxxxxxxxx
> > > [mailto:lvs-users-bounces@xxxxxxxxxxxxxxxxxxxxxx] On
> Behalf Of Troy
> > > Hakala
> > > Sent: Tuesday, October 25, 2005 4:28 PM
> > > To: LinuxVirtualServer.org users mailing list.
> > > Subject: Re: Using LVS for MySQL traffic
> > >
> > >
> > > We're using master/slave replication. The LVS balances the reads
> > > from the slaves and the master isn't in the
> load-balancing pool at
> > > all. The app knows that writes go to the master and reads
> go the VIP
> > > for the slaves. Aside from replication latency, this works very
> > > reliably.
> > >
> > >
> > > On 10/25/05, mike <mike503@xxxxxxxxx> wrote:
> > > >
> > > > On 10/25/05, Troy Hakala <troy@xxxxxxxxxxxxxx> wrote:
> > > > > it works fine, we've been doing it for years. :-)
> > > > >
> > > >
> > > > thanks :)
> > > >
> > > > okay, here comes the next question then... just for curiosity -
> > > > for both of you guys.
> > > >
> > > > how are you replicating the data between mysql servers?
> > > >
> > > > NDB/MySQL clustering?
> > > > master/slave replication?
> > > > something else?
> > > >
> > > > thanks
> > > > - mike
> > > > _______________________________________________
> > > > LinuxVirtualServer.org mailing list -
> > > lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> > > > Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> > > > or go to http://www.in-addr.de/mailman/listinfo/lvs-users
> > > >
> > > _______________________________________________
> > > LinuxVirtualServer.org mailing list -
> > > lvs-users@xxxxxxxxxxxxxxxxxxxxxx Send requests to
> > > lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> > > or go to http://www.in-addr.de/mailman/listinfo/lvs-users
> > >
> >
> > _______________________________________________
> > LinuxVirtualServer.org mailing list -
> lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> > Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> > or go to http://www.in-addr.de/mailman/listinfo/lvs-users
> >
> _______________________________________________
> LinuxVirtualServer.org mailing list -
> lvs-users@xxxxxxxxxxxxxxxxxxxxxx Send requests to
> lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
|