Re: Load Blancing Mysql Max Db Server Between 2 Servers

2002-04-12 Thread Russell E Glaue
Well LVS is good for any application including read-write loadbalancing. But to do this for MySQL, you'll have to have master-master replication set up. master-master replication in MySQL is still yet to be perfected. It is not usually the best idea to operate any databases on an NFS drive. This

Re: Load Blancing Mysql Max Db Server Between 2 Servers

2002-04-12 Thread Frankie Gravato
AIL PROTECTED]> To: "Russell E Glaue" <[EMAIL PROTECTED]> Cc: "Frankie Gravato" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 11:55 AM Subject: Re: Load Blancing Mysql Max Db Server Between 2 Servers > On Fri, 2002-04-12 at 11:47, Russ

Re: Load Blancing Mysql Max Db Server Between 2 Servers

2002-04-12 Thread Jason Yates
On Fri, 2002-04-12 at 11:47, Russell E Glaue wrote: > > If your database is read-only, you can use Linux Virtual Server to load > balance traffic to MySQL servers. > -RG > > LVS as you said it is only good for read-only. Are there any solutions for non read-only load balancing, using replicat

Re: Load Blancing Mysql Max Db Server Between 2 Servers

2002-04-12 Thread Russell E Glaue
If your database is read-only, you can use Linux Virtual Server to load balance traffic to MySQL servers. -RG On Fri, 12 Apr 2002, Frankie Gravato wrote: > Date: Fri, 12 Apr 2002 10:54:56 -0400 > From: Frankie Gravato <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Load Blancing Mysql M