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.
-Aaron
On Thu, Feb 5, 2015 at 5:42 AM, Sean Pringle springle@wikimedia.org wrote:
Who is still using s1-analytics-slave, and for what sorts of things?
The analytics-store is just an alias for dbstore1002, which is about to be duplicated as dbstore2002 in CODFW with all wikis and eventlogging.
We could potentially dub dbstore2002 as "analytics-slave" or similar, and reclaim the old s1-analytics-slave in EQIAD -- which is really db1047, out of warranty, and likely one of a batch of database nodes that will be decommissioned this year.
dbstore2002 has nearly 3x more memory than db1047, and twice as many cores, so you guys would be gaining from this transaction ;-)
Sean
DBA @ WMF
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics