Cisco Cisco Prime Network Registrar 8.1 故障排查指南

Cisco Prime Network Registrar IPAM 8.1.1 Disaster Recovery Guide - Using MySQL Replication

4.2.3.3 Reload the Dump File and Set Coordinates

On the Passive Master we need to load the database dump

file from the previous step and set the log file

coordinates. To accomplish this run the

resync_slave.sh script using the coordinates provided

by the resync_master.sh script on the Production

Executive.

>./resync_slave.sh -l mysql-bin.000001 -s 14158333 -h 192.168.196.45 -d
dbforrepl.sql

Stopping replication slave process with: STOP SLAVE

Disconnecting from old master with: CHANGE MASTER TO MASTER_HOST=''

Resetting slave with: RESET SLAVE

Loading dumpfile: dbforrepl.sql ...

Connecting to master with: CHANGE MASTER TO
MASTER_HOST='192.168.196.45',MASTER_USER='repl',MASTER_PASSWORD='replpass1',
MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=14158333

Starting replication slave process with: START SLAVE

Resynchronization Step 2 of 2 complete!