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.

Certifié ISO 27001:2022

Vos données analytics sont protégées par des standards de sécurité reconnus à l’international. La certification ISO 27001 garantit que nous appliquons les plus hauts standards de gestion de la sécurité de l’information.

En savoir plus
Sites web en ligne à travers le monde
0 K
de sites web ont utilisé Matomo
0 M
de satisfaction client
0 %

Gardez le contrôle de vos données. Respectez la vie privée de vos utilisateurs. Accédez à des analyses plus performantes.

Les organisations devraient pouvoir comprendre leurs performances numériques tout en conservant la pleine propriété et le contrôle de leurs données.

Démarrez avec un essai gratuit

Aucune carte bancaire requise.