redsnapper76
Contributor
Contributor

vCloud Director 9.5 with PostGress

Hello

We are designing a migration from SQL cluster to a PostgreSQL.

Currently we have set-up a SQL HA cluster where we have automatic fail-over of the DB Servers.

We want to have this also in our PostgreSQL setup.

Does anyone have experience with one of these products or is there a reference architecture for this?

ClusterControl | Open Source Database Management System

https://www.citusdata.com/product

Thank you in advance

0 Kudos
3 Replies
SebastianGrugel
Hot Shot
Hot Shot

I dont have experience with this but i heard that VMware in future would like publish in some next version some separate appliance for PostgreSQL i think in this place willbe some HA functionality.

Maybe somebody from VMware can confirm this Smiley Happy

Im migrated from MSSQL to PostgreSQL a few weeks ago and looks like this process is clear.

Sebastian

vExpert VSAN/NSX/CLOUD | VCAP5-DCA | VCP6-DCV/CMA/NV ==> akademiadatacenter.pl
0 Kudos
sk84
Expert
Expert

Unfortunately I do not know these two products. We have enough Linux know-how in-house to build Postgres clusters ourselves. With the help of the standard solutions that Postgres already has.

There is a chapter about HA, Load Balancing and Replication in the official Postgres documentation. Maybe this will help you:

https://www.postgresql.org/docs/current/high-availability.html

There is also a page that lists the common solutions for Postgres Clustering because the cluster support and cluster administration is not really in the scope of the main postgres project. Citus Data is also listed there, so it's an official supported third party solution for postgres HA. If you don't have the know how or want to build it up, I would therefore take a closer look at Citus Data and test it.

https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

--- Regards, Sebastian VCP6.5-DCV // VCP7-CMA // vSAN 2017 Specialist Please mark this answer as 'helpful' or 'correct' if you think your question has been answered correctly.
0 Kudos
pceglowski
Contributor
Contributor

Hi,

We are currently using Patroni, etcd and haproxy/keepalived, which works very well for us. Pretty straight forward to set up and gives you the necessary 9's in the production environment.

Just follow their documentation provided with Patroni making sure that you have at least two postgres and haproxy nodes, and three etcd nodes. The minimum set up providing you with N+1 would be three VMs: VM1 (running postgres/etcd/haproxy/keepalived), VM2 (running postgres/etcd/haproxy/keepalived) and VM3 (running etcd), however I would strongly suggest splitting the load-balancing (haproxy/keepalived) from the postgresql/etcd lot, which means you will end up with 5 VMs.

Cheers,

Prem

0 Kudos