Forum Discussion

spamjoshua_8666's avatar
spamjoshua_8666
Icon for Nimbostratus rankNimbostratus
Feb 05, 2009

MySQL Clustering and GRANT Permissions

 

Hello all,

 

 

I am trying to figure out how to cluster a collection of read-only MySQL databases behind an F5, and at the same time to ensure that the MySQL servers see the originating client IP address in order to work with the MySQL permissions structure.

 

 

It seems SNAT is needed, but without an x-forwarded for type of option for the MySQL client protocol, I have no idea how to keep the client IP visible to the backend servers.

 

 

All insight would be appreciated.

 

 

Thank you,

 

Joshua
config
design
  • dennypayne's avatar
    dennypayne
    Icon for Employee rankEmployee
    Feb 06, 2009
    If you can design the network such that the MySQL servers use the LTM as their default gateway, then you don't need to SNAT. Not sure how difficult that would be without more detail of your current configuration.

     

     

    Denny
  • JRahm's avatar
    JRahm
    Icon for Admin rankAdmin
    Feb 09, 2009
    If the other systems are local to the subnet, there shouldn't be a need for a route, layer 2 discovery will take care of that. If the others systems are available through another layer 3 gateway (besides the LTM), you can simply add persistent routes for those destinations to your server's routing table, pointed at the appropriate gateway.