MySQL MHA - Installation

I'm going to start my blog, mainly about OSS. The reason is that I was inspired by an article on Yoshinori Matsumoto's blog. The title of the article is Announcing MySQL-MHA: "MySQL Master High Availability manager and tools"
I'm thinking that the first article of mine should be MySQL MHA, as I was just looking for something nice of how to automate mysql master failover.

A primary objective of MHA is automating master failover and slave promotion within short (usually 10-30 seconds) downtime, without suffering from replication consistency problems, without spending money for lots of new servers, without performance penalty, without complexity (easy-to-install), and without changing existing deployments.

The official project is here, MySQL MHA.

Before installing MySQL MHA, you need to install mysql server and enable replication between master and slave database server.

• MHA Nodes & Manager

DB(Master) + MHA Manager	192.168.100.200(ha-mgr01)
DB(Slave) + MHA Node	192.168.100.197(ha-db01)
DB(Slave) + MHA Node	192.168.100.198(ha-db02)

*Make sure that you need to setup public key authentication to login as root user between those hosts without passphrase.

• Installing MHA Node 

$ wget http://mysql-master-ha.googlecode.com/files/MySQL-MasterHA-Node-0.50.tar.gz
$ tar zxf MySQL-MasterHA-Node-0.50.tar.gz
$ cd MySQL-MasterHA-Node-0.50
$ perl Makefile.PL
$ make
$ sudo make install 

• Installing MHA Manager

$ for modules in ¥ DBD::mysql ¥ Config::Tiny ¥
Log::Dispatch ¥
Parallel::ForkManager ¥
Time::HiRes ; do 
sudo cpan install $modules
done
$ wget http://mysql-master-ha.googlecode.com/files/MySQL-MasterHA-Manager-0.50.tar.gz
$ tar zxf MySQL-MasterHA-Manager-0.50.tar.gz
$ cd MySQL-MasterHA-Manager-0.50
$ perl Makefile.PL
$ make
$ sudo make install
$ sudo cp -p samples/scripts/* /usr/local/bin/

Next will be about automating fail-over