I am working on adding MediaViewer opt-out result tracking to multimedia-metrics.wmflabs.org (which maps to limn1). Opt-out data is stored in the mediawiki databases, but only the current state, so I have to store the daily results somewhere to be able to show a timechart. I'm asking for advice on the best way to do that.

The two obvious approaches are:

- store the results in mysql on the same server that holds the wiki db (analytics-store.eqiad.wmnet)

- store them in mysql locally, on the limn1 instance

The first seems easier to me, since the second would mean transferring data between different DB servers, which is awkward in MySQL; but I don't know well the setup of limn1 and analytics-store. Is there any reason to take the other route (or some third way)? If not, what's the way to get a new DB created on analytics-store where I can store the results?

thanks

Gergő