[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-04-04T07:36:03Z] Synchronized wmf-config/db-codfw.php: Depool db2083 - T188279 (duration: 01m 17s)TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

Marostegui added a comment. So I have created the following user: test_user that has all privileges from terbium. I have already left the password on @Ladsgroup's home in terbium and he's tested that he can connect finely. Lastly, this host is downtimed, so if replication breaks due to the tests,

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

jcrespo added a comment. We can either change the password, or the user, or both. +1TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: jcrespoCc: Stashbot, gerritbot, jcrespo, Marostegui, Nikerabbit,

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

Marostegui added a comment. db2083 is now depooled and with alert notifications disabled. Assuming @Ladsgroup will use the wikiadmin user to perform all the needed ALTERs, I would like to change its password to use a temporary and a different one from production, so he needs to specifically use a

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

Stashbot added a comment. Mentioned in SAL (#wikimedia-operations) [2018-04-04T05:59:54Z] Synchronized wmf-config/db-eqiad.php: Depool db2083 - T188279 (duration: 01m 17s)TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

gerritbot added a comment. Change 423835 merged by jenkins-bot: [operations/mediawiki-config@master] db-codfw.php: Depool db2083 https://gerrit.wikimedia.org/r/423835TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

gerritbot added a comment. Change 423836 merged by Marostegui: [operations/puppet@production] db2083.yaml: Disable notifications https://gerrit.wikimedia.org/r/423836TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

gerritbot added a comment. Change 423836 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/puppet@production] db2083.yaml: Disable notifications https://gerrit.wikimedia.org/r/423836TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

gerritbot added a comment. Change 423835 had a related patch set uploaded (by Marostegui; owner: Marostegui): [operations/mediawiki-config@master] db-codfw.php: Depool db2083 https://gerrit.wikimedia.org/r/423835TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

Marostegui added a comment. I suggest db2083 - 512GB + SSDs which is pretty much the same we have in eqiad (all the hosts but the master in eqiad have those HW specs)TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL

[Wikidata-bugs] [Maniphest] [Commented On] T188279: Investigate optimzing wb_terms

Ladsgroup added a comment. This the document I put up is https://docs.google.com/document/d/1Op3GHFS0wOXYATA8EC92WquQVNAJR1jH-a0a4KaB-B8 Feel free to comment there.TASK DETAILhttps://phabricator.wikimedia.org/T188279EMAIL