I’m trying to split the tracking (piwik.php) and archiving/reporting (archive.php + UI) on different servers because of performance issues. Therefore I’m running mysqldump with all Piwik tables on my tracking server and import the dumpfile on archiving/reporting server. But the dumpfile is getting bigger and bigger.
Which db tables can I exclude from mysqldump without losing any data? Can I limit the rows of “piwik_log_…” for a timerange (last x days)?
Is misc/cron/archive.php changing any tables but “piwik_archive_…”?