Welcome to Federico-Razzoli.com



I am a freelancer database consultant, specialised in MySQL and other open source databases.

Feel free to browse my free contents. My articles will help you in your job and will satisfy some of your curiosities.

Learn about me and my professional services. Please contact me for any question.


Important notice:
Because of the global health situation,
currently all Database Consulting services take place remotely.


Knowledge Base

Federico-Razzoli.com articles aim to form a shared knowledge base on open source database systems. Feel free to read, contribute with comments, and share links to these contents.

Testing database backups

Testing database backups

Backups need to be tested to avoid epic incidents like the one occurred to GitLab in 2017. But how should they be tested, and what should we monitor exactly? ...
Use cases for MariaDB Invisible Columns

Use cases for MariaDB Invisible Columns

Invisible columns are columns that are not returned by a SELECT *. Their use cases are not obvious. ...
Practical advice for MySQL/MariaDB live migrations

Practical advice for MySQL/MariaDB live migrations

Modifying table structures is sometimes necessary, or desirable. Modifying them online can be a pain, especially with big tables. Migrations should be ran properly in production. ...
PostgreSQL hstore: key/value in relational tables

PostgreSQL hstore: key/value in relational tables

hstore is a PostgreSQL extension that allows to store key/value pairs in relational tables and work with them. ...
Understanding tables usage with User Statistics (Percona Server, MariaDB)

Understanding tables usage with User Statistics (Percona Server, MariaDB)

Let's use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter. ...