Forum Discussion
Babyloon00_1038
Nimbostratus
Nimbostratusdb balancing by query
Hi,
I want to make a MySQL farm. One master replicated on many salves.
The app will write on the master & read on one of the slave through a virtual server / pool on the biip.
Is it possible for the bigip to manag all this?
if QUERY is select => go to slave pool
if QUERY is insert/updatE/delete => go to master
I suppose a iRule can manage this, but does anybody know how?
Thx
- If you are loadbalancing just the connections then it should be pretty simple. Just do a TCP::collect and inspect the payload for the query and fowrard to the right pool. But if you want to split the connection then its quite a bit more involved.
blueboxgroup_10Is there an example of how to do this with the collect function?
- Jesse
