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.
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.
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 -- 172-30-1-157
Create the PostgresXL user account and group:
sudo groupadd pgxl sudo useradd -g pgxl pgxl
Install RPMS on all four servers. Copy the following RPMS to the server and make sure you are in the same location...