Starting PostgreSQL 16, you can practically set up a PostgreSQL cluster with active-active configuration - popularly known as multimaster replication. This was traditionally one of the biggest stumbling blocks for enterprises looking to migrate from Oracle to PostgreSQL. Being trained to use Oracle RAC and GoldenGate, the popular narrative was that an equivalent does not exist in PostgreSQL. I want to bust that myth. Each time a customer asks me about multimaster replication in PostgreSQL, I try to understand the objective they are trying to achieve and then propose an architecture accordingly. You want multimaster for: - High availability - Global distribution - Load balancing - Horizontal scaling - Disaster recovery Yes, each one of these objectives is achievable with PostgreSQL! I would love to hear about your challenges related to Oracle to PostgreSQL migration. Please share in the comments section.
Chukwuemeka O.
3mo
Does postgresql multimaster offer the luxury of shared storage as we have in Oracle RAC and the likes? Does postgresql multimaster have cluster layer or application calls one node at a time? From the configuration diagram,is synchronous node to node replication possible to some nodes across all active member nodes?
What's the conflict resolution strategy?
Muhammad Zain
3mo
Insightful! Any production story related to this? Does this feature be able to compete galera.
Affan Muhammad
3mo
This is an amazing development and will make Postgres even more direct competitor to leading RDBMS in many use cases.
Munir Ahmed
3mo
Superb, it's getting better with every successive version release
Ahmad Iftekhar
3mo
Glad to hear Active-Active setup
Osman Hashmi
3mo
Very informative, strategical move
Ameen Abbas
3mo
Interesting!
Great to hear that such cool features are now available to the masses. I wonder if it's worth doing a side by side comparison with technologies like CockroachDB and TiDB that do some magic behind the scenes. Especially the former because it speaks the Posture SQL protocol?