Page MenuHomePhabricator

Switchover s8 primary database master db1109 -> db1104 - Date TBD
Open, MediumPublic

Description

At some point we'd need to failover db1109 (row D) to db1104 (row B).
There are some reason to do so:

  • PDUs on row D will eventually need to be replaced like it happened with row A and B (T226778)
  • We currently have many masters on row D, being db1109 one of them.
wikidatawiki

Date: To be defined

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 26 2019, 2:18 PM
Marostegui triaged this task as Medium priority.Nov 26 2019, 2:18 PM
Marostegui moved this task from Triage to Backlog on the DBA board.
Marostegui updated the task description. (Show Details)

It would be great if the job of rebuildTermItems in mwmaint1002 gets disabled (for example killed) right before the failover. I'm worried the script skip lots of items because of the failover.

It would be great if the job of rebuildTermItems in mwmaint1002 gets disabled (for example killed) right before the failover. I'm worried the script skip lots of items because of the failover.

This one?

# Puppet Name: wikidata-rebuildItemTerms
30 * * * * /usr/bin/timeout 3500s /usr/local/bin/mwscript extensions/Wikibase/repo/maintenance/rebuildItemTerms.php --wiki wikidatawiki --batch-size 150 --sleep 2 --from-id $(/bin/sed -n '/Rebuilding Q[[:digit:]]\+ till Q\([[:digit:]]\+\)/ { s//\1/; p; }' /var/log/wikidata/wikidata-rebuildItemTerms.log* | /usr/bin/sort -rn | /usr/bin/head -1) >> /var/log/wikidata/wikidata-rebuildItemTerms.log 2>&1
Marostegui updated the task description. (Show Details)Nov 27 2019, 2:10 PM

You may want to complete T232446: Compress new Wikibase tables on new master before failover.

Absolutely! Thanks

Ladsgroup updated the task description. (Show Details)Mon, Jan 13, 11:17 AM
Marostegui updated the task description. (Show Details)Mon, Jan 13, 11:19 AM