Forum Discussion

pjcampbell_7243's avatar
pjcampbell_7243
Icon for Cirrus rankCirrus
Apr 09, 2009

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.
config
design
  • pjcampbell_7243's avatar
    pjcampbell_7243
    Icon for Cirrus rankCirrus
    Apr 16, 2009
    Just wanted to bump this up.

     

     

    I know it is not the most ideal situation, but I feel like it would be a huge upgrade from our current lack of redundancy. Any reasons NOT to proceed with this?
  • hoolio's avatar
    hoolio
    Icon for Cirrostratus rankCirrostratus
    Apr 16, 2009
    We're considering this for a customer's Oracle DB in the same scenario (manual failover to start with). I can't see any issues and do see the advantage of having a constant IP:port for the app servers to reference.

     

     

    Anyone have experience with this?

     

     

    Thanks,

     

    Aaron
  • dennypayne's avatar
    dennypayne
    Icon for Employee rankEmployee
    Apr 16, 2009
    As 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
  • steve_88008's avatar
    steve_88008
    Icon for Nimbostratus rankNimbostratus
    Apr 21, 2009

     

    would a GTM be a better fit for this task, provided you went from Ip to names in the config of the servers?
  • hoolio's avatar
    hoolio
    Icon for Cirrostratus rankCirrostratus
    Apr 22, 2009
    I don't think you'd want to have an app doing a DNS lookup to find out which IP address to connect to for SQL calls. The latency involved would probably be a major issue.

     

     

    Aaron
  • JRahm's avatar
    JRahm
    Icon for Admin rankAdmin
    Apr 22, 2009
    Depends on the use case, I suppose. I've used GTM for this function in the datacenter and it works quite nicely.