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



 

For installations which use the MySQL database provided with IPAM, 
replication is accomplished using a custom script that dumps the IPAM 
database from the Production Executive and copies the exported data to the 

DR Executive.  This data is then loaded into the separate instance of 
MySQL running on the DR Executive. 

This file contains the default options for the DBMover script, including 
the IP address of the Production Executive, login credentials, and the 

name of the MySQL database to be copied. 
Note that the MySQL user defined in this file must have sufficient privileges to  
remotely access the Production IPAM database.  This can be accomplished via the 
following commands on the Production IPAM Executive: 



 

> $INCHOME/mysql/bin/mysql –uroot –pincr00t 



 

mysql> GRANT SELECT on incontrol.* to 

‘incadmin’; 
Where the name preceding the  at (@) symbol is the mysql 
user configured in the default.dbmover file, 
‘backupexec.company.com’ is the fully-qualified hostname or 
IP address of the DR Executive, and ‘incadmin’ is the 
password corresponding to the mysql user configured in the 
default.dbmover file. 

This script remotely retrieves a database from a primary system and 
loads it into a local database.  Either this  script or the dbmover-
wrapper.sh script should be configured to run periodically on the DR 
Executive using the ‘cron’ utility available on supported platforms.  The 

frequency in which the script should be run is dependent upon the 
frequency in which the Production Executive’s IPAM database is 

changed.  It is recommended that the DBMover script is run at least 
once daily.  
Note the dbmover-wrapper.sh script must be updated w/ valid email addresses for 
the ‘to’ and ‘from’ sections  and a smtp domain name.