search

vitabaks / postgresql_cluster

PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.
https://postgresql-cluster.org
MIT License
1.69k stars 411 forks source link

Multi master setup #505

Closed kumarashish071092 closed 8 months ago

kumarashish071092 commented 11 months ago

Hi Vitaly ,

Can you please help me in setting up multi master Postgres node using patroni , ha and connection pooling?

I am looking to transfer more than 100tbs of data and need to do horizontal scaling and multi master setup.

vitabaks commented 11 months ago

Hi @kumarashish071092

Patroni does not provide the ability to configure the multimaster clusters. Perhaps you may be interested in schemes using sharding based on the Citus extension, but this scheme is still only in TODO - https://github.com/vitabaks/postgresql_cluster/issues/258

Currently, you can deploy a scheme with read load scaling - the Type A scheme. But there is no scheme with scaling of the writing load yet.