Move to on-premise

maxa88 · October 25, 2019, 12:33pm

I’m working on moving matomo from cloud to on-premises server.
Currently we have ~30 sites and we would like that every site has its own MySQL database.

Is this possible?

Thanks,
Danijel

maxa88 · October 28, 2019, 11:00am

Hi @Lukas,

Is it possible to connect single matomo instance with multiple MySQL DBs?
So to clarify, DB for each site that is added in matomo?

karthik · October 30, 2019, 1:04am

It’s not possible to have separate DB for each site in Matomo.

maxa88 · October 30, 2019, 1:23pm

Thank you for the response

matthieu · October 31, 2019, 1:49am

You can migrate sites from one install to another one using: How do I migrate a particular website in Matomo to a different Matomo installation? FAQ - Analytics Platform - Matomo

see also discussion about multi DBs in Multi tenancy architecture · Issue #15073 · matomo-org/matomo · GitHub

donnajess67 · November 14, 2019, 6:28pm

Well max,

It’s acc possible to have diff n separate DB for sites in Matomo.

I had similar issues with expertplantman but had so many hard times cause of it.