September 8, 2017
Native ProxySQL Clustering now available
ProxySQL 1.4.2 now supports Native Clustering!!! ProxySQL enters the club of the software associated with the buzz word "Cluster". This blog post is the first
Read more
August 1, 2017
How to run multiple ProxySQL instances
How to run multiple ProxySQL instances Some time ago I wrote about the ability of running multiple ProxySQL instances listening on the same port(s). This capa
Read more
May 28, 2017
Scaling with ProxySQL Query Cache
MySQL Query Cache Before writing about ProxySQL Query Cache, let's see what MySQL Query Cache is. MySQL Query Cache is a very interesting feature that, quot
Read more
April 17, 2017
On demand query routing - how to prevent downtime on your main MySQL server
In a previous post I wrote about how read/write split is implemented in ProxySQL, and what I believe is the best practice for read/write split on top of MySQL servers: start sending all traffic to MySQL master identify what queries can be routed to the MySQL
Read more
April 16, 2017
Obfuscate data from mysqldump with ProxySQL
While me and Fred were presenting Inexpensive Datamasking for MySQL with ProxySQL at FOSDEM 2017, we got a very interesting question: can ProxySQL be used to ob
Read more
April 13, 2017
MySQL read/write split with ProxySQL
Query routing is one of the core features of ProxySQL. Read/write split is perhaps one of the most common query routing use, while the other most commonly used
Read more
March 19, 2017
Multiple ProxySQL instances on same ports, and seamless upgrade
Since its genesis ProxySQL was designed to be reconfigurable at runtime without restarting it. There are only 2 exceptions: changing the listening ports (work i
Read more
February 22, 2017
Comparing Query Cache in ProxySQL and MaxScale
Few days ago MariaDB announced MaxScale 2.1.0 Beta, and among the new Query Performance capabilities there is Query Cache Filter. Query Cache was among the very
Read more
February 21, 2017
ProxySQL and MaxScale on point select workload
Few days ago MariaDB announced that MaxScale 2.1 is roughly 45% faster than MaxScale 2.0 . I first want to congratulate MaxScale Team: MaxScale 2.1 seems to
Read more
February 19, 2017
Conociendo ProxySQL
Last month, January 2017, two DevOps meetups were organized in Spain with the same topic: "Conociendo ProxySQL", presented by txetxu Velayos, @txetxuvel The
Read more
February 2, 2017
Testing performance of MySQL Group Replication
MySQL Group Replication is a hot topic in MySQL ecosystem. We have been evaluating it in , and it is now time to evaluate its performance, especially now that i
Read more
January 7, 2017
Proxy Wars: comparing ProxySQL to others
MySQL load balancers and proxies are becoming a very hot topic in the last few years. In the near future there will two presentations to compare proxies: T
Read more
July 16, 2016
Galera Awareness and ProxySQL Scheduler
One of the most common requests for ProxySQL is to support Galera Cluster. The Issue Support for Galera requires a lot of features to be added to ProxySQL:
Read more
June 18, 2016
Query rewrite with ProxySQL: use case scenario
One of ProxySQL most interesting features is query rewrite. This functionality is one of the main reasons to write a proxy that sits between the applicatio
Read more
December 29, 2015
ProxySQL vs MaxScale: Persistent Connection, response time, and bugs
A benchmark comparison of ProxySQL and MaxScale focusing on persistent connections, throughput, response time, and critical session-tracking bugs in MaxScale's implementation.
Read more
Showing 41–55 of 55 posts