Jcrespo has uploaded a new change for review.
https://gerrit.wikimedia.org/r/249372
Change subject: Enabling performance schema experimentally on db1022
......................................................................
Enabling performance schema experimentally on db1022
db1022 is currently depooled. Solify its configuration to
enable performance_schema running on it.
If the test works successfuly, we will enable performance_schema
by default on all hosts, but we need to measure (performance)
regressions first.
Bug: T99485
Change-Id: I068dd8181f991dd5cb90a232f46595645fe086d9
---
M manifests/role/mariadb.pp
M manifests/site.pp
2 files changed, 11 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/72/249372/1
diff --git a/manifests/role/mariadb.pp b/manifests/role/mariadb.pp
index e1b86ec..3371b6c 100644
--- a/manifests/role/mariadb.pp
+++ b/manifests/role/mariadb.pp
@@ -417,7 +417,8 @@
}
class role::mariadb::core(
- $shard
+ $shard,
+ $p_s = 'off',
) {
system::role { "role::mariadb::core":
@@ -441,6 +442,7 @@
password => $passwords::misc::scripts::mysql_root_pass,
datadir => '/srv/sqldata',
tmpdir => '/srv/tmp',
+ p_s => $p_s,
}
mariadb::monitor_replication { [ $shard ]:
diff --git a/manifests/site.pp b/manifests/site.pp
index 5dba5ec..6c5ed0c 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -620,12 +620,19 @@
include base::firewall
}
-node /^db10(22|30|37|50|61)\.eqiad\.wmnet/ {
+node /^db10(30|37|50|61)\.eqiad\.wmnet/ {
class { 'role::mariadb::core':
shard => 's6',
}
}
+node /^db1022\.eqiad\.wmnet/ {
+ class { 'role::mariadb::core':
+ shard => 's2',
+ p_s => 'on',
+ }
+}
+
node /^db20(28|39|46|53)\.codfw\.wmnet/ {
$cluster = 'mysql'
--
To view, visit https://gerrit.wikimedia.org/r/249372
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I068dd8181f991dd5cb90a232f46595645fe086d9
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
