[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: switchover s2 codfw master from db2017 to db2035

[Jcrespo (Code Review)]

Jcrespo has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/404268 )

Change subject: mariadb: switchover s2 codfw master from db2017 to db2035
......................................................................

mariadb: switchover s2 codfw master from db2017 to db2035

Bug: T176243
Change-Id: I2910c9ffadb4a2c3d48ed6a10f952201a3b3e568
---
M hieradata/hosts/db2017.yaml
M hieradata/hosts/db2035.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_codfw.yaml
4 files changed, 6 insertions(+), 7 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/68/404268/1

diff --git a/hieradata/hosts/db2017.yaml b/hieradata/hosts/db2017.yaml
index 9af454e..c9e2327 100644
--- a/hieradata/hosts/db2017.yaml
+++ b/hieradata/hosts/db2017.yaml
@@ -1,4 +1 @@
 mariadb::shard: 's2'
-mariadb::mysql_role: 'master'
-mariadb::binlog_format: 'STATEMENT'
-mariadb::socket: '/tmp/mysql.sock'
diff --git a/hieradata/hosts/db2035.yaml b/hieradata/hosts/db2035.yaml
index c9e2327..e97d921 100644
--- a/hieradata/hosts/db2035.yaml
+++ b/hieradata/hosts/db2035.yaml
@@ -1 +1,3 @@
 mariadb::shard: 's2'
+db::mysql_role: 'master'
+mariadb::binlog_format: 'STATEMENT'
diff --git a/manifests/site.pp b/manifests/site.pp
index cc900c4..967ed6a 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -314,11 +314,11 @@
 
 # s2 (large wikis) core production dbs on codfw
 # codfw master
-node 'db2017.codfw.wmnet' {
+node 'db2035.codfw.wmnet' {
     role(mariadb::core)
 }
 
-node /^db20(35|41|49|56|63|64)\.codfw\.wmnet/ {
+node /^db20(17|41|49|56|63|64)\.codfw\.wmnet/ {
     role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index 641d4ea..0bd0098 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -23,7 +23,7 @@
     shard: s2
     role: slave
   targets:
-  - db2035:9104
+  - db2017:9104
   - db2041:9104
   - db2049:9104
   - db2056:9104
@@ -35,7 +35,7 @@
     shard: s2
     role: master
   targets:
-  - db2017:9104
+  - db2035:9104
 
 - labels:
     shard: s3

-- 
To view, visit https://gerrit.wikimedia.org/r/404268
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2910c9ffadb4a2c3d48ed6a10f952201a3b3e568
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