I’m thinking of installing Piwik, an open source alternative to Google Analytics. It’ll be used on popular websites, sites that could potentially generate millions of hits a day.
Piwik stores its information into a MySQL database. So I’m wondering, how stable would MySQL be doing millions upon millions of writes a day? Size of the database I’m not too concerned about. Everyday reports will be generated and the data flushed, but during the day the db will be hit hard with writes.
Anyone have architectural choices? Different db engine for mysql? Maybe MySQL isn’t up to this task?