On 12/22/21 12:55, Wietse Venema wrote:
In this case Postfix is (also) overloading the MySQL server.
- Get a more powerful system (or VM) for the MySQL server.
- Reduce the workload per MySQL server (spread the load across
multiple servers).
Perhaps first of all, make sure that mysqld is properly tuned. 90% of
small MySQL/MariaDB deployment performance problems can be resolved
simply by properly tuning it for the available resources.
But if you're overloading a single MySQL instance, consider using a
Galera cluster (either MySQL or MariaDB) behind ProxySQL or HAproxy.
Read performance on a Galera cluster scales approximately linearly with
the number of nodes, and nodes can be more-or-less transparently added
and dropped on demand.
(Also, this gives you transparent DB redundancy in the case that a node
crashes or needs to be taken offline for maintenance.)
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
