Page MenuHomePhabricator
Create Task
Maniphest T163413

Pool new server db2071
Closed, ResolvedPublic
Actions

Description

Hello,

Via SAL I saw that @Papaul already installed the OS on db2071. I decided to finish the installation by signing the puppet cert, running puppet, salt and all that. I thought if we have it ready we might be able to pool it in on s1 and help the current api servers as it is a powerful server with SSDs
The server looks ready now after the reboot.

@Papaul is there anything pending on db2071 from your side or do you see any issues if we start getting the data from another s1 slave and put it in production when ready?
//cc @jcrespo

Details

SubjectRepoBranchLines +/-
db-codfw.php: Increase API weight db2071operations/mediawiki-configmaster+2 -2
db-codfw.php: Increase weight db2071operations/mediawiki-configmaster+2 -2
db-codfw.php: Pool db2071 with small weightoperations/mediawiki-configmaster+2 -1
s1.hosts: Add db2071operations/softwaremaster+1 -0
prometheus-mysqld-exporter: Add new node db2071operations/puppetproduction+1 -0
Depool db1080 for cloning and pre-setup new server db2071operations/mediawiki-configmaster+4 -1
Setup db2071 as new s1 slaveoperations/puppetproduction+1 -1
Customize query in gerrit

Related Objects
Search...

Event Timeline

• Marostegui created this task.Apr 20 2017, 6:18 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 20 2017, 6:18 AM
• Marostegui renamed this task from Pool db2071? to Pool new server db2071?.Apr 20 2017, 6:18 AM
jcrespo renamed this task from Pool new server db2071? to Pool new server db2071.Apr 20 2017, 7:03 AM
jcrespo added a parent task: T162159: codfw rack/setup 22 DB servers.
gerritbot added a comment.Apr 20 2017, 7:04 AM

Change 349158 had a related patch set uploaded (by Jcrespo):
[operations/puppet@production] Setup db2071 as new s1 slave

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

gerritbot added a project: Patch-For-Review.Apr 20 2017, 7:04 AM
gerritbot added a comment.Apr 20 2017, 7:07 AM

Change 349158 merged by Jcrespo:
[operations/puppet@production] Setup db2071 as new s1 slave

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

gerritbot added a comment.Apr 20 2017, 7:36 AM

Change 349162 had a related patch set uploaded (by Jcrespo):
[operations/mediawiki-config@master] Depool db1083 for cloning and pre-setup new server db2071

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

gerritbot added a comment.Apr 20 2017, 7:46 AM

Change 349162 merged by jenkins-bot:
[operations/mediawiki-config@master] Depool db1080 for cloning and pre-setup new server db2071

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

Stashbot subscribed.Apr 20 2017, 7:59 AM

Mentioned in SAL (#wikimedia-operations) [2017-04-20T07:59:12Z] <jynus> shutting down db1080 for cloning and upgrade T163413

• Marostegui added a comment.Apr 20 2017, 8:20 AM

db2072 is also now ready to be used if needed. All went fine after rebooting it.

gerritbot added a comment.Apr 20 2017, 8:30 AM

Change 349173 had a related patch set uploaded (by Jcrespo):
[operations/puppet@production] prometheus-mysqld-exporter: Add new node db2071

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

gerritbot added a comment.Apr 20 2017, 8:51 AM

Change 349175 had a related patch set uploaded (by Marostegui):
[operations/software@master] s1.hosts: Add db2071

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

• Marostegui added a comment.Apr 20 2017, 9:09 AM

More servers are now online and ready to be used if needed, I will post it on the original tracking task (T162159) so I don't hijack this one.

• Marostegui mentioned this in T162159: codfw rack/setup 22 DB servers.Apr 20 2017, 9:13 AM
gerritbot added a comment.Apr 20 2017, 9:53 AM

Change 349173 merged by Jcrespo:
[operations/puppet@production] prometheus-mysqld-exporter: Add new node db2071

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

• Marostegui moved this task from Triage to In progress on the DBA board.Apr 20 2017, 10:15 AM
gerritbot added a comment.Apr 20 2017, 11:25 AM

Change 349175 merged by jenkins-bot:
[operations/software@master] s1.hosts: Add db2071

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

gerritbot added a comment.Apr 20 2017, 11:28 AM

Change 349202 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Pool db2071 with small weight

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

gerritbot added a comment.Apr 20 2017, 11:32 AM

Change 349202 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Pool db2071 with small weight

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

gerritbot added a comment.Apr 20 2017, 12:35 PM

Change 349207 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Increase weight db2071

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

gerritbot added a comment.Apr 20 2017, 12:40 PM

Change 349207 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Increase weight db2071

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

• Marostegui added a comment.Apr 20 2017, 12:47 PM

I have pooled db2071 with the same main traffic as the other api servers (50) but with weight 2 in API, instead of 1 as the other servers.
We'll see how it goes.

gerritbot added a comment.Apr 20 2017, 1:07 PM

Change 349211 had a related patch set uploaded (by Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Increase API weight db2071

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

gerritbot added a comment.Apr 20 2017, 1:10 PM

Change 349211 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Increase API weight db2071

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

• Marostegui closed this task as Resolved.Apr 21 2017, 11:59 AM

This is now done, the server has been there for a day.

Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:42 PM
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