Page MenuHomePhabricator
Create Task
Maniphest T330619

Enable DB replication codfw -> eqiad before the switchover
Closed, ResolvedPublic
Actions

Description

We need to enable replication from codfw masters to eqiad masters

  • Disable GTID on codfw first and then enable replication on s1
  • Disable GTID on codfw first and then enable replication on s2
  • Disable GTID on codfw first and then enable replication on s3
  • Disable GTID on codfw first and then enable replication on s4
  • Disable GTID on codfw first and then enable replication on s5
  • Disable GTID on codfw first and then enable replication on s6
  • Disable GTID on codfw first and then enable replication on s7
  • Disable GTID on codfw first and then enable replication on s8
  • Disable GTID on codfw first and then enable replication on x1
  • Disable GTID on codfw first and then enable replication on es4
  • Disable GTID on codfw first and then enable replication on es5
  • pc1
  • pc2
  • pc3

Related Objects
Search...

Event Timeline

• Marostegui created this task.Feb 27 2023, 7:30 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 27 2023, 7:30 AM
• Marostegui triaged this task as High priority.Feb 27 2023, 7:31 AM
• Marostegui moved this task from Triage to In progress on the DBA board.
Stashbot added a comment.Feb 27 2023, 7:42 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T07:42:25Z] <marostegui> Enable replication codfw -> eqiad on pcX T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 7:44 AM
Stashbot added a comment.Feb 27 2023, 7:57 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T07:57:17Z] <marostegui> Enable replication codfw -> eqiad on x1 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 8:01 AM

I had the usual issue with heartbeat on x1 eqiad - but it is now fixed.

Stashbot added a comment.Feb 27 2023, 8:32 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T08:32:25Z] <marostegui> Enable replication codfw -> eqiad on es4 and es5 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 8:34 AM
Stashbot added a comment.Feb 27 2023, 8:51 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T08:51:36Z] <marostegui> Enable replication codfw -> eqiad on s2 T330619

Stashbot added a comment.Feb 27 2023, 8:51 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T08:51:52Z] <marostegui> Disable GTID on es% x1 and s% on codfw masters T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 8:51 AM
Stashbot added a comment.Feb 27 2023, 9:12 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T09:12:45Z] <marostegui> Enable replication codfw -> eqiad on s3 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 9:13 AM
Stashbot added a comment.Feb 27 2023, 9:26 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T09:26:30Z] <marostegui> Enable replication codfw -> eqiad on s8 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 9:26 AM
Stashbot added a comment.Feb 27 2023, 9:27 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T09:27:52Z] <marostegui> Enable replication codfw -> eqiad on s7 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 9:28 AM
Stashbot added a comment.Feb 27 2023, 9:34 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T09:34:27Z] <marostegui> Enable replication codfw -> eqiad on s6 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 9:34 AM
Stashbot added a comment.Feb 27 2023, 9:39 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T09:39:29Z] <marostegui> Enable replication codfw -> eqiad on s5 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 9:39 AM
Stashbot added a comment.Feb 27 2023, 9:44 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T09:44:54Z] <marostegui> Enable replication codfw -> eqiad on s1 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 9:45 AM
Stashbot added a comment.Feb 27 2023, 10:08 AM

Mentioned in SAL (#wikimedia-operations) [2023-02-27T10:08:32Z] <marostegui> Enable replication codfw -> eqiad on s4 T330619

• Marostegui updated the task description. (Show Details)Feb 27 2023, 10:09 AM
• Marostegui closed this task as Resolved.Feb 27 2023, 10:49 AM

This is done

• Marostegui mentioned this in T330302: sre.switchdc.mediawiki.03-set-db-readonly fails in live-test mode.Feb 27 2023, 11:04 AM
• Marostegui added a parent task: T330302: sre.switchdc.mediawiki.03-set-db-readonly fails in live-test mode.
Maintenance_bot moved this task from In progress to Done on the DBA board.Feb 27 2023, 11:15 AM
• Marostegui renamed this task from Enable DB replication eqiad -> codfw before the switchover to Enable DB replication codfw -> eqiad before the switchover.Apr 24 2023, 8:03 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL