MySQL Proxy iApp
Problem this snippet solves:
It is likely the MySQL proxy iRule will not work unless you are running BIG-IP 11.1 and MySQL 5.1, which were the versions tested against. Please contact your F5 salesperson to request this functionality be added natively to BIG-IP ¶ iApp 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.
This iApp uses iRule functionality that is only available on BIG-IP versions 11.1.0 and later.
The latest version of this iApp is named mysql_proxy.2011-12-02
Contributed by: Ryan Corder