Cisco Cisco Prime Network Registrar 8.1 Troubleshooting Guide
Replication Setup
• 5
2 Setup
2.1 Replication Setup
You set up MySQL replication on the Production and Backup Executives as follows.
1.
Configure the Production Executive to begin logging any changes that are made to the
database. This step is handled by the following script:
INCHOME/etc/support/prepmaster.sh
For further information on executing this script, refer to “Configure Production
Executive as Active Master,” on page 7.
2.
Configure the Backup Executive to detect changes on the Production Executive and
to become a read-only server. This step is handled by the following script:
$INCHOME/etc/support/prepslave.sh
For further information on executing this script, refer to “Configure Backup
Executive as Passive Master,” on page 8.
3.
Complete the loop by setting up the Production Executive to listen for changes on the
Backup Executive and begin monitoring the replication state. This step is handled by
the following script:
$INCHOME/etc/support/connect_to_passive.sh
For further information on executing this script, refer to “Connect Active Master to
Passive Master,” on page 11.
2.2 Replication Software Prerequisites
Before you begin setting up MySQL replication, ensure you have completed the following
prerequisites:
• The Cisco Prime Network Registrar IPAM Executive 8.1.2 or higher
is installed on
both the Production and Backup servers.
• MySQL 5.5 is installed on both the Production and Backup servers.
• A new license key has been obtained from Cisco Prime Network Registrar IPAM TAC
• A new license key has been obtained from Cisco Prime Network Registrar IPAM TAC
to support both the Production and Backup Executives.