Matomo analytics database: migrating from MySQL to MariaDB

Contents

Ready to use in minutes, Matomo gives you:
✔ Accurate privacy-first analytics
✔ Full data ownership
✔ GDPR compliance

Start with Matomo

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.

Get started with Matomo

By choosing Matomo, the ethical analytics alternative, you won’t make privacy sacrifices or compromise your site.

Try it for free
Live Demo
Recommended for you
Enjoyed this post?
Join the 160,000+ subscribers who receive the Matomo Newsletter straight to their inbox every month

Subscribe to our newsletter to receive regular information about Matomo. You can unsubscribe at any time from it. This service uses SendGrid. Learn more about it within our privacy Policy page.

Certified ISO 27001:2022

Your analytics data is protected by globally recognised security standards. ISO 27001 certification means we follow the highest international standards for information security management.

Read more
Live websites using Matomo worldwide
0 K
Websites using Matomo including historical
0 M
Customer satisfaction
0 %

Own your data. Protect your privacy. Unlock better analytics.

Organisations should be able to understand their digital performance while mainteaning full ownership and control of their data.

Start Your Free Trial

No credit card required.