On Fri, Feb 6, 2015 at 12:45 AM, Aaron Halfaker <ahalfaker(a)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