Analytics/Systems/Piwik

From Wikitech
Jump to: navigation, search

Our production piwik instance can be reached at https://piwik.wikimedia.org. it has two layer authentication, a first one with ldap credentials and another one with piwik user/password. To get the password talk to Dan Andreescu (milimetric on IRC)

Tuning

We had an expected performance problem while tracking a larger website, which we fixed with their adviceː http://piwik.org/docs/setup-auto-archiving/

The cron we set up with this technique is at

bohrium.eqiad.wmnet:/etc/cron.d/piwik-archive

and logs to

/var/log/piwik/piwik-archive.loɡ

Known outages

  • Nov 23 2017: due to a Ganeti failure (more details in https://phabricator.wikimedia.org/T181121) the bohrium virtual machine (running Piwik and its mysql database) got stopped in a non graceful way, ending up in a InnoDB table corruption. We had to restore the last mysql backup happened on Nov 22, so almost all the data related to Nov 23 has not been recorded.