public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Grimm <[email protected]>
To: [email protected]
Subject: Can logical replication be a solution to my current MariaDB/Galera setup?
Date: Fri, 22 May 2026 15:18:35 +0200
Message-ID: <[email protected]> (raw)

Hi,

this is my first post to this mailing list, and I hope that I chose the correct mailing list.

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]. This mail server setup has to deal with less than 250 mails a day, a database size of under 6 GB, and a handful of users. You see, that this system is bored to death ;-)  

I have read a lot about replication in order to find something comparable to a galera cluster with its multi master capabilities. Now, I have learned that multi master can only be achieved by using third party plugins. Not all of those are available for my FreeBSD systems, though.

As a newbie I do currently tend to use logical replication with mutual publish and subscribe instead, either by pglogical2 or "self-made". I am in the -probably naive- impression that this could work. As before, failover will be handled by haproxy by simply directing read/write access to another postgres node available. When a failed node will become online again, logical replication should enable this node to recover, right?

Here are my questions:

#) Is this feasible or nonsense?
#) What would an alternatives for FreeBSD be (pgpool-II, repmgr, …)?

Any input is highly appreciated.

Thanks in advance and regards,
Michael


[1] 3 nodes, primary-primary replication.
[2] https://dbmail.org/en/
[3] All incoming MUA requests are directed to a single node in order to prevent split brain situations

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