Change Details

We'll need to perform a full dump and load of the wikilabels database from one (hardware) host to a virtual host. We'll need two databases: * u_wikilabels * u_wikilabels_test # Steps Once the database is primed (accounts and databases are prepared), we'll need to load our data in, run some tests, and then lock wikilabels in maintenance mode for a switchover. ## Staging test Copy the old u_wikilabels_test to the new u_wikilabels_test. Update the configuration to point to clouddb1002.clouddb-services.eqiad.wmflabs rather than "wikilabels-database". Check to see if everything works as intended. ## Put Wikilabels into maintenance mode Announce downtime for Wikilabels. 30 minutes should be sufficient. Create a deployment config change that adds a notice. See https://github.com/wikimedia/wikilabels-wmflabs-deploy/commit/6930d095413b3dc0e05eece9d9925b6557bd01de#diff-77ae19360cfaa1aaaea7086fab249bf4 for an example commit that adds a maintenance notice. When the time comes, stop the service and confirm that a browser returns the right http code. Dump the `u_wikilabels` database and load it on the new host. Deploy the config change pointing toward clouddb1002.clouddb-services.eqiad.wmflabs and restart the service. Confirm that everything works and declare victory.

We'll need to perform a full dump and load of the wikilabels database from one (hardware) host to a virtual host. We'll need two databases: * u_wikilabels * u_wikilabels_test # Steps Once the database is primed (accounts and databases are prepared), we'll need to load our data in, run some tests, and then lock wikilabels in maintenance mode for a switchover. ## 1. Staging test Copy the old u_wikilabels_test to the new u_wikilabels_test. Update the configuration to point to clouddb1002.clouddb-services.eqiad.wmflabs rather than "wikilabels-database". Check to see if everything works as intended. If everything worked as intended, we're ready to set a maintenance window. ## 2. Put Wikilabels into maintenance mode Announce downtime for Wikilabels. 30 minutes should be sufficient. Create a deployment config change that adds a notice. See https://github.com/wikimedia/wikilabels-wmflabs-deploy/commit/6930d095413b3dc0e05eece9d9925b6557bd01de#diff-77ae19360cfaa1aaaea7086fab249bf4 for an example commit that adds a maintenance notice. When the time comes, stop the service and confirm that a browser returns the right http code. Dump the `u_wikilabels` database and load it on the new host. Deploy the config change pointing toward clouddb1002.clouddb-services.eqiad.wmflabs and restart the service. Confirm that everything works and declare victory.

We'll need to perform a full dump and load of the wikilabels database from one (hardware) host to a virtual host. We'll need two databases: * u_wikilabels * u_wikilabels_test # Steps Once the database is primed (accounts and databases are prepared), we'll need to load our data in, run some tests, and then lock wikilabels in maintenance mode for a switchover. ## 1. Staging test Copy the old u_wikilabels_test to the new u_wikilabels_test. Update the configuration to point to clouddb1002.clouddb-services.eqiad.wmflabs rather than "wikilabels-database". Check to see if everything works as intended. If everything worked as intended, we're ready to set a maintenance window. ## 2. Put Wikilabels into maintenance mode Announce downtime for Wikilabels. 30 minutes should be sufficient. Create a deployment config change that adds a notice. See https://github.com/wikimedia/wikilabels-wmflabs-deploy/commit/6930d095413b3dc0e05eece9d9925b6557bd01de#diff-77ae19360cfaa1aaaea7086fab249bf4 for an example commit that adds a maintenance notice. When the time comes, stop the service and confirm that a browser returns the right http code. Dump the `u_wikilabels` database and load it on the new host. Deploy the config change pointing toward clouddb1002.clouddb-services.eqiad.wmflabs and restart the service. Confirm that everything works and declare victory.