Mariadb

Binary logs in MySQL: what they are, how to manage them, and when you can delete them

A MySQL server with disk at 95%, 180 GB of binary logs accumulated over six months. From there, a deep dive into binlogs: what they contain, why they exist, how they work with replication and point-in-time recovery, and above all how to manage them without breaking things.

31 March 2026·10 mins

Galera Cluster with 3 nodes: how I solved a MySQL availability problem

A client with a standalone MySQL that crashed every month, taking down the entire application. My solution: a 3-node Galera Cluster with synchronous replication. From diagnosis to production, with all configuration files and critical parameters.

17 February 2026·12 mins

MySQL Users: Why 'mario' and 'mario'@'localhost' Are Not the Same Person

In MySQL and MariaDB a user's identity depends on the host they connect from. A real case, the authentication model explained in depth and the most common mistakes in access management.

13 January 2026·6 mins