During the last few months we had a lot of opportunities to
present and discuss about a very powerful tool that will become
more and more used in the architectures supporting MySQL,
ProxySQL is becoming every day more flexible, solid, performant
and used (http://www.proxysql.com/ and recent http://www.proxysql.com/compare).
This is it, the tool is a winner in comparing it with similar
ones, and we all need to have a clear(er) idea on how integrate
it in our architectures in order to achieve the best results.
The first to keep in mind is that ProxySQL is not natively
supporting any high availability solution, in short we can setup
a cluster of MySQL(s) and achieve 4 or even 5 nines of HA, but if
we include ProxySQL, as it is, and as single …[Read more]