Change Details

During the June 2021 DC switchover, tr.wikivoyage.org was briefly unavailable because in codfw the sectionsByLoad entry was typoed: https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/702136/ Given that wikis are expected to be in the same section in both datacenters (please correct if wrong #dba), the two lists should never fall out of sync. Possible ways to resolve this bug (non-exhaustive): * Implement a test to verify the two lists are the same * Move the lists to a db-common.php file that is used by both DCs * Automate generation of the lists from the dblists. Marking as high priority because this caused a small outage. >>! Original task description by @Urbanecm > It is necessary for all wikis to be in the dblist for the shard they live at, as well as the shard being defined by db-*.php files. Otherwise, various parts of the configuration might be confused.

During the June 2021 DC switchover, tr.wikivoyage.org was briefly unavailable because in codfw the sectionsByLoad entry was typoed: https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/702136/ Given that wikis are expected to be in the same section in both datacenters (please correct if wrong #dba), the two lists should never fall out of sync. Possible ways to resolve this bug (non-exhaustive): * Implement a test to verify the two lists are the same * Move the lists to a db-common.php file that is used by both DCs * Automate generation of the lists from the dblists. Marking as high priority because this caused a small outage. <https://wikitech.wikimedia.org/wiki/Incident_documentation/2021-06-29_trwikivoyage_primary_db> ------- >>! Original task description by @Urbanecm > It is necessary for all wikis to be in the dblist for the shard they live at, as well as the shard being defined by db-*.php files. Otherwise, various parts of the configuration might be confused.

During the June 2021 DC switchover, tr.wikivoyage.org was briefly unavailable because in codfw the sectionsByLoad entry was typoed: https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/702136/ Given that wikis are expected to be in the same section in both datacenters (please correct if wrong #dba), the two lists should never fall out of sync. Possible ways to resolve this bug (non-exhaustive): * Implement a test to verify the two lists are the same * Move the lists to a db-common.php file that is used by both DCs * Automate generation of the lists from the dblists. Marking as high priority because this caused a small outage. <https://wikitech.wikimedia.org/wiki/Incident_documentation/2021-06-29_trwikivoyage_primary_db> ------- >>! Original task description by @Urbanecm > It is necessary for all wikis to be in the dblist for the shard they live at, as well as the shard being defined by db-*.php files. Otherwise, various parts of the configuration might be confused.