Federico Razzoli, Author at Vettabase

About Federico Razzoli

Federico is Vettabase Ltd director, and he's an expert database consultant specialised in the MariaDB and MySQL ecosystems. Federico is also a free software supporter. He believes in information sharing and reciprocal help. He thinks that multiple organisations contributing the same repositoy and benefiting from each other's work are better than many companies re-inventing the wheel. He thinks this view is not just compatible with business, but it's today and tomorrow's way of doing business. Federico also loves beers from the North of Europe, wines from Italy, bagpipes, nature hiking and the history of computing.

Running Ansible inside a dedicated host

Posted on 24 November 2020 by Federico Razzoli — No Comments ↓

Why Ansible should run in a dedicated host, not on devops personal laptops. Continue reading Running Ansible inside a dedicated host→

MariaDB/MySQL IS NULL conditions and indexes

Posted on 14 November 2020 by Federico Razzoli — 2 Comments ↓

It is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow. Continue reading MariaDB/MySQL IS NULL conditions and indexes→

Monitoring that AUTO_INCREMENT values won’t reach the limit

Posted on 13 November 2020 by Federico Razzoli — 1 Comment ↓

AUTO_INCREMENT primary keys are useful, because they save usthe trouble to generate a unique value for every row, delegating this task to the database. But when we reach the limit we need to take some action, or we won’t be able to insert more rows. Continue reading Monitoring that AUTO_INCREMENT values won’t reach the limit→

5 benefits of Infrastructure As Code

Posted on 10 November 2020 by Federico Razzoli — No Comments ↓

Automating deployments with the Architecture As Code paradigm has several benefits. Let’s see some of them. Continue reading 5 benefits of Infrastructure As Code→

MySQL/MariaDB: use SQL properly to run less queries

Posted on 29 October 2020 by Federico Razzoli — No Comments ↓

Reducing the number of queries is important with any DBMS. There are two reasons for this: reducing the latency of applications; and reducing the workload for the database servers. Continue reading MySQL/MariaDB: use SQL properly to run less queries→

The risks of MySQL release policy

Posted on 27 October 2020 by Federico Razzoli — No Comments ↓

MySQL 8.0 and 5.7 follow a new release policy that exposes users to important risks. They broke compatibility with Xtrabackup (again). Continue reading The risks of MySQL release policy→

When to use NULLable columns in relational databases

Posted on 15 October 2020 by Federico Razzoli — No Comments ↓

SQL columns can be NULL or NOT NULL. Let’s see what are the good and bad reasons to declare NULL columns. Continue reading When to use NULLable columns in relational databases→

READ ONLY transactions in MariaDB and MySQL

Posted on 8 October 2020 by Federico Razzoli — No Comments ↓

Transactions can be read only. This article explains what read only transactions are and why we should use them when appropriate. Continue reading READ ONLY transactions in MariaDB and MySQL→

Using CONNECT to access remote MariaDB or MySQL tables

Posted on 23 September 2020 by Federico Razzoli — 2 Comments ↓

This article discusses how to access data from a remote table using the CONNECT storage engine, in MariaDB. Continue reading Using CONNECT to access remote MariaDB or MySQL tables→

A MariaDB Server Fest 2020 review

Posted on 21 September 2020 by Federico Razzoli — No Comments ↓

MariaDB Server Fest 2020 was a great online event for the MariaDB community. This is a review from Vettabase. Continue reading A MariaDB Server Fest 2020 review→