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....
We often have to authenticate against a socks proxy for differents purposes :
access to a website establish a ssh connection -… Here I’m going to explain how to do it permanently and in a transparent way for the system.
My need here is to avoid manual connection involving login and password I could’nt remember 😉
How it works Iptables rules redirect trafic for a specific destination to a local port....
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....