Hello, 

I am setting dbstore1002 on read-only now, to start the migration.

Thanks

Manuel.

On Tue, Feb 12, 2019 at 10:11 AM Luca Toscano <ltoscano@wikimedia.org> wrote:

Hi everybody,

as described in here (https://phabricator.wikimedia.org/T215589#4946535) I am proposing a maintenance window to allow the Data Persistence and Analytics teams to move the staging database from dbstore1002 to dbstore1005 (its new home) on Monday 18th during the EU morning. This will mean that the staging database on dbstore1002 will become read-only (permanently), but an up to date copy with read/write capabilities will be present on dbstore1005.

Some notes:

- dbstore1002 will not be shutdown/decommissioned yet, you'll be able to query tables as you are used to.

- as described in https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas several DNS CNAME/SRV records have been created to ease the use of the new systems, please check them out :)

Let me know if this is feasible or if you need more time for a specific use case (let's coordinate in the task).

Thanks!

Luca (on behalf of the Analytics team)