Multiple server installation

Support & Bugs
1

We were planning on changing our Piwik installation from one server, to:

  1. DB on one server A
  2. piwik admin on server B
  3. the tracking code on server C

apart from having to run updates to two installations (B/C) are there any further issues that could arise from this layout?

any thoughts much appreciated, regards,
adrian

2

Sounds good, see also the doc: Optimize and Scale Piwik - Analytics Platform - Matomo

3

we’re running windows, are there any plugins/improvements for taking advantage of WinCache at all?

Also, being new to mySQL, are there any example of ini files that are optmised for Piwik? There seem to be so many options for different things that don’t just work out of the box…and many different views on the internet! Am pretty happy with how we’ve got it (reports are now running fine), but clearly if there’s further room for improvement with a couple of tweaks that would be superb!

many thanks,

4

see Optimize and Scale Piwik - Analytics Platform - Matomo

5

am just setting this up (multple servers) and it occurred to me that I need to change the javascript tracking code.

Do I just need to change the pkBaseURL value to:

/stats
/stats
etc.

where the /stats directories pointing to the same Piwik instance. Or will this break something somewhere else? I was hoping to speed things up with less DNS lookups.