|
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!
|
