Chapter 12. Working with Postgres-XC

In this chapter, we have to focus our attention on a write-scalable, multimaster, synchronous, symmetric, and transparent replication solution for PostgreSQL, called PostgreSQL eXtensible Cluster (Postgres-XC). The goal of this project is to provide the end user with a transparent replication solution, which allows higher levels of loads by horizontally scaling to multiple servers.

In an array of servers running Postgres-XC, you can connect to any node inside the cluster. The system will make sure that you get exactly the same view of the data on every node. This is really important, as it solves a handful of problems on the client side. There is no need to add logic to applications that write to just one node. ...

Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.