MYSQL load balancing using LTM

I think the most common and useful scenario LTM can support for databases is to have two members in a pool and use UIE persistence to ensure requests go to the currently active unit until it fails. If the first pool member is marked down, the second pool member would receive all connections even after the first member comes back up. Here is the iRule for this:

 

 

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

 

 

Does this look like a good solution for your scenario?

 

 

Aaron