Jcrespo has submitted this change and it was merged.

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(-)

Approvals:
  Jcrespo: Looks good to me, approved
  jenkins-bot: Verified



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: merged
Gerrit-Change-Id: I904f9ee810225ad437b55799554fefc1e61c0e67
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <[email protected]>
Gerrit-Reviewer: Jcrespo <[email protected]>
Gerrit-Reviewer: jenkins-bot <>

_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to