Cisco Cisco Prime Network Registrar 8.1 Guide De Dépannage
![Cisco](https://files.manualsbrain.com/attachments/7380d0050044647c30f5c24bbbf5d0c0b6d9bb84/common/fit/150/50/faa183d287233c52228cfea3dbc2a127fe780f60564fcb0955d9c3d1cd23/brand_logo.png)
MySQL Database Replication Guide
8
• Configure Backup Executive as Passive Master
Finally, the script displays the steps necessary to configure the slave (or Passive Master),
including the correct parameters to pass to the
prepslave.sh
script on the Backup
Executive.
Replication Setup Step 1 of 3 complete!
- Copy the Dumpfile: dbforrepl.sql to the slave server.
- Record the Active Master Log File Coordinates and log in to the passive master
system.
system.
- Navigate to /opt/incontrol/etc/support.
- Once there, run the prepslave.sh script using the coordinates as follows:
./prepslave.sh -l mysql-bin.000001 -s 2645 -h 192.168.196.45 -d <location of
dbforrepl.sql>
dbforrepl.sql>
Once the slave is configured, return to this system and run the connect_to_passive.sh
script to complete the setup.
script to complete the setup.
3
Make a note of the following values from the screen output, which you need when
executing the
prepslave.sh
script.
The name of the MySQL log file, displayed in
MASTER_LOG_FILE=
The replication start coordinates of the log file, displayed in
MASTER_LOG_POS=
The name of the MySQL dump file
2.4 Configure Backup Executive as Passive Master
To configure the Backup Executive as Passive Master, copy the Production Executive dump
file to the Backup Executive, and then execute the
prepslave.sh
script. When completed,
the script displays instructions on the next steps you need to take to set up replication.
prepslave.sh
accepts the following parameters:
Parameter
Required
Description
-d <dump_filename>
Yes
Defines the name of the MySQL database dump
file.
-h <host_IP_address>
Yes
Defines the IP address of the current host or Master
server.
-l <log_filename>
Yes
Defines the name of the MySQL database log file,
as defined in the
MASTER_LOG_FILE=
statement.
-s <log_coordinate>
Yes
Defines the starting point coordinate in the log file
where replication begins, as defined in
the
MASTER_LOG_POS=
statement.
2.4.1 Copying the Production Executive Dump File
Before you execute the
prepslave.sh
script, copy the Production Executive dump file that
was created when you executed the
prepmaster.sh
script to the Backup Executive server.