Alexandros Kosiaris has uploaded a new change for review.
https://gerrit.wikimedia.org/r/249096
Change subject: maps: Tune replication parameters
......................................................................
maps: Tune replication parameters
There has been an instance of a query breaking postgres replication.
This is covered in T116553. Using the numbers from that and
extrapolating to using around 30GB for WAL segments for slaves to use we
set checkpoint_segments and wal_keep_segments to 768. This should cover
us even in the case were really problematic queries are being run on the
cluster at the cost of keeping around extra WAL files. We do follow a
similar approach in MySQL keeping around a lot of extra WAL files.
This adds the extra benefit of allowing even quite out of date slaves to
catch up to the master after a period of extended downtime. That being
said, this should not be considered a silver bullet
Bug: T116553
Change-Id: Ic13cd1366662fdc17c49abadf61ffaa72c119fdf
---
M hieradata/role/common/maps/master.yaml
1 file changed, 2 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/96/249096/1
diff --git a/hieradata/role/common/maps/master.yaml
b/hieradata/role/common/maps/master.yaml
index 0f045aa..4fdf68f 100644
--- a/hieradata/role/common/maps/master.yaml
+++ b/hieradata/role/common/maps/master.yaml
@@ -1,6 +1,8 @@
postgresql::master::pgversion: 9.4
postgresql::master::datadir: /srv/postgresql/9.4/main
postgresql::master::includes: tuning.conf
+postgresql::master::checkpoint_segments: 768
+postgresql::master::wal_keep_segments: 768
debdeploy::grains:
debdeploy-maps-master:
value: standard
--
To view, visit https://gerrit.wikimedia.org/r/249096
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic13cd1366662fdc17c49abadf61ffaa72c119fdf
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Alexandros Kosiaris <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
