Re: Mon + LVS for a mysql cluster

[Bosco Lau <bosco@xxxxxxxxxxx>]

Also with the mutiple slaves/LVS setup , you can just use MYISAM tables 
in the slaves database whereas you may have innoDB tables in the master. 
This will make your SELECT performances even better. Since the slaves 
just replicates the data from the master, there is no need for 
transactional tables type in the slave database.
Jan Klopper wrote:

> Romain,
>
> There is not good sollution for mysql and clustering.
>
> Your best bet (if you only do a lot of Select query's) would be to use 
> one mysql master server which gets all the update/delete/insert 
> query's and stores the main database,.
> Then you could use mysql master-slave setup to replicate this master 
> database to a couple of slave servers on which you could do all of 
> your selects.
> You could use Mon/ldirectord to make a LVS cluster out of these select 
> servers just like any other type of servers.
> I'm not sure what you should do with the persistence tough. 
> (especially if you use mysql_pconnect from within php/apache)
> I have the following setup:
> cheap webservers (LVS)
> cheap load balancers (VIP)
> expensive raid 10 mysql server (master)
> cheap fileserver + mysql slave (just for backup, not for queries)
>
> I think this is the best setup you could have.
> Granted, if your database server dies, you're screwed, but with the 
> current mysql master/slave/replication/cluster technologies you 
> wouldn't be able to provide faiover for update/insert/delete query's 
> anyway.
> (making one of the slaves into a master and thus change its database 
> will give you a serious problem when you master comes back up again. 
> (you'd have to make the master a slave, stop the current master 
> (breaking the whole point of allways online) and replicate to it, then 
> when it is up2date change its role to be master again.)
> hope this helps.
>
> greets
> Jan
>
> Romain Moyne wrote:
>
> > Mack.Joseph@xxxxxxxxxxxxxxx a écrit :
> >
> > > Joseph Mack PhD, High Performance Computing & Scientific Visualisation
> > > LMIT, Supporting the EPA Research Triangle Park, NC 919-541-0007
> > > Federal Contact - John B. Smith 919-541-1087 - smith.john@xxxxxxx
> > >
> > > lvs-users-bounces@xxxxxxxxxxxxxxxxxxxxxx wrote on 03/01/2005 02:55:37
> > > PM:
> > >
> > >  
> > >
> > > > > Have you read the section on databases in the HOWTO?
> > > > >     
> > >  
> > >
> > > > I don't find any Howto to use LVS with databases... It isn't in the
> > > > documentation section :(
> > > >   
> > >
> > >
> > > go to the LVS HOWTO title page
> > >
> > > http://www.austintek.com/LVS/LVS-HOWTO/HOWTO/
> > >
> > > 1. use the find function on your browser with the string "database"
> > >
> > > or
> > >
> > > 2. go to the first link on this title page - it's the LVS documenation
> > > search
> > > engine. plug in "databases"
> > >
> > > Joe
> > >  
> > On my MySQL servers, I want to install MySQL CLuster. But can I use 
> > Mon with LVS and how?
> > thanks,
> >
> > > _______________________________________________
> > > 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