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]