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.

Choosing Cassandra consistency levels

Choosing Cassandra consistency levels

Good practices and advice to use #Cassandra consistency levels in practice, with an eye on performance and scalability ...
READ ONLY transactions in MySQL

READ ONLY transactions in MySQL

MySQL transactions can be read only. Here's how to use them, and why they are useful. ...
Cassandra error on login: Cannot achieve consistency level LOCAL_ONE

Cassandra error on login: Cannot achieve consistency level LOCAL_ONE

Cassandra login fails with: "Cannot achieve consistency level LOCAL_ONE"? Let's see why it happens, and how to solve the problem ...
Why MySQL tables need a primary key

Why MySQL tables need a primary key

In MySQL and MariaDB, all tables should have a primary key - especially InnoDB tables - this is almost common wisdom. But why? Let's discuss the reasons. ...
MySQL/MariaDB: use SQL properly to run less queries

MySQL/MariaDB: use SQL properly to run less queries

Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose. ...