Last modified: 2014-08-04 13:26:58 UTC
The production, staging, and dev instances of wikimetrics all use the same credentials to connect to labsdb. So if dev or staging run wild and open up as many connections as allowed, they can starve the production instance. Hence, we should use separate labsdb credentials for the different instances. (Especially, since bug 68833 currently bites us too.)
Sorry, used wrong component. EventLogging -> Wikimetrics
(In reply to christian from comment #0) > So if dev or staging run wild and open up as many connections as allowed, > they can starve the production instance. This is not a hypothetical thing: http://lists.wikimedia.org/pipermail/wikimetrics/2014-August/000148.html
I created the Tool Labs tools tools.wikimetrics-production tools.wikimetrics-staging tools.wikimetrics-development , granted access to Milimetric, Nuria, and myself to them, and used the corresponding labsdb connections on our instances +----------------------+------------------------------------+-------------------------------+-------------+ | Instance name | URL | Tool Labs tool | Labsdb user | +----------------------+------------------------------------+-------------------------------+-------------+ | wikimetrics1 | http://metrics.wmflabs.org | tools.wikimetrics-production | s52261 | | wikimetrics-staging1 | http://metrics-staging.wmflabs.org | tools.wikimetrics-staging | s52262 | | wikimetrics-dev1 | http://metrics-dev.wmflabs.org | tools.wikimetrics-development | s52263 | +----------------------+------------------------------------+-------------------------------+-------------+