pjcampbell_7243
Apr 09, 2009Cirrus
Would 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 other option is to somehow redirect traffic from the IP of the primary to the secondary.
Based on conversation with F5 support, they don't particularly recommend routing local mysql traffic through the BIG IP, however they do not have any reason that it wouldn't work.
Could anyone share any thoughts either way on this? positives or negatives.
The biggest advantage, I see, is that in the event of a fail over (even if it is manual), 2 clicks on the BIG IP will do it, as well as the option for automatic failover.
This is a master/slave setup, not master/master.