Change Details

This is a tracking task to list and manage all the users of dbstore1002 and coordinate the migration to the new dbstore100[3-5] setup. https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas describes how the new set up looks like, for any question please follow up with the Analytics team :) List of users and status of the migration: [ ] Research team [ ] Scoring team [ ] Analytics Report Updater [ ] Analytics montly Sqoop scripts [ ] WMDE scripts [ ] Product Analytics team **DEPRECATION WARNING: dbstore1002 is going to be decommissioned on March 4th** The Analytics team has been working with the SRE Data Persistence team during the last months to replace dbstore1002 with three brand new nodes, dbstore100[3-5]. We are moving from a single mysql instance (multi-source) to a multi-instance environment. For more info please check: * T210478 and related subtasks. * https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas We are planning to decommission the dbstore1002 host (namely stopping mysql and shutting down the server) on Monday March 4th (EU morning). We have recently been following up with a lot of users to help them migrate to the new environment, so we are reasonably sure that this move should not heavily impact anybody, but if we have left some use case aside please let us know in https://phabricator.wikimedia.org/T215589. If we don't hear anything before the March 4th deadline we'll proceed with the host decommission maintenance.

This is a tracking task to list and manage all the users of dbstore1002 and coordinate the migration to the new dbstore100[3-5] setup. https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas describes how the new set up looks like, for any question please follow up with the Analytics team :) List of users and status of the migration: [x] Research team [x] Scoring team [ ] Analytics Report Updater [x] Analytics montly Sqoop scripts [x] WMDE scripts [x] Product Analytics team **DEPRECATION WARNING: dbstore1002 is going to be decommissioned on March 4th** The Analytics team has been working with the SRE Data Persistence team during the last months to replace dbstore1002 with three brand new nodes, dbstore100[3-5]. We are moving from a single mysql instance (multi-source) to a multi-instance environment. For more info please check: * T210478 and related subtasks. * https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas We are planning to decommission the dbstore1002 host (namely stopping mysql and shutting down the server) on Monday March 4th (EU morning). We have recently been following up with a lot of users to help them migrate to the new environment, so we are reasonably sure that this move should not heavily impact anybody, but if we have left some use case aside please let us know in https://phabricator.wikimedia.org/T215589. If we don't hear anything before the March 4th deadline we'll proceed with the host decommission maintenance.

This is a tracking task to list and manage all the users of dbstore1002 and coordinate the migration to the new dbstore100[3-5] setup. https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas describes how the new set up looks like, for any question please follow up with the Analytics team :) List of users and status of the migration: [ x] Research team [ x] Scoring team [ ] Analytics Report Updater [ x] Analytics montly Sqoop scripts [ x] WMDE scripts [ x] Product Analytics team **DEPRECATION WARNING: dbstore1002 is going to be decommissioned on March 4th** The Analytics team has been working with the SRE Data Persistence team during the last months to replace dbstore1002 with three brand new nodes, dbstore100[3-5]. We are moving from a single mysql instance (multi-source) to a multi-instance environment. For more info please check: * T210478 and related subtasks. * https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas We are planning to decommission the dbstore1002 host (namely stopping mysql and shutting down the server) on Monday March 4th (EU morning). We have recently been following up with a lot of users to help them migrate to the new environment, so we are reasonably sure that this move should not heavily impact anybody, but if we have left some use case aside please let us know in https://phabricator.wikimedia.org/T215589. If we don't hear anything before the March 4th deadline we'll proceed with the host decommission maintenance.