MySQL replication status notification

Using the below simple bash script you can get an alert message from the replication server if replication is down or not working.

Setup this script in conrtab of Master server

Continue reading…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
 

How to Change the MySQL replication master host

Here.s a little post on how to change the master database host that the replication slave in a MySQL replication setup uses. This can happen if there is a change in network addresses or when you want to switch over to using different internal network. The main thing to keep in mind is that when […]
Continue reading…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
 

How to configure MySQL Failover using a bash script

The quick and easy solution for MySQL failover is Master Slave Replication.But in reality it needs some support for failover. Because if you are using Master Slave Replication for your application and suddenly the Master Node dies, then how your application will know about this? You have to change the database configuration file again to […]
Continue reading…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
 

Steps to configure MySQL Master Slave Replication

Setup Master Configuration File:- Step-1:- Opne my.cnf file

comment lines like below

Step-2:- We have to tell MySQL for which database it should write logs (these logs are used by the slave to see what has changed on the master) Add these lines to my.cnf

Step-3:- Then we have to restart the […]
Continue reading…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
 

How to configure MySQL 5.5 Server as Replication Slave:

I had some trouble configuring a MySQL 5.5 Server as Replication Slave. MySQL did not not start after I wrote master host details in my.cnf of slave node. Got following error.

Goggled and found that Replication Master data cannot be set in slave my.cnf for MySQL 5.5 Server, though the my.cnf sample files still […]
Continue reading…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS