After few day on lab with how to archive high speed and volume with Piwik. I have many DB choice to run
Both Cassandra and Spider Storage engine are problem with schema table that difficult to change although you can do it manually database shell. But when you running with Piwik can cause Piwik error and stop to work.
Can you share your experience with Toku ? I've been interested in that one for a long time but never had time and resources to do speed testing. What kills the Piwik experience here is speed when doing "Date range" and "Segmentation based on few IP exclusions".
I only have 100 millions row (about 35 GB) for 3 years of data and it takes 30 minutes to get a report using date range+IP exclusion.
On testing @gaumondp :) I just put on staging last night. Will share you later, sure. :)
Do we have any update on supporting different database schema like maria db with Matamo?
Any help will be highly appreciated.
Maria DB with Matomo should work and there is nothing needed to be changed 👍