F5 is upgrading its customer support chat feature on My.F5.com. Chat support will be unavailable from 6am-10am PST on 1/20/26. Refer to K000159584 for details.

Forum Discussion

Fabrizio_Chiava's avatar
Fabrizio_Chiava
Icon for Nimbostratus rankNimbostratus
Aug 06, 2010

loggin SQL transaction

Hello everybody,   I have got a DB architecture with web server that open SQL session to DB in other part of network and write data on DB. I would to load balance this transaction with BIGIP and I...
management
monitoring
hoolio's avatar
hoolio
Icon for Cirrostratus rankCirrostratus
Aug 06, 2010
Hi Fabrizio,

 

 

You can do layer 4 load balancing of SQL connections using LTM. Most people use a single active pool member at a time and a simple iRule to persist to the currently active server:

 

 

http://devcentral.f5.com/wiki/default.aspx/iRules/SingleNodePersistence.html

 

 

If you're looking to split reads and writes to separate servers or pools, it gets more complicated:

 

http://devcentral.f5.com/Forums/tabid/1082223/asg/50/showtab/groupforums/aff/5/aft/2085/afv/topic/Default.aspx

 

 

Aaron