Category Archives: MariaDB

MariaDB is a widely used open source database for both OLTP and OLAP workloads. It was born as a MySQL fork, which makes it very competitive for transactional environments at scale. However, MariaDB Corporation chosen to develop features and optimisation that allows MariaDB to compete with Oracle in the analytics market.

At Vettabase we are MariaDB experts, not just MySQL professional with some knowledge of MariaDB. Here we share hints and insights about MariaDB specific features, optimisations and internals.

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→

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→

Dropping database objects in a safe way

Posted on 28 August 2020 by Federico Razzoli — 3 Comments ↓

Running DROP statements in production is always dangerous. But there are some measures we can take to make them safer. Continue reading Dropping database objects in a safe way→

Logging all MariaDB and MySQL queries into the Slow Log

Posted on 18 August 2020 by Federico Razzoli — 2 Comments ↓

MySQL and MariaDB optionally log slow queries into the Slow Query Log – or just Slow Log, as friends call it. However, there are good reasons to log all the queries, not just some of them. Continue reading Logging all MariaDB and MySQL queries into the Slow Log→

Understanding tables usage with User Statistics on MariaDB and Percona Server

Posted on 12 August 2020 by Federico Razzoli — 2 Comments ↓

User Statistics plugin allows to analyse the way tables are used, which of them are used most – and therefore, on what we need to focus on to optimise the server’s workload. Continue reading Understanding tables usage with User Statistics on MariaDB and Percona Server→

Why Tables need a Primary Key in MariaDB and MySQL

Posted on 10 August 2020 by Federico Razzoli — 3 Comments ↓

In MariaDB and MySQL, all tables should have a primary key – especially InnoDB tables. Here’s why. Continue reading Why Tables need a Primary Key in MariaDB and MySQL→

MariaDB/MySQL: Using views to grant or deny row-level privileges

Posted on 7 August 2020 by Federico Razzoli — 4 Comments ↓

It is possible to prevent some users from seeing a set of rows in a certain table. Continue reading MariaDB/MySQL: Using views to grant or deny row-level privileges→

DROP TABLE improvements in MariaDB

Posted on 6 August 2020 by Federico Razzoli — No Comments ↓

MariaDB implemented several improvements to the DROP TABLE statement. We summarise them here. This article will be kept up to date when MariaDB implements further improvements, in the future. Continue reading DROP TABLE improvements in MariaDB→