This iRule is pretty bad ass. Thanks for posting it. I'm going to dig through it and try new things with it for the next couple weeks. What I need to do, specifically, is split all reads/writes to a master/master configuration based on a unique key in the WHERE clause on every SELECT query and a specific SET on INSERTS and UPDATEs. I basically want to put odd ids on one server, and even ids on the other. If either server goes down, they all need to go to he one that's up. Any help is appreciated. I'll let you know how it goes…
-david