Jcrespo has submitted this change and it was merged. Change subject: Allow heartbeat table to replicate to dbstore* hosts ......................................................................
Allow heartbeat table to replicate to dbstore* hosts This enables heartbeat replica monitoring on dbstorehosts. It may have a tax in performance we may not be able to pay. Requires validation, reversion on lag issues. bug: T114752 Change-Id: I9a5f6cb21473d2c754d1398f703e5448b29ecd8e --- M templates/mariadb/dbstore.my.cnf.erb 1 file changed, 10 insertions(+), 0 deletions(-) Approvals: Jcrespo: Looks good to me, approved Volans: Looks good to me, but someone else must approve jenkins-bot: Verified diff --git a/templates/mariadb/dbstore.my.cnf.erb b/templates/mariadb/dbstore.my.cnf.erb index 066c36d..400b9f3 100644 --- a/templates/mariadb/dbstore.my.cnf.erb +++ b/templates/mariadb/dbstore.my.cnf.erb @@ -74,18 +74,28 @@ slave_transaction_retries = 4294967295 s1.replicate-wild-do-table = %wik%.% +s1.replicate-wild-do-table = heartbeat.% s2.replicate-wild-do-table = %wik%.% +s2.replicate-wild-do-table = heartbeat.% s3.replicate-wild-do-table = %wik%.% +s3.replicate-wild-do-table = heartbeat.% s4.replicate-wild-do-table = %wik%.% +s4.replicate-wild-do-table = heartbeat.% s5.replicate-wild-do-table = %wik%.% +s5.replicate-wild-do-table = heartbeat.% s6.replicate-wild-do-table = %wik%.% +s6.replicate-wild-do-table = heartbeat.% s7.replicate-wild-do-table = %wik%.% s7.replicate-wild-do-table = centralauth.% +s7.replicate-wild-do-table = heartbeat.% m3.replicate-wild-do-table = phab%.% m3.replicate-wild-do-table = phlegal%.% +m3.replicate-wild-do-table = heartbeat.% m4.replicate-wild-do-table = log.% +m4.replicate-wild-do-table = heartbeat.% x1.replicate-wild-do-table = flowdb.% x1.replicate-wild-do-table = wikishared.% +x1.replicate-wild-do-table = heartbeat.% <% if @kernelversion < "3.19" %> # Until kernel 3.16 http://www.spinics.net/lists/stable/msg61873.html -- To view, visit https://gerrit.wikimedia.org/r/271495 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I9a5f6cb21473d2c754d1398f703e5448b29ecd8e Gerrit-PatchSet: 2 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <[email protected]> Gerrit-Reviewer: Jcrespo <[email protected]> Gerrit-Reviewer: Volans <[email protected]> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
