(David Ducos) A lot of things have been said about UUID, and storing UUID in an optimized way. Now that we have generated columns, we can store the decomposed information inside the UUID and merge it again with generated columns. This blog post demonstrates this process.

(Chaithra Gopalareddy) Starting with MySQL 8.0.1, the server supports the SQL GROUPING function. The GROUPING function is used to distinguish between a NULL representing the set of all values in a super-aggregate row (produced by a ROLLUP operation) from a NULL in a regular row.

(Jörg Brühe) Most (relational) DBAs and DB application developers know the concept of a primary key (“PK”) and what it is good for. However, much too often one still encounters table definitions without a PK.

(Marcelo Altmann) My last post about backups was a while ago. Although it is still valid, it’s not advisable to use it as daily backup. For that we can use XtraBackup.

(Rob Gravelle) Ask a database administrator (DBA) to name their most cherished tool, and they’ll usually say it’s their database management (DBM) system. Sure, there is the occasional hold-out that hasn’t moved on since the days that DBAs used the command line to create, edit, and delete databases,

(Federico Razzoli) One of the annoying limitations of MySQL/MariaDB stored procedures is the lack of a FOREACH construct, which loops on each row returned by a query.

(Lalit) In this blog post, we are going to test load balancer solution for MySQL high availability by integrating it with Keepalived, HAProxy, xinetd software components.

(Giuseppe Maxia) A few months ago I wrote about showing the hidden tables in MySQL 8 data dictionary.

(Vitor Oliveira) MySQL 8.0.1 introduces new features and improvements to replication. The next sections summarize some related to performance.

(Sheeri K. Cabral) One task that can really help reduce future problems is to do a periodic query review. I’ve been using pt-query-digest to do this since 2010 (back when it was part of Ma’atkit, mk-query-digest!), and while I have presented the idea several times at conferences, I have never blogge