replication

Tagged

A collection of 2 posts

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.

mysql

Shell Script to Check the Status of MySQL Replication

!/bin/bash emailAddress="emailtoNotify@domain.com [emailAddress=%22emailtoNotify@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 Broken on hostname" $emailAddress fi If