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. You can balance your load easily. Data is always instantly visible on all nodes after a transaction commits. Postgres-XC is wonderfully transparent, and application changes are not required for scaling out.

The most important thing to keep in mind...