Computing
Reference
Emoticons
Hardware
Internet Security
Protocols
DNS
MAIL
WWW
SQL
SNMP (manage)
RADIUS
AppleTalk
Specific
FreeBSD
MacOS
Legacy
PalmOS
BSDI
|
 |
MySQL Replication Manager
Author: Matt Simerson.
[ Install | FAQ | ChangeLog | Sample ]
[matt@cadillac] ~/html/computing/sql/mrm % ./mysql_replicate_manager.pl-1.4.3
**** **** MySQL Replication Manager 1.4.3 **** ****
by Matt Simerson
usage: ./mysql_replicate_manager.pl-1.4.3 [-u ] [-p ]
-a Archive the mysql databases
-b Back up the mysql databases [-d backupdir]
-c Copy archive from master to slaves
-h Halt MySQL master, sync up slaves, and shut down master
-i Informative display of replication status
-l show master Logs
-f Force purge master bin-logs (this can break your replication)
-p Purge master bin-logs (w/o breaking slaves)
-s Shutdown [master/slaves]
-x eXtract archive on slave(s)
Optional
-q Quiet (no debugging and status information)
-v Verbose
[matt@cadillac] ~/html/computing/sql/mrm % ./mysql_replicate_manager.pl-1.4.3 -i
**** **** MySQL Replication Manager 1.4.3 **** ****
by Matt Simerson
master_info->version: 3.23.55
master_info->status: cadillac-bin.001, 12509139
slave_info->version: 3.23.55
slave_info->status: cadillac-bin.001, 12509139, Yes, seattle.simerson.net
slave_info->version: 3.23.55
slave_info->status: cadillac-bin.001, 12509139, Yes, lab.simerson.net
All done.
|
