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 <[email protected]> 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
