spamjoshua_8666
Feb 05, 2009Nimbostratus
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