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.

Consistency Level patterns for high accuracy in Cassandra

Consistency Level patterns for high accuracy in Cassandra

Cassandra allows to theoretically achieve the maximum accuracy. To achieve this, we can set proper Consistency Levels. ...
MySQL backup methods comparison

MySQL backup methods comparison

MySQL backups can be made in several ways. Each method has pro's and con's. ...
Sizing Aria Pagecache

Sizing Aria Pagecache

Aria is a MariaDB storage engine that is always used internally. Its pagecache is the equivalent of InnoDB buffer pool, and this article is about sizing it properly. ...
Webinar: MySQL Backups

Webinar: MySQL Backups

It is important to understand which types of backups are available for MySQL and MariaDB databases, and to choose the best ones to use for a given use case. The webinar also gave hints to plan proper backup strategies, and to test them. ...
Can we shrink InnoDB Buffer Pool?

Can we shrink InnoDB Buffer Pool?

It's not easy to find out if InnoDB Buffer Pool is oversized. However shrinking it could greatly reduce the resources we need and pay, and even improve performance. ...