MariaDB introduced ignored Indexes in version 10.6. The feature is substantially very similar to MySQL Invisible Indexes (docs), introduced in version 8.0. Here we'll see how to use Ignored Indexes drop indexes in production with a reasonable risk. See our MariaDB...
Federico Razzoli
Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL
Indexes are designed to speed up queries against a table. However, they come with a cost: every time a INSERT/UPDATE/DELETE statement is executed against a table, its indexes must be updated. And since indexes are ordered data structures, updating them is more...
First impressions about immudb, the immutable database
I keep an eye on new database technologies, and I kept an eye on immudb for some time. So I was excited when I've read the immudb 1.0.0 release announcement! And I decided to make some experiments with it, and make my impressions public. I would like to mention that,...
The risks of replication filters in MariaDB and MySQL
MariaDB and MySQL support what they call replication filters. This feature allows us to determine which tables are replicated, and which are not. Filters can be set on a replica to filter-in tables and databases: the replica will not replicate everything...
MariaDB Temporal tables Q&A
Federico Razzoli at MariaDB Server Fest 2020
MariaDB, MySQL and Ansible: automating database infrastructures
Federico Razzoli at MinervaDB Athena 2020
Creating Vagrant development machines for MariaDB
Federico Razzoli at FOSDEM 2021
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...