Tagged: replication

Setting up PostGresql Replication with Loadbalancing  with PGPOOL II

Setting up PostGresql Replication with Loadbalancing with PGPOOL II

Installation (on both Master and Slave Nodes): yum install https://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-3.noarch.rpm yum install postgresql95 postgresql95-server postgresql-libs postgresql95-contrib rsync   Initialize the database and configure postgresql /usr/pgsql-9.5/bin/postgresql95-setup initdb cd /var/lib/pgsql/9.5/data cp postgresql.conf postgresql.conf.orig chown postgres postgresql.conf.orig...

Shell Script to Check the Status of MySQL Replication

Shell Script to Check the Status of MySQL Replication

#!/bin/bash emailAddress="emailtoNotify@domain.com" cmd=`mysql -e ‘show slave status\G’ | grep Slave_SQL_Running | awk ‘{print $2}’` if [ "$cmd" == "No" ];then         MSG="Mysql Replication Broken on `hostname`, please check asap"         echo $MSG | mail -s "Replication...