Introduction
We are well aware that ProxySQL is one of the leading SQL aware proxy for MySQL. In this blog I am going to explain the backup & restore strategies of the ProxySQL . I think, still there is not well structured blog about this topic .
If you are looking for other articles on our ProxySQL Series :
[Read more]Introduction –
At Mydbops we are exploring the latest MySQL technologies . Recently i was worked for one of our client the project. The requirement is setting up a three node InnoDB cluster with 3 node ProxySQL cluster . During my ProxySQL configuration, i discovered that the ProxySQL group replication host groups are not loading from ProxySQL config file . Then i reached the ProxySQL official website and found that they are already have the bug for this issue and provided the fix as well ( BUG #1050 ). The fixed version is ProxySQL 1.4.9 .
I just had the interest to write the blog about this behaviour, as …
[Read more]We know that MySQL query cache is deprecated as of MySQL 5.7.20 and removed in MySQL 8.0 and It has been recommended to use ProxySQL (or other) external query cache instead.
In this blog post, we’ll present the ProxySQL query cache functionality and how does it help us.
How to setup ProxySQL between client and database servers is out of the scope of this article.
If you are looking for other articles on ProxySQL Series :
[Read more]In this blog we are going to see how to implement Proxysql for Amazon Aurora RDS, this would be next in series of ProxySQL blogs. Below is the list of our previous blogs on ProxySQL which provides deeper insights based on different use cases and different architecture.
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.
ProxySQL can be greatly configured with MHA for …
[Read more]This is part-4 of the Maxscale Blog series
Maxscale started supporting Amazon Aurora lately from its version 2.1 which comes with a BSL license, we are good until we use only 3 nodes, …
[Read more]At Mydbops we always thrive to provide the best MySQL Solutions. We are exploring the modern SQL load balancers. We have planned to write a series of blog on ProxySQL.
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 ?
A few most commonly used features are : …
[Read more]