Jozsef Kadlecsik via Postfix-users:
> Hi Wietse,
>
> On Wed, 19 Nov 2025, Wietse Venema via Postfix-users wrote:
>
> > This may look unexpected, but have you considered configuring the same
> > server twice in the misql_table configuration file?
> >
> >> From the manpage:
> >
> > MYSQL PARAMETERS
> > hosts The hosts that Postfix will try to connect to and query
> > from.
> > ...
> > NOTE: if the hosts setting specifies only one server, this client
> > assumes that the target is a load balancer and will reconnect im-
> > mediately after a single failure. With Postfix versions 3.9 and
> > earlier, specify the same server twice.
>
> Debian with Postfix 3.7.11 :-), so the manpage does not contain the note.
>
> It is a nice idea indeed! Thank you!
It is worth trying, because the old mysql client will try "every
configured host" and then fail queries for 60 seconds.
When the mysql_table "hosts" parameter specifies one server, Postfix
3.10 and later will pretend that it specifies the same server twice.
With Postfix 3.9 and earlier, you will have to do duplicate the
server in the config file.
Without this workaround, load balancers actually make Postfix less reliable.
Wietse
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
