Forum Discussion

Pepi_71346's avatar
Pepi_71346
Icon for Nimbostratus rankNimbostratus
Jun 27, 2011

Balancing MySQL Traffic

Hi all!     I need your help.     I want to balance traffic over MySQL databases. I will have two virtual servers, one for read operations and other for write operations. Virtual serve...
application delivery
dev
devops
iRules
hooleylist's avatar
hooleylist
Icon for Cirrostratus rankCirrostratus
Jun 28, 2011
Do you want to split out read requests to one server and write requests to another? If so, I don't think this is really feasible. Just about the only SQL "load balancing" I've seen done on LTM is to always use one server unless it's down and then only use that server even if the first server comes back up. That solution is described here:

 

 

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

 

 

Aaron