by Daniel Guzmán Burgos | Jul 3, 2020 | Cloud, MySQL, Percona Software, ProxySQL
The Percona Kubernetes Operator for Percona XtraDB Cluster(PXC) comes with ProxySQL as part of the deal. And to be honest, the behavior of ProxySQL is pretty much the same as in a regular non-k8s deployment of it. So why bother to write a blog about it? Because what...
by Marco Tusa | Jul 1, 2020 | MySQL, Percona Software, ProxySQL
In real life, there are frequent cases where getting a running application to work correctly is strongly dependent on consistent write/read operations. This is no issue when using a single data node as a provider, but it becomes more concerning and challenging when...
by Tibor Korocz | Apr 28, 2020 | MySQL, Percona Software, ProxySQL
In this blog post I would like to give an overview of the most common failover scenarios and operations when using MySQL Group Replication 8.0.19 (aka GR) and Percona XtraDB Cluster 8 (PXC) (which is based on Galera), and explain how each technology handles each...
by Peter Zaitsev | Apr 14, 2020 | Benchmarks, MySQL, ProxySQL
When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good choice to run a benchmark program, as well as the database, on the same server. This is in order to eliminate network impact and to look at single-thread...
by Peter Zaitsev | Apr 8, 2020 | MySQL, Percona Software, ProxySQL
This article describes how to install ProxySQL from the Percona Software Repositories. Percona Software Repositories contain a ProxySQL version that has passed rigorous Percona tests and is known to be compatible with other Percona Software. We recommend using those...
by Walter Garcia | Apr 2, 2020 | MySQL, ProxySQL, Security
In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config...
by Jake Davis | Mar 23, 2020 | Insight for DBAs, ProxySQL
Recently, a client of ours, Duolingo, was using Aurora was reaching the max connection limit of 16,000 (that is Aurora’s hard limit for all instance classes). In this case, Percona recommended implementing ProxySQL to manage connections (now their max connections only...
by Ceri Williams | Mar 6, 2020 | MySQL, Open Source, ProxySQL
In the MySQL ecosystem, orchestrator is the most popular and well-respected high availability and topology management tool, integrating well with other solutions such as ProxySQL. It facilitates automatic (or manual) discovery, refactoring and recovery of a replicated...
by Marcelo Altmann | Feb 18, 2020 | ProxySQL
by Borys Belinsky | Feb 11, 2020 | MySQL, Percona Software, ProxySQL
ProxySQL 1.4.16, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL, and database servers in the MySQL ecosystem...
by Daniel Guzmán Burgos | Jan 21, 2020 | Cloud, MySQL, Percona Software, ProxySQL
Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?”. And the answer is – not that different than with other cloud vendors. What one needs is two things (and this applies...
by Walter Garcia | Jan 10, 2020 | MySQL, Percona Software, ProxySQL
If you are thinking of using ProxySQL in our Percona XtraDB Cluster environment, I’ll explain how to use ProxySQL 2 for failover tasks. How to Test ProxySQL uses the “weight” column to define who is the WRITER node. For this example, I’ll use...
by David Ducos | Jan 2, 2020 | MySQL, ProxySQL
ProxySQL and Orchestrator are usually installed to achieve high availability when using MySQL replication. On a failover (or graceful takeover) scenario, Orchestrator will promote a slave, and ProxySQL will redirect the traffic. Depending on how your environment is...
by Borys Belinsky | Oct 23, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.7, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includesPSQLADM-204: Add support of...
by Borys Belinsky | Aug 21, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.6, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includesDocker images for release...
by Walter Garcia | Aug 14, 2019 | ProxySQL
In this post, we will manage ProxySQL Cluster with “core” and “satellite” nodes. What does that mean? Well, in hundreds of nodes, only one change in one of those nodes will replicate to the entire cluster. Any mistake or changes will replicate...
by Borys Belinsky | Aug 12, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.5, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includes Docker images for release...
by Borys Belinsky | May 28, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.4, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for...
by Borys Belinsky | May 7, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL 2.0.3, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL, and database servers in the MySQL ecosystem...
