Matomo analytics database: migrating from MySQL to MariaDB

This short blog post is an announcement regarding the Matomo (Piwik) technology stack.

Matomo compatible with MySQL and MariaDB

Since our first public release Matomo (Piwik) uses the open source database server MySQL to store the analytics data.

Matomo (Piwik) is also compatible with MariaDB. MariaDB is an enhanced, drop-in replacement for MySQL.

Upgrading to MariaDB

Many users from our community as well as Matomo (Piwik) Scalability Experts have confirmed that using MariaDB for Matomo has several advantages. MariaDB has in some cases significantly improved query performance and reliability of Matomo. Because MariaDB 5.5 is a complete drop-in-replacement for MySQL 5.5, upgrading can be as easy as running apt-get install mariadb-server (or equivalent for your platform). Existing third party techologies such as TokuDB (FAQ) and Galera are fully compatible with MariaDB.

Learn more about upgrading to MariaDB: Upgrading from MySQL to MariaDB

In the future, Matomo (Piwik) will stay compatible with both MySQL and MariaDB.

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email