public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Grimm <[email protected]>
To: [email protected]
Subject: Re: Can logical replication be a solution to my current MariaDB/Galera setup?
Date: Sun, 24 May 2026 16:01:17 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

[email protected] wrote:
> Am 22.05.26 um 15:18 schrieb Michael Grimm:

>> I have never run a postgres server before, but I do run a mariadb
>> galera cluster [1] for storing emails by an IMAP server [2].
>> Distribution and failover is dealt by haproxy [3].
> 
> For such a system I don't see the need for a multi-master setup (neither
> with Postgres nor with MariaDB).

What I didn't mention in my mail is: incoming mails at all three mail servers become stored into each user's mailbox  at the server they arrive (LMTP). In this scenario multi-master is handy.

But see below.

> For high availability you don't need multi-master. A standard
> streaming replication with a failover mechanism is completely enough
> in my opinion.

Thanks for this hint w.r.t. streaming replication.

I have made some research about this kind of cluster and come to the conclusion that streaming replication plus repmgr [1] will meet my expectations.

BUT: I will need to configure haproxy to route all IMAP and LMTP traffic to the "current" master, only. 

I am hoping that this can be achieved by a customised health check plus routing, but I have never done that before, though.

Thanks and regards,
Michael



[1] available in the FreeBSD ports collection

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Can logical replication be a solution to my current MariaDB/Galera setup?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox