Hm. I'm interested in the outcome of this discussion as I've got a similar setup with circular mysql replication but without the RR DNS.
Jessie - are you using any persistence for the mysql connections? If so, how long? Dan Jessie wrote: > Hi Joe, > > > > On Oct 11, 2007, at 5:19 AM, Joseph Mack NA3T wrote: > >> On Wed, 10 Oct 2007, Jessie wrote: >> >>> Hi everyone, >>> >>> I've tried two different approaches on LVS-DR to get a HA MySQL >>> system going. >>> * LVS-DR using two realserver definitions >>> * LVS-DR using one realserver and one sorry server (per HOWTO) >>> >>> We have two MySQL 5 servers in master-master mode (copper & olive) >>> >>> We have two LVS-DR load balancers, (lb2 and lb3) >>> >>> Each LVS-DR has a vip hostname: (tea, soda) >> I assume an "LVS-DR" is a director, but I don't know why you >> have two VIPs. > > 1 VIP per director > > lb2 and lb3 are LVS-DR directors > > on lb2 is a VIP called tea > on lb3 is a VIP called soda > > >>> lb2: >>> tea:3306 >>> copper (realserver) >>> olive (sorry server) >>> >>> lb3: >>> soda:3306 >>> olive (realserver) >>> copper (sorry server) >>> >>> >>> 'mysql.example.org' has two DNS A records (tea,soda) and round robins >>> which VIP/LB to hit. >> so this isn't really an LVS then? >> > > 'mysql' is a DNS hostname that points to two VIPs on two LBs for HA > > each VIP has a different Mysql-Server active (remember this is a > master-master replication) > > > > >>> connecting to 'copper' is fine >> directly? from where? >> > > > "The internet" (ie outside the director IP subnet) > > > >>> connecting to 'olive' is fine >>> connecting to 'tea' is NOT fine with the apps above, but manual mysql >>> queries *seem* OK. >>> connecting to 'soda' is NOT fine with the apps above, but manual >>> mysql queries *seem* OK. >>> connecting to 'mysql' is NOT fine with the apps above, but manual >>> mysql queries *seem* OK. >> have you shown that LVS is working by testing with a simple >> service like telnet? >> > > > I have around 50 VIPs across two directors working. I can establish a > socket to the mysql server through LVS and perform simple > mysql queries. I can do the same going directly to the realserver ip. > What fails are large/complex SQL queries THROUGH the director/VIP > > > >>> I've tried using just one LVS-DR server and it didn't make >>> any difference. I cannot produce any problems using LVS >>> via a manual mysql query through LVS All production apps >>> when pointed to an LVS host, will occasionally work, and >>> other times just timeout. >>> >>> The firewall on all the systems looks clean >> don't install firewall rules till you have the LVS working >> > > I turned it off -- no diff. > > > > _______________________________________________ > LinuxVirtualServer.org mailing list - [email protected] > Send requests to [EMAIL PROTECTED] > or go to http://lists.graemef.net/mailman/listinfo/lvs-users -- Dan Yocum Fermilab 630.840.6509 [EMAIL PROTECTED], http://fermigrid.fnal.gov Fermilab. Just zeros and ones. _______________________________________________ LinuxVirtualServer.org mailing list - [email protected] Send requests to [EMAIL PROTECTED] or go to http://lists.graemef.net/mailman/listinfo/lvs-users
