Jcrespo has uploaded a new change for review.
https://gerrit.wikimedia.org/r/259523
Change subject: Reconfigure mysql at db1041 and all s7 codfw slaves
......................................................................
Reconfigure mysql at db1041 and all s7 codfw slaves
Change-Id: I904f9ee810225ad437b55799554fefc1e61c0e67
References: T120122
---
M manifests/site.pp
1 file changed, 13 insertions(+), 10 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/23/259523/1
diff --git a/manifests/site.pp b/manifests/site.pp
index 38f486c..4683169 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -648,7 +648,7 @@
}
# s6 core production slave dbs on codfw
-node /^db20(28|39|46|53|60)\.codfw\.wmnet/ {
+node /^db20(28|39|46|53|60|67)\.codfw\.wmnet/ {
$cluster = 'mysql'
class { 'role::mariadb::core':
@@ -659,27 +659,30 @@
include base::firewall
}
-node /^db2067\.codfw\.wmnet/ {
+# s7 (centralauth, meta et al.) core production slave dbs on eqiad
+node /^db10(28|34|39|62)\.eqiad\.wmnet/ {
+ class { 'role::mariadb::core':
+ shard => 's7',
+ }
+}
+node /^db10(41)\.eqiad\.wmnet/ {
$cluster = 'mysql'
class { 'role::mariadb::core':
- shard => 's6',
+ shard => 's7',
p_s => 'on',
}
include base::firewall
}
-node /^db10(28|34|39|41|62)\.eqiad\.wmnet/ {
- class { 'role::mariadb::core':
- shard => 's7',
- }
-}
-
+# s7 (centralauth, meta et al.) core production slave dbs on codfw
node /^db20(29|40|47|54|61|68)\.codfw\.wmnet/ {
$cluster = 'mysql'
class { 'role::mariadb::core':
- shard => 's7',
+ shard => 's7',
+ p_s => 'on',
+ binlog_format => 'ROW',
}
include base::firewall
}
--
To view, visit https://gerrit.wikimedia.org/r/259523
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I904f9ee810225ad437b55799554fefc1e61c0e67
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
