MySQL / MariaDB proxy using ProxySQL on Debian

It can be interesting to have a proxy in front of databases servers. Even if your configuration involve a single server, this proxy can be used to do query cache or query monitoring for example. In this article serie I’ll talk about ProxySQL that I discovered a few weeks ago, why it’s a powerfull tool for many use cases and why - if you are looking for a “query routing” solution in front of your databases servers - you should take a look at....

October 2, 2022 · 5 min · Unam

From a single ProxySQL server to a cluster setup

In this article I talked about a single ProxySQL in front of multiple databases servers. We often need replicated configuration. This can be usefull (but not mandatory) to be prepared for the next step : high availability. How to configure a ProxySQL cluster Since the version 2, ProxySQL has a builtin replication mechanism. This means that the software is able to replicate some of its table to another ProxySQL instance....

January 12, 2023 · 2 min · Unam