Jcrespo has uploaded a new change for review.
https://gerrit.wikimedia.org/r/211669
Change subject: Set max_allowed_packet on m3 (phabricator) to 32M (current: 16M)
......................................................................
Set max_allowed_packet on m3 (phabricator) to 32M (current: 16M)
Phabricator now complains about a small max_allowed_packet.
It specifically says that it may create larger writes, so I am setting
preemptly the mysqldump scripts with the same size.
This change will not be applied automaticaly to mysqls, so it will have
to be dynamically applied to each m3 component, from slaves to master.
slave_max_allowed_packet is already to 1G, so no problem there.
Checking dumps and phabricator nodes to make sure they do not break.
Bug: T98339
Change-Id: I906a6c2aebef2a5b6719dd53890df18006723a3a
---
M templates/mariadb/dumps-misc.sh.erb
M templates/mariadb/phabricator.my.cnf.erb
2 files changed, 4 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/69/211669/1
diff --git a/templates/mariadb/dumps-misc.sh.erb
b/templates/mariadb/dumps-misc.sh.erb
index 6803654..f9b6c76 100644
--- a/templates/mariadb/dumps-misc.sh.erb
+++ b/templates/mariadb/dumps-misc.sh.erb
@@ -17,10 +17,11 @@
sql="select schema_name from information_schema.schemata where schema_name
regexp '^(phab|phlegal)'"
$dump -h m3-slave --ignore-table=phabricator_search.search_documentfield \
+ --max_allowed_packet=32M \
--databases $($my "$sql" | tr '\n' ' ') | \
pigz > /srv/backups/m3-phabricator-phlegal-$(date +%Y%m%d%H%M%S).sql.gz
sql="select schema_name from information_schema.schemata where schema_name
regexp '^(wik|flowdb)'"
$dump -h x1-slave --databases $($my "$sql" | tr '\n' ' ') | \
- pigz > /srv/backups/x1-$(date +%Y%m%d%H%M%S).sql.gz
\ No newline at end of file
+ pigz > /srv/backups/x1-$(date +%Y%m%d%H%M%S).sql.gz
diff --git a/templates/mariadb/phabricator.my.cnf.erb
b/templates/mariadb/phabricator.my.cnf.erb
index 311f4c7..5783e6b 100644
--- a/templates/mariadb/phabricator.my.cnf.erb
+++ b/templates/mariadb/phabricator.my.cnf.erb
@@ -25,7 +25,7 @@
max_connections = 500
extra_max_connections = 10
max_connect_errors = 1000000000
-max_allowed_packet = 16M
+max_allowed_packet = 32M
connect_timeout = 3
query_cache_size = 0
query_cache_type = 0
@@ -78,4 +78,4 @@
quick
max_allowed_packet = 16M
-#!includedir /etc/mysql/conf.d/
\ No newline at end of file
+#!includedir /etc/mysql/conf.d/
--
To view, visit https://gerrit.wikimedia.org/r/211669
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I906a6c2aebef2a5b6719dd53890df18006723a3a
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
