[Labs-l] Many DB connections - ideas?

[Jeremy Baron]

On Oct 20, 2014 11:40 AM, "Magnus Manske" <magnusmanske at googlemail.com>
wrote:
> So, in essence , it goes through a list of languages, often >100. It
opens a DB connection on Labs to the respective Wikipedia, does some query,
and closes again.

cache a connection per cluster (s1, s2, etc) and then reuse when you need
that cluster again. obviously that's most important for s3. (more DBs than
any other)

there's a DB with a table that maps all DBs to clusters. or use the dblists
in the operations/mediawiki-config gerrit repo.

-Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20141020/9d9d6d6f/attachment.html>