Matomo analytics database: migrating from MySQL to MariaDB

Contents

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 uses the open source database server MySQL to store the analytics data.

Matomo 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 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 will stay compatible with both MySQL and MariaDB.

Enjoyed this post?
Join the 160,000+ subscribers who receive the Matomo Newsletter straight to their inbox every month
Get started with Matomo

A powerful web analytics platform that gives you and your business 100% data ownership and user privacy protection.

No credit card required.

Free forever.

Get started with Matomo

A powerful web analytics platform that gives you and your business 100% data ownership and user privacy protection.

No credit card required.

Free forever.