LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

RE: Using LVS for MySQL traffic

To: "'LinuxVirtualServer.org users mailing list.'" <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE: Using LVS for MySQL traffic
From: "Mark" <msalists@xxxxxxx>
Date: Tue, 25 Oct 2005 17:17:06 -0700
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
> 


<Prev in Thread] Current Thread [Next in Thread>