In this recipe, we are going to set up a replication using Slony, which is a widely used replication engine. It replicates a desired set of table data from one database to another. This replication approach is based on a few event triggers that will be created on the source set of tables, which will log the DML and DDL statements into Slony catalog tables. By using Slony, we can also set up the cascading replication among multiple nodes.
The steps followed in this recipe are carried out on a CentOS version 6 machine.
We first need to install Slony.
The following are the steps needed to install Slony: