Hi 👋,

And welcome on this small website.

  • More a notebook than anything else, you will find here something like a resume and sometimes technical writes (or not).

  • You can contact me in different ways, I prefer matrix (note that the link below will redirect to element.io).

  • But you can also send me an email : manu+site [at] unam [dot] bzh . Please search and replace what you think necessary in this email address 🥸

From a single ProxySQL server to a cluster setup

Introduction 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

How to deploy ProxySQL in front of MySQL

Introduction 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....

January 10, 2023 · 5 min · Unam

Permanent and automatic socks5 connection system-wide

Introduction 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....

May 1, 2022 · 3 min · Unam

From standalone lxd on Debian to lxc on Proxmox

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....

January 1, 2022 · 3 min · Unam

Create a call diagram with mermaid from a pcap file

Introduction 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 !...

December 1, 2021 · 4 min · Unam