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....
I used a Scaleway Dedibox Start-2-S-SATA server for few years. Low price and important storage were the two arguments for choosing it. With time, new services were installed on it using lxd containers for all of them on Debian 11. Lxd daemon is quite cool and allows anyone without important lxc knowledge to deploy and install new services using the cli. The latest deployement I made was a synapse server for matrix coming with a (one more) Postgres database....
The main purpose of this script is to generate a diagram such as Wireshark do with sip/rtp captures, obviously without the need to open Wireshark and using your mouse. More over, it can be used to automatically generate diagrams from a bunch of pcap or directly in a web interface. Whis this need and the desire to discover a little more python I tried to develop a script which is by the way not (I guess) the best way to achieve, but it works and this is what I want !...