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

Change subject: mariadb: Add gtid_domain_id to s4
......................................................................

mariadb: Add gtid_domain_id to s4

Enable gtid_domain_id on s4 shard (commons).
It has been running for for weeks on the misc shards so it is time to
slowly deploy it on production shards.

Bug: T149418
Change-Id: Ica9ed7a8d1f68e385539587c245f7567b65ba25f
---
M templates/mariadb/default.my.cnf.erb
1 file changed, 9 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/16/335816/1

diff --git a/templates/mariadb/default.my.cnf.erb 
b/templates/mariadb/default.my.cnf.erb
index 612ffb0..e804315 100644
--- a/templates/mariadb/default.my.cnf.erb
+++ b/templates/mariadb/default.my.cnf.erb
@@ -22,6 +22,15 @@
 server_id = <%= @server_id %>
 read_only = 0
 
+<% if @shard == 's4' -%>
+# gtid_domain_id flag is needed for multisource replication and GTID.
+# Strictly it is only needed on masters or servers that can potentially be
+# masters but for consistency it should be set in all of them.
+# https://mariadb.com/kb/en/mariadb/gtid/
+
+gtid_domain_id  = <%= @gtid_domain_id %>
+<% end -%>
+
 secure_file_priv   = /dev/null
 max_allowed_packet = 16M
 sync_binlog        = 1

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ica9ed7a8d1f68e385539587c245f7567b65ba25f
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui <maroste...@wikimedia.org>

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to