Jcrespo has uploaded a new change for review.
https://gerrit.wikimedia.org/r/212302
Change subject: Moving pdns and designate databases from m1 to m5
......................................................................
Moving pdns and designate databases from m1 to m5
Bug: T92693
Change-Id: I45a2dbdc645acbb25b17691c3a561d679856223f
---
M manifests/role/designate.pp
M templates/mariadb/production-grants-m1.sql.erb
M templates/mariadb/production-grants-m5.sql.erb
3 files changed, 27 insertions(+), 26 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/02/212302/1
diff --git a/manifests/role/designate.pp b/manifests/role/designate.pp
index cd1307a..c92cb66 100644
--- a/manifests/role/designate.pp
+++ b/manifests/role/designate.pp
@@ -32,12 +32,12 @@
$keystoneconfig = $role::keystone::config::eqiad::keystoneconfig
$db_host = $::realm ? {
- 'production' => 'm1-master.eqiad.wmnet',
+ 'production' => 'm5-master.eqiad.wmnet',
'labs' => $::ipaddress_eth0,
}
$pdns_db_host = $::realm ? {
- 'production' => 'm1-master.eqiad.wmnet',
+ 'production' => 'm5-master.eqiad.wmnet',
'labs' => $::ipaddress_eth0,
}
diff --git a/templates/mariadb/production-grants-m1.sql.erb
b/templates/mariadb/production-grants-m1.sql.erb
index 675f447..376201d 100644
--- a/templates/mariadb/production-grants-m1.sql.erb
+++ b/templates/mariadb/production-grants-m1.sql.erb
@@ -56,27 +56,3 @@
GRANT ALL PRIVILEGES
ON `rt`.* TO 'rt'@'10.64.0.165';
-
--- pdns
-
-GRANT USAGE
- ON *.* TO 'pdns_admin'@'10.64.0.165'
- IDENTIFIED BY PASSWORD '*17CEDD01A991E1E7C9734790D2BE399610E76F7F';
-
-GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
TEMPORARY TABLES
- ON `pdns`.* TO 'pdns_admin'@'10.64.0.165';
-
-GRANT USAGE ON *.* TO 'pdns'@'10.64.0.165'
- IDENTIFIED BY PASSWORD '*D59E93D5BA8096F6A23E82C4F2B4AF7F6F33C1B6';
-
-GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES
- ON `pdns`.* TO 'pdns'@'10.64.0.165';
-
--- designate
-
-GRANT USAGE
- ON *.* TO 'designate'@'10.64.0.165'
- IDENTIFIED BY PASSWORD '*F5142C60E1E1FAB32340BAD5C6135DE63D4911B6';
-
-GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY
TABLES
- ON `designate`.* TO 'designate'@'10.64.0.165';
\ No newline at end of file
diff --git a/templates/mariadb/production-grants-m5.sql.erb
b/templates/mariadb/production-grants-m5.sql.erb
index e69de29..e70cf6c 100644
--- a/templates/mariadb/production-grants-m5.sql.erb
+++ b/templates/mariadb/production-grants-m5.sql.erb
@@ -0,0 +1,25 @@
+-- pdns
+
+GRANT USAGE
+ ON *.* TO 'pdns_admin'@'10.64.0.165'
+ IDENTIFIED BY PASSWORD '*17CEDD01A991E1E7C9734790D2BE399610E76F7F';
+
+GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
+TEMPORARY TABLES
+ ON `pdns`.* TO 'pdns_admin'@'10.64.0.165';
+
+GRANT USAGE ON *.* TO 'pdns'@'10.64.0.165'
+ IDENTIFIED BY PASSWORD '*D59E93D5BA8096F6A23E82C4F2B4AF7F6F33C1B6';
+
+GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES
+ ON `pdns`.* TO 'pdns'@'10.64.0.165';
+
+-- designate
+
+GRANT USAGE
+ ON *.* TO 'designate'@'10.64.0.165'
+ IDENTIFIED BY PASSWORD '*F5142C60E1E1FAB32340BAD5C6135DE63D4911B6';
+
+GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY
+TABLES
+ ON `designate`.* TO 'designate'@'10.64.0.165';
--
To view, visit https://gerrit.wikimedia.org/r/212302
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I45a2dbdc645acbb25b17691c3a561d679856223f
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
