Matomo WordPress with an independent Database

WordPress Plugin
#1

Hello, has someone tried using an independent Database for the Matomo Data with the Plugin “Matomo for WordPress”?

Is this possible to achieve?

#2

I would also like to know this!

When updating a live site we sometimes have to push new data from the staging environment, but of course the Matomo data will never be in sync with the staging database. It would be nice if Matomo could write all it’s data to a second database with its own username and password which just stores all the Matomo tables of which there are a lot!

So it would like this normal wordpress database

prefix_options
prefix_users
...
prefix_postmeta
prefix_posts

Second database for just Motomo tables

prefix_matomo_archive_numeric_2023_03
prefix_matomo_brute_force_log
...
prefix_matomo_log_visit
prefix_matomo_user_token_auth
#3

Just installed the “Matomo On-Premise” version and manually added the tracking code to the site. That seems like the best solution for now.

Would still be nice if you could choose to give the Wordpress version separate database credentials. Because having the WP interface is a great feature.

#4

Yes, we also had to migrate to on-premise because of this. Would be a nice feature for the WordPress version.