Page MenuHomePhabricator

Please move db1110 and change its ip
Closed, ResolvedPublic

Description

As db1110 still has dns/ip/arp problems, and that means s5 (wikidatawiki and dewiki) is in a degraded state with lower resources, please move physically the db1110 server and assign it a new ip.

Not being able to pool db1110 is a pain for the database infrastructure.

Event Timeline

jcrespo created this task.Nov 29 2017, 11:11 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 29 2017, 11:11 AM
jcrespo updated the task description. (Show Details)Nov 29 2017, 11:14 AM
Marostegui added a comment.EditedNov 29 2017, 11:37 AM

If I can suggest, I would suggest any other rack within the C row if possible, to maintain a decent row distribution across s5 hosts

Change 394075 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/mediawiki-config@master] mariadb: Update db1110 ip

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

Spoke with Jaime and since it was preferable for the server to stay in row C it was decided to give the host a new IP in the same vlan instead of moving the server to a new row. Steps I took

Verified viable IP within the asw-c-private1 vlan
Change the IP in db1110 /etc/network/interfaces to 10.64.32.73
Powered off the server
Made the changes to the 10.in file and wmnet file
merged the changed and pushed via radon
Powered on the server

Change 394075 merged by jenkins-bot:
[operations/mediawiki-config@master] mariadb: Update db1110 ip

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

Change 394086 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/mediawiki-config@master] mariadb: Pool db1110 with low load after ip change and reboot

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

Change 394086 merged by jenkins-bot:
[operations/mediawiki-config@master] mariadb: Pool db1110 with low load after ip change and reboot

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

Change 394097 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/mediawiki-config@master] mariadb: Increase db1110 load

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

Change 394097 merged by jenkins-bot:
[operations/mediawiki-config@master] mariadb: Increase db1110 load

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

Change 394313 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/mediawiki-config@master] mariadb: Increase db1110 load to normal

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

Change 394313 merged by jenkins-bot:
[operations/mediawiki-config@master] mariadb: Increase db1110 load to normal

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

jcrespo closed this task as Resolved.Nov 30 2017, 3:39 PM
jcrespo assigned this task to Cmjohnson.