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. > > 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? > connecting to 'copper' is fine directly? from where? > 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'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 JOe -- Joseph Mack NA3T EME(B,D), FM05lw North Carolina jmack (at) wm7d (dot) net - azimuthal equidistant map generator at http://www.wm7d.net/azproj.shtml Homepage http://www.austintek.com/ It's GNU/Linux! _______________________________________________ LinuxVirtualServer.org mailing list - [email protected] Send requests to [EMAIL PROTECTED] or go to http://lists.graemef.net/mailman/listinfo/lvs-users
