Playing with MYSQL replication
One of my colleagues left to vacation. Now I have to work with his stuff. I found one of the hardest task is replication of two MYSQL servers. They work both as master and as slave. So, everytime I have to check their statuses to know replication is alive or not. Unfortunatelly, I haven’t faced with MYSQL replication before. That’s why it was novelty for me :). I’ve discovered a very useful book – “High Performance MySQL” on O’Reilly site.
As you can know there is a sample chapter for every O’Reilly books. I was amazing! The sample chapter of “High Performance MySQL” was “Chapter 7: Replication”!!! That chapter helped me. I found there some useful receipts how to check a process of replication. You can use my simple Perl script which check status of master and slave and create a report. The script is based on receipt from “High Performance MySQL”.
check_repl_status.pl