by Fernando Laudares Camargos | Jul 2, 2025 | Benchmarks, PostgreSQL, ProxySQL
In the first post of this series (Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 1: How-To), I presented my test environment and methodology and explained how to install ReadySet, ProxySQL, and HAproxy and configure them to work...
by Fernando Laudares Camargos | Jul 1, 2025 | Benchmarks, PostgreSQL, ProxySQL
A couple of weeks ago, I attended a PGDay event in Blumenau, a city not far away from where I live in Brazil. Opening the day were former Percona colleagues Marcelo Altmann and Wagner Bianchi, showcasing ReadySet’s support for PostgreSQL. Readyset is a...
by Ananias Tsalouchidis | Apr 1, 2024 | Insight for DBAs, MySQL, ProxySQL
ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following: Added support for caching_sha2_password! This is great news for the community! The caching_sha2_password authentication method for frontend connections is now...
by Balchandar Reddy Voodem | Jan 3, 2024 | Insight for DBAs, MySQL, ProxySQL
ProxySQL is a high-performance SQL proxy that runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime. The daemon accepts incoming traffic from MySQL clients and forwards it to backend...
by Balchandar Reddy Voodem | Sep 25, 2023 | Insight for DBAs, MySQL, ProxySQL
ProxySQL is a high-performance SQL proxy, which runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime. The daemon accepts incoming traffic from MySQL clients and forwards it to backend...
by Abhinav Gupta | Apr 24, 2023 | MySQL, ProxySQL, Security
In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format only. Also, even if someone stored the password in cleartext, we see how to change those into the hashed format easily. Here we are just highlighting one...
by Mike Benshoof | Apr 4, 2023 | Insight for DBAs, MySQL, ProxySQL
When talking about the benefits and use cases of ProxySQL with clients, one feature I generally reference is the query rewrite engine. This is a great feature that is often used for sharding (I’ve written about this in the past at Horizontal Scaling in MySQL –...
by Marco Tusa | Mar 20, 2023 | Benchmarks, Cloud, MySQL, ProxySQL
With a special focus on Percona Operator for MySQL Overview HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture, many components need to be...
by Yunus Shaikh | Dec 5, 2022 | MySQL, ProxySQL
ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. It is a proven tool and is used largely in production. There can be an instance of ProxySQL using a lot of...
by Marco Tusa | Nov 10, 2022 | MySQL, Percona Software, ProxySQL, Security
Every day we use dozens if not hundreds of applications connecting to some kind of data repository. This simple step is normally executed over the network and, given so, it is subject to possible sniffing with all the possible related consequences. Given that, it is...
by Sri Sakthivel | Oct 12, 2021 | MySQL, ProxySQL
ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused...
by Ivan Groenewold | Oct 7, 2021 | Cloud, MySQL, Percona Software, ProxySQL
There are plenty of ways to run ProxySQL in Kubernetes (K8S). For example, we can deploy sidecar containers on the application pods, or run a dedicated ProxySQL service with its own pods. We are going to discuss the latter approach, which is more likely to be used...
by Kenn Takara | Jun 18, 2021 | MySQL, ProxySQL, Security
Starting with the release of proxysql-admin 2.0.15, the proxysql-admin 2.x series can now encrypt the credentials needed to access proxysql and cluster nodes. This only applies to the proxysql-admin configuration, this does not change the ProxySQL config, so those...
by Ivan Groenewold | Jan 28, 2021 | Cloud, MySQL, ProxySQL
There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How scheduler and script stand in supporting failover (Percona and Marco example) In part one of this series, I had illustrated how simple scenarios may fail or have problems when using Galera native support inside ProxySQL. In this post, I will repeat the same...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0) In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona...
by Marco Tusa | Oct 9, 2020 | Benchmarks, Cloud, MySQL, ProxySQL
For what reason should I use a real multi-primary setup? To be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for Percona XtraDB Cluster (PXC) or Percona Server for MySQL using Group_replication. No, we are talking...
by Daniel Guzmán Burgos | Oct 2, 2020 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control writes to the database, is the Rate limit. It’s also lately one of the most popular conversations around the community. But what is it? In plain...
by David Ducos | Aug 28, 2020 | Insight for DBAs, MySQL, Open Source, ProxySQL
We sometimes receive challenging requests… this is a story about one of those times. The customer has implemented a sharding solution and would like us to review alternatives or improvements. We analyzed the possibility of using ProxySQL as it looked to be a...
by Peter Zaitsev | Aug 28, 2020 | Insight for DBAs, MySQL, ProxySQL
ProxySQL brings a lot of value to your MySQL infrastructures such as Caching or Connection Multiplexing but it does not come free — your database needs to go through additional processing traffic which adds some overhead. In this blog post, we’re going to discuss...
