Overview The Skinny
Database Proxies provide a single entry point into MySQL for the calling client applications.
Proxies are wonderful tools to handle various situations like a master role switch to another node for maintenance, or for transparency with read and write connections.
However, when the time comes to perform the switch
action, all of the calling clients have been funneled
through the proxy, so identification of the calling host from the
database itself becomes difficult.
The Problem What is going on?
Let’s illustrate how not knowing the source of a client connection can be an issue for the database administrator…
In the following diagram, three client applications connect to a Tungsten Cluster via the Connector proxy:
…
[Read more]