On 8/21/18 4:17 PM, deoren wrote: > Hi all, > > We've been using Postfix for years with good results, but in recent > years have moved to a load-balanced HAProxy front-end with multiple > backend relay nodes. I've consulted various sources during that time to > perform the initial setup and light tuning since then. > > The health checks are run often and simulate a full email delivery > session in an attempt to exercise the full configuration (including > alias resolution and other related db queries). > > This setup works pretty well, but occasionally there is enough of a > delay between one of the steps in the simulated delivery that the health > check fails and the node is marked as down. > > When this occurs I have been unable to determine exactly why the issue > occurs. I've adjusted various timeout and timing settings within HAProxy > and Postfix, so I assume that our mostly stock MariaDB 10.0.x > installation is likely to blame. > > Do you have any recommendations for guides that cover tuning Postfix and > MySQL? I'd like to start there and work through the steps before turning > back to the configuration as a whole. > > Another option I'm considering is replicating the database contents > (where applicable) in MySQL to local SQLite databases that are synced to > the relay nodes, cutting MySQL/MariaDB out of the picture entirely. > > Our client node count is currently less than 100.
I wouldn't use SQLite. There is no such thing to my knowledge as a tuning guide for MySQL specifically to work with Postfix. The same general MySQL tuning practices apply to tuning for any load scenario. You said "mostly stock" MariaDB - have you done any database tuning *at all*? (And for that matter, what are you running it on? Red Hat, for example, has historically shipped default MySQL/MariaDB configuration files that are at best worthless even when they're not actively harmful.) -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958
