On Fri, Feb 6, 2015 at 12:45 AM, Aaron Halfaker <ahalfaker@wikimedia.org> wrote:

I've been slow to move some datasets off of s1-analytics-slave because it remained available. If I were given ~ a week notice, it would be no problem to move all datasets and work to analytics-store.

Am I reading correctly that you are suggesting that we might have both dbstore1002 and dbstore2002 available? Now, as far as having two machine for querying, this would be valuable for spreading the load of regular jobs (e.g. dashboard scripts) from ad-hoc queries.

Correct, analytics would have access to both boxes, ideally with some logical production/ad-hoc traffic split.

Important to note that dbstore2002 would not replicate dbstore1002 staging or datasets databases, just the upstream wikis and eventlogging. If you want staging on both you'd have to maintain it twice.

Sean