I’m trying to make Piwik scale to multiple machines, and I really want your help or opinion. The main thing is to improve the speed that the results are returned from an API call.
The ways I’m thinking to tackle this are by:
- Having one writer & multiple reader Piwik instances that point to the same MySQL database. Then disable the archiving function in all the readers, and only enable it in the writer. But I haven’t found a way to disable it yet.
- MySQL replication
- Memcached, either in Piwik or in a different server.
Another questions are:
Are there any crontabs in the default Piwik installation?
When do the Archive functions get executed?
I’m thinking to implement all of the above, but I am not sure where to start in some. Would it be enough? Are there any disadvantages? Thanks.
Any other opinions to scale it are welcome.