left header graphic The Network People
Solutions for Hosting Providers
right header graphic

mrm-faq home : internet : sql : mrm : mrm-sample www

MySQL Replication Manager

Author: Matt Simerson.

[matt@cadillac] ~ % mysql_replicate_manager

**** **** MySQL Replication Manager 1.6.0 **** ****
by Matt Simerson

usage: /usr/local/sbin/mysql_replicate_manager [-u <root>] [-p <pass>]

-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] ~ % mysql_replicate_manager -i

**** **** MySQL Replication Manager 1.6.0 **** ****
by Matt Simerson

master_info->version: 4.0.14
master_info->status: cadillac-bin.004, 6972318
data dir: /var/db/mysql/
conf dir: /var/db/mysql

slave_info->version: 4.0.14
slave_info->status: cadillac-bin.004, 6972318, seattle-relay-bin.001, seattle.simerson.net

slave_info->version: 4.0.14
slave_info->status: cadillac-bin.004, 6972318, lab-relay-bin.001, lab.simerson.net

All done.

 


Last modified on 5/13/05.