multiple / backup sql servers for sql server access

[Sami Ketola]

> On 30. Aug 2022, at 5.13, Jack Snodgrass <jack at mylinuxguy.net> wrote:
> 
> 
> 
> I am using this file: 
> 
> dovecot-sql.conf.ext
> 
> and in there  I have a 
> 
> connect = "host=<dbserver> dbname=<dbname> user=<dbuser> password=<dbpass>"
> 
> 
> 
> My <dbserver> was down and I lost mail access for a few days before I realized that there was an issue.  How can I specify a backup server so that if my primary sql server goes down, a backup sql server will be queried?

Use haproxy.

Sami


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://dovecot.org/pipermail/dovecot/attachments/20220830/40cbaea7/attachment.htm>