MariaDB

A Hidden Gem in MySQL: MyRocks

using MyRocks in MySQL

In this blog post, we will share some experiences with the hidden gem in MySQL called MyRocks, a storage engine for MySQL’s famous pluggable storage engine system. MyRocks is based on RocksDB which is a fork of LevelDB. In short, it’s another key-value store based on LSM-tree, thus granting it some distinctive features compared […]

Read more

Observability Differences Between MySQL 8 and MariaDB 10.4

mysql mariadb observability

I did a MariaDB Observability talk at MariaDB Day in Brussels, which  I roughly based on the MySQL 8 Observability talk I gave earlier in the year. This process pushed me to contrast MySQL and MariaDB observability.
In summary, there are a lot of differences that have accumulated through the years; a lot more than […]

Read more

Webinar 2/6: MySQL 8 vs. MariaDB 10.4

MySQL 8 vs. MariaDB 10.4

At the moment, MySQL 8 and MariaDB 10.4 are the latest versions of the corresponding database management systems. Each of these DBMS has a unique set of features. For example, specific MariaDB features might be unavailable in MySQL, and vice versa. In this presentation, we’ll cover these new features and provide recommendations regarding which […]

Read more

Use MySQL Without a Password (and Still be Secure)

Use MySQL Without a Password

Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket.
Neither of these plugins is new, and some words have been written about the auth_socket on this blog before, for example: how to change passwords in MySQL […]

Read more

Percona Toolkit 3.1.0 Is Now Available

Percona Toolkit

Percona announces the release of from the website or install PT-1696: the new pt-pg-summary tool supports PostgreSQL data collection in a way similar to other PT summary tools. The following is a fragment of the report that the tool produces:

Shell

##### — Database Port and Data_Directory — ####
+———————-+—————————————————-+
| Name […]

Read more