MySQL Replication Manager

It is Friday 26 April 2024 - 01:22:27.
Your IP address is 18.191.147.190

news personal professional computing outdoors reference travel humor

Computing

Reference

Emoticons Hardware Internet Security

Protocols

DNS MAIL WWW SQL SNMP (manage) RADIUS AppleTalk

Specific

FreeBSD MacOS

Legacy

PalmOS BSDI

MySQL Replication Management Utility
Author: Matt Simerson.
Mirrors available: Michigan :: Seattle ::

[ Install | FAQ | ChangeLog | Sample ]

What is mysql_repicate_manager.pl?

This script is a handy tool to help manage replicated MySQL servers. When a new slave needs to be configured, this script will ease the pain. When a slave desyncs (happens for a variety of reasons) this tool helps you get it back into sync with a minimum of pain and suffering.

Currently tested and working on: FreeBSD, Mac OS X, Linux, Solaris

Free support is NOT provided by the author. Expect to pay for requests.

Contributions: Purchase items from my wish list or make a PayPal contribution.

Installation

fetch http://matt.simerson.net/computing/sql/mrm/mysql_replicate_manager.pl
chmod 755 mysql_replicate_manager.pl
sudo mv mysql_replicate_manager.pl /usr/local/sbin/mysql_replicate_manager

Configure .my.cnf (see FAQ), enjoy!

Features:

  -a  Archive the mysql databases
  -b  Back up the mysql databases [-d backupdir]
  -c  Copy archive from master to slaves
  -i  Informative display of replication status
  -l  show master Logs
  -f  Force purge master bin-logs (can break replication)
  -p  Purge master bin-logs (w/o breaking slaves)
  -s  Shutdown [master/slaves]
  -x  eXtract archive on slave(s)