Forum Discussion

tobin_dax_93013's avatar
tobin_dax_93013
Icon for Nimbostratus rankNimbostratus
Jan 11, 2010

Load Balancing SQL Servers

Hi All

 

 

I am new to F5 Systems and so apologise i am asking an obvisouly stupid question

 

 

I am attempting to load balanced 2 sql 2005 servers, DBA's have configured replication between the sql servers to keep transactions records sync'd. I have created a VS listening on port 1433 using a pool of servers using listening on that same port. Our DBA tells me that a odbc connection test is failing. Does anyone have an example of how the VS should be configured in terms advanced settings, or have seen an issue like this before ? I am about to run a tcpdump on the server to see what that tells me but any advice or ideas on what is causing this problem would be appricated

 

 

Thanks in Advance

 

Tobin
microsoft
partner

1 Reply

Sort By
  • hooleylist's avatar
    hooleylist
    Icon for Cirrostratus rankCirrostratus
    Jan 13, 2010
    Hi Tobin,

     

     

    Is the connection making it to the pool members and back? If not, do you have the default gateway on the SQL servers set to the LTM self IP on their VLAN? If setting the default gateway to LTM isn't an option, you could try enabling SNAT. It would simplify things if you tested with all but one pool member disabled. That would rule out any persistence issues.

     

     

    If you're not doing any inspection of the data, you could use a Perf Layer4 VIP with a FastL4 profile for faster handling of the connections through LTM.

     

     

    If these options still don't work for you, can you post an anonymized copy of your VIP and pool config using 'b virtual VIP_NAME list' and 'b pool POOL_NAME list'? Please also include a description of what you're seeing in the tcpdump on the client and server side.

     

     

    Thanks,

     

    Aaron