Amit's Blog
  • Home
  • Videos
  • All Posts
  • Tags
  • About Me
Subscribe
Tagged

replication

A collection of 2 posts

replication

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.

  • amit
amit Jan 4, 2018 • 6 min read
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

  • amit
amit Jun 30, 2012 • 1 min read
Amit's Blog © 2025
Powered by Ghost