The migration finished. These are the times in UTC from 18th Feb 2019:

- Read only on dbstore1002: 05:53

- mysqldump start: 05:54:44

- mysqldump finished: 15:18:15

- data import in dbstore1005 start: 15:18:15

- data import dbstore1005 finished: 21:43:54

- read only OFF on dbstore1005:  21:43:54

Remember that dbstore1002 remain read-only.

Thanks

Manuel.

On Mon, Feb 18, 2019 at 6:58 AM Manuel Arostegui <marostegui@wikimedia.org> wrote:

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)