Federico Razzoli at FOSDEM 2021
Creating Vagrant development machines for MariaDB
read more
Federico Razzoli
Federico Razzoli is a database professional, with a preference for open source databases, who has been working with DBMSs since year 2000. In the past 20+ years, he served in a number of companies as a DBA, Database Engineer, Database Consultant and Software Developer.
In 2016, Federico summarized his extensive experience with MariaDB in the “Mastering MariaDB” book published by Packt. Being an experienced database events speaker, Federico speaks at professional conferences and meetups and conducts database trainings. He is also a supporter and advocate of open source software.
As the Director of Vettabase, Federico does business worldwide but prefers to do it from Scotland where he lives.
Automate MariaDB Galera deployments with Ansible (Percona Live)
Federico Razzoli at Percona Live 2021
Automate MariaDB Galera deployments with Ansible
Federico Razzoli at MariaDB HA MiniFest 2021
Vettabase is now a MariaDB Foundation Technology Partner
Blixy is documenting how to automate MariaDB administration with proper tools If you look at MariaDB Foundation sponsors page, you will now see the logo of a young, small company following some giants. Yes, it's us: Vettabase. And we're excited about it! As Ian...
Finding an optimal size for Aria Pagecache
I wrote two articles about correctly sizing InnoDB buffer pool: Is InnoDB Buffer Pool big enough? and Can we shrink InnoDB Buffer Pool?. Aria is a MariaDB storage engine that is used for internal temporary tables and, potentially, tables created by the...
How to skip an Ansible task by default
Ansible has a well-known mechanism to only run a certain list of tasks: tags. When we call ansible-playbook with the --tags parameter, we only execute tasks that have one of the specified tasks. There is also a --skip-tags option, which runs all tasks except those...
Can we shrink InnoDB Buffer Pool?
In my previous article, I wrote how to answer the question: Is InnoDB Buffer Pool big enough? But the buffer pool can also be too big. So you may wonder if you can shrink it. Reasons to shrink the Buffer Pool Why would one do such a thing? A common reason is saving...
Is InnoDB Buffer Pool big enough?
InnoDB buffer pool is the most important memory area to allocate. It contains the most frequently read data and index entries from InnoDB tables. Its size is determined by innodb_buffer_pool_size, which is one of the two most important settings for...
Creating dynamic configuration files with Ansible
One of the first problems one finds with automation is building custom configuration files. Don't worry though: it's a simple problem to solve. In this article we discuss how to use Ansible templates to generate proper my.cnf files for each MariaDB host. The template...
Running Ansible on a dedicated host
Many teams run Ansible plays from their laptops. In practice this just works, but this doesn't mean that it's an ideal way of using Ansible. Instead, we suggest to run it inside a dedicated host. In this article you'll find some good reason for that. Security...