Jcrespo has submitted this change and it was merged.
Change subject: Set db2018 binlog_format to MIXED; testing it as the reason for
lag
......................................................................
Set db2018 binlog_format to MIXED; testing it as the reason for lag
Potentialy the cause of lag on db2036, db2043, db2050 and db2057.
Change-Id: I2a50b546b40258720278221274c7b17a29c34a1c
---
M manifests/site.pp
1 file changed, 13 insertions(+), 1 deletion(-)
Approvals:
Jcrespo: Looks good to me, approved
jenkins-bot: Verified
diff --git a/manifests/site.pp b/manifests/site.pp
index 5911d34..a54f6e0 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -560,7 +560,19 @@
include base::firewall
}
-node /^db20(18|36|43|50|57)\.codfw\.wmnet/ {
+# potentially causing replication lag
+# specially due to new s3 servers
+node 'db2018.codfw.wmnet' {
+ class { 'role::mariadb::core':
+ shard => 's3',
+ p_s => 'on',
+ binlog_format => 'MIXED',
+ ssl => 'puppet-cert',
+ }
+ include base::firewall
+}
+
+node /^db20(36|43|50|57)\.codfw\.wmnet/ {
class { 'role::mariadb::core':
shard => 's3',
p_s => 'on',
--
To view, visit https://gerrit.wikimedia.org/r/283939
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I2a50b546b40258720278221274c7b17a29c34a1c
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
