I should mention that the below concerns read-only daemons, Dan's post reminded me of that. Having multiple masters in a load balanced environment is extremely difficult to do right.
I would wager that for most applications, at least internet related, you'll have a much higher read-to-write ratio where you can get by having only one master while using multiple replicated slaves (even for really high traffic sites). Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 4 Aug 2006, Atle Veka wrote: > You can have a simple LVS setup running with a plugin from Nagios, > check_mysql, which will connect to the mysql daemon and run a status > query. If you want anything more than that you most likely will have to > write a custom check plugin (shouldn't be that hard). LVS works nicely as > a mysql loadbalancer in my experience. > > > Atle > - > Flying Crocodile Inc, Unix Systems Administrator > > On Fri, 4 Aug 2006, Ed Pauley II wrote: > > > I am looking into a scale-out solution for MySQL. I have read white > > papers and searched the web but I can't find a load balancer that claims > > to work well for MySQL. MySQL's white paper shows NetScaler in the > > scale-out stack but nothing on Citrix.com mentions MySQL. I also read > > that friendster wrote a custom script for NetScaler to work in a MySQL > > environment. I would rather not have to do that. Is there an out-of-box > > solution for load balancing MySQL. My understanding is that MySQL is a > > little more complicated than HTTP load balancing, which we already do > > with Coyote Point Equalizers. I have thought about LVS. Has anyone had > > any experience with load balancing MySQL? Any recommendations? Thanks in > > advance. > > -Ed > > > > -- > > Ed Pauley II > > [EMAIL PROTECTED] > > http://www.brisnet.com > > http://www.brisbet.com > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
