Setting up a Postgres-XL cluster
Here in this recipe, we are going to set up a Postgres XL cluster, which is a scalable PostgreSQL cluster, to solve the big data processing challenges.
Getting ready
Postgres-XL is a horizontally scalable open source cluster, which has a set of individual dedicated components to scale PostgreSQL to multiple nodes. Postgre-XL (extensible lattice) gives us more convenience in distributing the data across the nodes or replicating the data across the nodes.
How to do it...
Note that:
node1 -- ec2-54-164-174-117.compute-1.amazonaws.com -- 172-30-1-154 node2 -- ec2-54-152-235-194.compute-1.amazonaws.com -- 172-30-1-155 node3 -- ec2-54-165-7-151.compute-1.amazonaws.com -- 172-30-1-156 node4 -- ec2-54-152-210-130.compute-1.amazonaws.com ...
Get PostgreSQL High Performance Cookbook now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.