Forum Discussion

Laehr_53239's avatar
Laehr_53239
Icon for Nimbostratus rankNimbostratus
Feb 14, 2011

MYSQL load balancing using LTM

Hello All     Hope everyone is doing fine.     I need to configure a Mysql Load balancer using the F5's LTM. Appreciate any help on getting to the solution, a step by step documentation w...
oracle
partner
Ron_Carovano_75's avatar
Ron_Carovano_75
Historic F5 Account
Great news! The MySQL proxy iRule and iApp are now available!

 

 

iRule: http://devcentral.f5.com/wiki/iRules.MySQL-Proxy.ashx

 

 

iApp: http://devcentral.f5.com/wiki/iApp.MySQL-Proxy-iApp.ashx

 

 

iRule to implement Layer 7 full proxy for MySQL servers. This proxy alleviates the need for a developer to modify his/her application to use multiple database handles when scaling from a standalone MySQL server to a Master/Slave cluster. Read-only queries are sent to the slave pool while all others are sent to the master pool.

 

 

Many thanks to rcorder for the post!

 

 

Ron
Jer-O's avatar
Jer-O
Icon for Cirrus rankCirrus
Apr 18, 2017

Where is the actual iRule on the page? I'm reviewing content in the iApp, which provides some insight. But I thought there would be sample code on the iRule version page.

 

Update: Judging from the iApp code, I see that it might be too large to try to include it on the iRule page. I just felt the page was confusing in that there was no sample code.