Wiki Replica c1.labsdb and c3.labsdb to be shutdown 2017-12-13 - Cloud-announce

19 Oct 2017

The labsdb1001.eqiad.wmnet (aka c1.labsdb) and labsdb1003.eqiad.wmnet
(aka c3.labsdb) servers are being shutdown and permanently removed
from service on Wednesday 2017-12-13.

TL;DR

* Change your tools and scripts to use:
  - "*.web.db.svc.eqiad.wmflabs" (real-time response needed)
  - "*.analytics.db.svc.eqiad.wmflabs" (batch jobs; long queries)
* Replace "*" with either a shard name (e.g. s1) or a wikidb name
  (e.g. enwiki).
* The new servers do not support user created databases/tables because
  replication can't be guaranteed. See T156869 and below for more
  information.
* Migrate your user created tables to tools.db.svc.eqiad.wmflabs
  (also known as tools.labsdb) and JOIN via application space logic
  rather than in-process in the database.

What is changing?

* Week of 2017-10-30 to 2017-11-03 (exact date to be determined)
** Reboot labsdb1001.eqiad.wmnet (aka c1.labsdb) for kernel updates
** There is a possibility of catastrophic hardware failure in this
reboot. There will be no way to recover the server or the data it
currently hosts if that happens.

* Week of 2017-11-06 to 2017-11-10 (exact date to be determined)
** Reboot labsdb1003.eqiad.wmnet (aka c3.labsdb) for kernel updates
** There is a possibility of catastrophic hardware failure in this
reboot. There will be no way to recover the server or the data it
currently hosts if that happens.

* Wednesday 2017-12-13
* "*.labsdb" service names switched to point at
"*.web.db.svc.eqiad.wmflabs" equivalents.
* User created tables will not be allowed on the new servers
"c1.labsdb" and "c3.labsdb" point to.
* labsdb1001.eqiad.wmnet removed from service.
* labsdb1003.eqiad.wmnet removed from service.

Why are we doing this?

See <https://wikitech.wikimedia.org/wiki/Wiki_Replica_c1_and_c3_shutdown>
and <https://phabricator.wikimedia.org/T142807> for a more complete
description of the reasons for these changes.

Bryan (on behalf of the Wikimedia Cloud Services and DBA teams)
-- 
Bryan Davis              Wikimedia Foundation    &lt;bd808(a)wikimedia.org&gt;
[[m:User:BDavis_(WMF)]] Manager, Cloud Services          Boise, ID USA
irc: bd808                                        v:415.839.6885 x6855