Cisco Cisco Prime Network Registrar 8.1 문제 해결 가이드
Chapter 4 Operations
Resynchronizing a Slave
• 15
promote_master.sh
accepts the following parameters:
Parameter
Required
Description
-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.
To execute the
promote_master.sh
script, follow these steps.
1
As
incadmin user on the Backup Executive, change directory
to
/opt/incontrol/etc/support
.
>cd /opt/incontrol/etc/support
2
Execute the script command.
>./promote_master.sh -l <log_filename> -s <log_coordinate>
For example:
>./promote_master.sh -l mysql-bin.000001 -s 87592
The script begins by allowing the Passive Master to mirror the content of the Active
Master, as determined by the log coordinate parameter you just entered and then makes
the database active by removing the read-only flag.
Waiting for Passive Master to catch up to Active Master using SELECT
MASTER_POS_WAIT('mysql-bin.000001', 87592) ...
MASTER_POS_WAIT('mysql-bin.000001', 87592) ...
+--------------------------------------------+
| MASTER_POS_WAIT('mysql-bin.000001', 87592) |
+--------------------------------------------+
| 0 |
+--------------------------------------------+
Removing read_only option from configuration file ...
Turning off read_only flag with: set @@global.read_only := 0
IPControl MySQL Replication Monitor install successful.
Promotion / Demotion Step 2 of 2 complete!
3
Remove any existing files under
$INCHOME/etc/support/log
.
4
Execute the following commands.
# $INCHOME/etc/incontrol stop
# $INCHOME/etc/support/PromoteExec.sh
# $INCHOME/etc/incontrol start