ProxySQL is the most preferred and is widely used for load-balancing MySQL workload, thanks to Rene Cannon & Team for the great tool, and kudos on the recent release of ProxySQL 1.4.10, with a lot of bug fixes. ProxySQL is simple in design, lightweight, highly efficient and feature rich, We have been working with ProxySQL in production for our client quite a sometime, we have also shared some of our encounters/experience and use cases in the below blogs.[Read more]
This is our third blog in the ProxySQL Series
This blog post explains one of the very important use case of ProxySQL called Mirroring.
Mirroring in ProxySQL is not an equivalent to MySQL replication. Also it does not guarantee data consistency across the servers but still there are a few cases where this feature of ProxySQL can take advantage.
Let us consider we have Master-Slave replication running behind ProxySQL with MySQL 5.6 Writes and Reads are served by Master and Slave …[Read more]
This is our second blog in the ProxySQL Series ( Blog I MySQL Replication Read-write Split up ). Will cover how to integrate ProxySQL with MHA to handle failover of Database servers.
We already have Master – Slave replication setup behind ProxySQL from previous blog [ProxySQL On MySQL Replication]
For this setup we have added one more node for MHA Manager , Which will keep eye on Master and Slave status.
- node5 (172.17.0.5) , MHA Manager
ProxySQL can be greatly configured with MHA for …[Read more]
The first blog in this series is how to set up ProxySQL for MySQL Replication Topology including Read / Write Split and some background over ProxySQL.
What is ProxySQL ?
- ProxySQL is a open-source high-performance SQL aware proxy. It runs as a daemon watched by a monitoring process.
- ProxySQL seats between application and db servers.
- The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers.
A few most commonly used features are : …[Read more]