Page MenuHomePhabricator
Create Task
Maniphest T156006

Move db1052 to row B3
Closed, ResolvedPublic
Actions

Description

Hi

Once T156004 is completed we need to move db1052 to B3 if possible.
I will update this ticket once it can be done

Details

SubjectRepoBranchLines +/-
site.pp: Enable RBR on db1072operations/puppetproduction+9 -1
db-eqiad.php: Depool db1072operations/mediawiki-configmaster+4 -4
site.pp: Disable RBR on db1052 enable it on db1073operations/puppetproduction+11 -2
db-codfw,db-eqiad.php: Change db1052 IPsoperations/mediawiki-configmaster+2 -2
Customize query in gerrit

Related Objects
Search...

Event Timeline

Marostegui created this task.Jan 23 2017, 3:21 PM
Marostegui mentioned this in T156008: Switchover s1 master db1057 -> db1052.Jan 23 2017, 3:24 PM
Marostegui mentioned this in T155999: DBA plan to mitigate asw-c2-eqiad reboots.
Marostegui changed the task status from Stalled to Open.Jan 23 2017, 3:44 PM
jcrespo added a comment.Jan 23 2017, 3:51 PM
<cmjohnson1> marostegui and jynus plan for 1400UTC
Marostegui added a comment.Jan 23 2017, 4:08 PM

Reminder:

  • we need to silence labsdb1009, 1010 and 1011 as they replicate from it.
  • we need to stop replication on them
  • once it is back, we need to repoint them to the new IP
jcrespo added a comment.Jan 23 2017, 4:13 PM

we need to silence labsdb1009, 1010 and 1011 as they replicate from it.

But they replicate from db1094 :-/

Marostegui added a comment.Jan 23 2017, 4:14 PM
In T156006#2961719, @jcrespo wrote:

we need to silence labsdb1009, 1010 and 1011 as they replicate from it.

But they replicate from db1094 :-/

Gah, sorry! Yes, I meant db1095 - good catch!

gerritbot subscribed.Jan 24 2017, 7:11 AM

Change 333850 had a related patch set uploaded (by Marostegui):
site.pp: Disable RBR on db1052

https://gerrit.wikimedia.org/r/333850

gerritbot added a project: Patch-For-Review.Jan 24 2017, 7:11 AM
Marostegui added a comment.Jan 24 2017, 9:26 AM

Alerts silenced for 24 hours - I will re-enable them once the move is done.

Stashbot subscribed.Jan 24 2017, 1:37 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T13:37:36Z] <marostegui> Shutdown mysql on db1052 for maintenance - T156006

Stashbot added a comment.Jan 24 2017, 1:41 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T13:41:04Z] <marostegui> Shutdown db1052 for maintenance - T156006

gerritbot added a comment.Jan 24 2017, 1:43 PM

Change 333908 had a related patch set uploaded (by Marostegui):
db-codfw,db-eqiad.php: Change db1052 IPs

https://gerrit.wikimedia.org/r/333908

gerritbot added a comment.Jan 24 2017, 1:47 PM

Change 333908 merged by jenkins-bot:
db-codfw,db-eqiad.php: Change db1052 IPs

https://gerrit.wikimedia.org/r/333908

Stashbot added a comment.Jan 24 2017, 1:48 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T13:48:23Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Change db1052 IP - T156006 (duration: 00m 39s)

Stashbot added a comment.Jan 24 2017, 1:49 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T13:49:17Z] <marostegui@tin> Synchronized wmf-config/db-codfw.php: Change db1052 IP - T156006 (duration: 00m 39s)

Marostegui closed this task as Resolved.Jan 24 2017, 2:10 PM
Marostegui assigned this task to • Cmjohnson.

db1051 has been moved.
DNS updated
db-eqiad,codfw files updated
mysql and replication started finely.
tendril updated

thanks @Cmjohnson

Stashbot added a comment.Jan 24 2017, 2:55 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T14:55:38Z] <marostegui> Stop replication on db1052 and db1073 for maintenance - T156006

gerritbot added a comment.Jan 24 2017, 3:17 PM

Change 333850 abandoned by Marostegui:
site.pp: Disable RBR on db1052 enable it on db1073

Reason:
let's split into two commits better

https://gerrit.wikimedia.org/r/333850

gerritbot added a comment.Jan 24 2017, 4:06 PM

Change 333926 had a related patch set uploaded (by Marostegui):
site.pp: Enable RBR on db1072

https://gerrit.wikimedia.org/r/333926

gerritbot added a comment.Jan 24 2017, 4:09 PM

Change 333927 had a related patch set uploaded (by Marostegui):
db-eqiad.php: Depool db1072

https://gerrit.wikimedia.org/r/333927

gerritbot added a comment.Jan 24 2017, 4:14 PM

Change 333927 merged by jenkins-bot:
db-eqiad.php: Depool db1072

https://gerrit.wikimedia.org/r/333927

Stashbot added a comment.Jan 24 2017, 4:15 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T16:15:32Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Depool db1072 - T156006 (duration: 00m 47s)

gerritbot added a comment.Jan 24 2017, 4:20 PM

Change 333926 merged by Marostegui:
site.pp: Enable RBR on db1072

https://gerrit.wikimedia.org/r/333926

Stashbot added a comment.Jan 24 2017, 4:22 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T16:22:03Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Depool db1072 - T156006 (duration: 00m 41s)

Stashbot added a comment.Jan 24 2017, 6:02 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-24T18:02:21Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Depool db1065 - T156006 (duration: 00m 49s)

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 · Credits