There are three different ways ProxySQL can direct traffic between your application and the backend MySQL services.
Locally, on the MySQL servers.
Between the MySQL servers and the application.
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 […]Read more