MySQL read/write Proxy

Thanks for the great contribution on this Ryan!

 

 

Aaron

This is indeed some awesome stuff. I think Tech Tip worthy, personally. Adding it to the list to bother Ryan about later. ;)

 

 

Colin

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