LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: Has anyone ever used LVS with SQL server ?

To: "LinuxVirtualServer.org users mailing list." <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Has anyone ever used LVS with SQL server ?
From: Joseph Mack <mack.joseph@xxxxxxx>
Date: Thu, 06 May 2004 10:25:47 -0400
Horms wrote:
> 
> On Sat, May 01, 2004 at 11:34:44AM +0100, Malcolm Turnbull wrote:
> >
> > Test Setup is :
> >
> > 1 LVS
> > 2 Web servers (Win 2003) (set up as one vip)
> > 1 SQL server (will add another later as read only.) (setup as another vip)
> >
> > All in DR mode and on the same subnet.
> > The web servers work fine but sometimes (often) they timeout when trying
> > to reach the sql server via the VIP ? (no timeouts if they use the RIP).
> > SQL server is just a simple 1433 tcp protocol as I understand it ?
> 
> That sounds like it should work just fine. Have
> you tried poking around with tcpdump to verify that
> SQL server is indeed just using a simple connection on port 1433.

DOn't have any great ideas myself, but have you checked that your database
clients on the webservers are working correctly through the VIP

Joe
-- 
Joseph Mack PhD, High Performance Computing & Scientific Visualization
SAIC, Supporting the EPA Research Triangle Park, NC 919-541-0007
Federal Contact - John B. Smith 919-541-1087 - smith.johnb@xxxxxxx
<Prev in Thread] Current Thread [Next in Thread>