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
