Load Balanced ProxySQL in Google Cloud

There are three different ways ProxySQL can direct traffic between your application and the back-end MySQL services.

1. Locally, on the MySQL servers.
2. Between the MySQL servers and the application.
3. Colocated on the application servers themselves.

Without going through too much detail, each has its own limitations. In the first form, the application needs to know about all MySQL servers at any given point in time. With the third form, a large number of application servers, especially in the age of Kubernetes, where apps can simply recycle easily or be scaled up and down, backend connections can increase exponentially leading to issues.

from DZone.com Feed http://bit.ly/2GKlFaT