From: | Jason Grammenos <jason(dot)grammenos(at)agilitypr(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Postgresql HA cluster |
Date: | 2023-10-11 18:01:59 |
Message-ID: | YQXPR01MB62865246E684BD30645B68B3E4CCA@YQXPR01MB6286.CANPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am new to PostgreSQL and having to migrate a Cassandra cluster to PostgreSQL.
Have a reasonable amount of experience with MySQL and use Master -> Master MySQL replication quite successfully.
I am trying to understand what configuration/option to pick for PostgreSQL that will provide the same or similar level of operational easy as the Cassandra cluster. What I mean by that is : Backups, Patching (rebooting nodes to patch)
With Cassandra any single node can be patched and rebooting without incurring downtime. This is also true with MySQL master->master replication, which we have fronted by a HAproxy reverse proxy (we can fail over between the two MySQL node, draining the connections as we do so and then patching and reboot).
I have found the following documentation:
https://www.postgresql.org/docs/current/different-replication-solutions.html
and have heard of "Traktor", "pgEdge" and some other third-party tools.
My difficulty is that with very little knowledge of PostgreSQL I am having a hard time sorting through the various options and determining which are potential candidates for the kind of setup I am looking for (something approximating MySQL master->master replication).
Any advice or resources would be much appreciated.
Regards
Jason Grammenos
[cid:image001(dot)png(at)01D9FB7D(dot)85F88200]
Jason Grammenos | Operations & Infrastructure Analyst
Pronouns: he/him
P: 613.232.7797 x1131
Toll-free: 866.545.3745 x1131
jason(dot)grammenos(at)agilitypr(dot)com<mailto:jason(dot)grammenos(at)agilitypr(dot)com>
agilitypr.com<https://agilitypr.com/>
Learn new PR tips from our free resources<https://www.agilitypr.com/resources/>.
From | Date | Subject | |
---|---|---|---|
Next Message | Sasmit Utkarsh | 2023-10-11 19:15:50 | Assitance needed for the resolution of memory leak |
Previous Message | Ron | 2023-10-11 17:59:52 | Re: log wal file transfer in error logs |