As a DBA, comparing Database Server versions is an important part of preparing an upgrade. You need to know which server options were added or removed, which defaults changed, and what else is different between the versions you are running and the versions you plan to deploy.
When I worked with MySQL, I used a community tool to identify these changes, and it was especially useful when I had to compare versions several releases apart.
Masahiro Tomita (富田 雅浩 / とみた まさひろ) made this tool, and it’s still available: https://mysql-params.tmtms.net.
A Tool to Compare MariaDB Server Versions
I found this tool really useful, and I wanted a similar experience for MariaDB Server, with a few additions.
So, I created a MariaDB Server version: https://mariadb-diff.lefred.be/
With the tool, you can easily identify modifications between multiple versions (up to 8) covering different areas such as:
- server options
- client options
- server status variables
- privileges
- default plugins
- storage engines
- information schema
- keywords
- performance schema
This is a screenshot example of what you could expect from the tool:
Give it a try! If your version isn’t included yet, let me know, and I’ll add it. Currently, I list all the latest major versions.
Enjoy preparing your MariaDB Server upgrades!