MariaDB released a new Long Term Support version as Generally Available: 11.8. I always review MariaDB LTS versions once they're GA, so it's time to write a new review. Support and timeline MariaDB 11.8 is the latest Long Term Support version (LTS). The...
You have a beautiful application, but a page is slow. After some investigation, you find out that a query is unexpectedly slow, ruining user experience and causing frustration for you. It is a simple query with a WHERE clause and nothing else. You tried to build an...
Blixy is documenting how to automate MariaDB administration with proper tools Vettabase is a MariaDB Foundation Silver sponsor! MariaDB powers some of the internet's biggest names—Wikipedia, WordPress.com, and Google rely on its robust, enterprise-grade performance....
Running any production database deployment in the cloud requires careful consideration of both performance and security. In this article, I'll share a battle-tested approach for deploying a MariaDB Galera cluster with replicas, a ProxySQL layer in front of them, and...
Most tables have a concept of "duplicate rows", where duplicates should never be allowed. Typical examples are: We have a product table, the name column is UNIQUE. If I'll try to insert a row with a name that already exists, the product I'm trying to insert is a...
During our SQL optimisation training courses, I always stress the need of understanding how databases run SQL queries internally. Which is easier and more intuitive than you'd think, anyway. But if you overlook this aspect, there is always a risk of sticking to simple...
Hey database enthusiasts! We're excited to announce Database Frontiers, a free virtual conference co-organised by Vettabase and BreachDirectory.com, happening on 15th October 2025. Database Frontiers is bringing together brilliant minds from across the database world...
MariaDB SEQUENCE is a storage engine that generates a sequence of positive integer numbers. However, in this article I will show you that it's easy to use SEQUENCE to generate more complex sequences, that are not necessarily numeric. This is a very convenient way to...
MariaDB supports stored procedures written in procedural SQL. Which essentially means "SQL with IF's and loops". Most DBMSs do the same, but every project supports different, incompatible syntaxes. MariaDB implemented Oracle's dialect, called PL/SQL. The base of the...
For a very long time, the EXPLAIN command remained the same in the MariaDB and MySQL world. It was good enough in most cases, but the community welcomed the implementation of extensions and variants. However, MariaDB and MySQL improved it in different ways. So, if...
