W dniu 22.12.2021 o 21:01, Phil Stracchino pisze: > 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.) > > I had galera-claster with 3 nodes and haproxy
--
