You have a beautiful application, but a page is slow. After some investigation, you find out that a query is ...
MySQL
Most tables have a concept of "duplicate rows", where duplicates should never be allowed. Typical examples ...
During our SQL optimisation training courses, I always stress the need of understanding how databases run SQL ...
MariaDB supports stored procedures written in procedural SQL. Which essentially means "SQL with IF's and ...
For a very long time, the EXPLAIN command remained the same in the MariaDB and MySQL world. It was good enough in ...
It's January 2025, so it's a good time to look back, and write my thoughts on the most important events and trends ...
Writer switchover issues with ProxySQL and Galera can feel like an unsolved puzzle. Recently, I encountered two ...
In this article, we'll explain why encrypting tablespaces and binary logs in MySQL is so important. Do expect step-by-step guidelines and practical examples demonstrating common risks coming with non-encryption.
No results found.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.