Forum Discussion
pjcampbell_7243
Cirrus
CirrusWould you route mysqld through the BIG IP?
Right now we have our servers hitting our primary mysqld directly.
In the event of an outage, we have to manually change ALL the config files which are pointing at the primary. The oth...
dennypayne
Employee
EmployeeAs long as by "master/slave" you mean that your pool will use priority group activation and send the traffic only to the primary server unless it is down, this should work fine. You just don't want to actively load-balance db writes (reads would be OK I would think).
If you had some way to distinguish a read from a write in the payload, you could even do an iRule to load-balance db reads and send the writes to the master. I haven't actually seen anyone implement that yet, though.
Denny
