Cisco Cisco Prime Network Registrar 8.1 Troubleshooting Guide
4 Appendix A
4.1 MySQL Replication Disaster Recovery Scenarios
Scenario
Seq
Original Production
Executive
DR Executive
New Production
Executive
New Setup
1
prepmaster.sh
(creates dump file)
2
scp
dump file from Production
Executive
3
prepslave.sh
using
coordinates from Production
Executive
4
connect_to_passive.sh
using coordinates from
DR
Executive
Scheduled
Downtime
for
Production
Executive
1
demote_master.sh
2
promote_master.sh
using coordinates
from Production
Executive
using coordinates
from Production
Executive
3
Bring System Down
Scheduled
Downtime
for
Production
Executive
– Recovery
1
Bring System Back Up
2
demote_master.sh
3
promote_master.sh
using coordinates
from DR Executive
using coordinates
from DR Executive
DR –
Change IP
of DR
Executive
1
System Goes Down
2
Change IP Address to
Production Exec. IP
3
promote_masters.sh –c
4
Operate until Prod. Exec. Is
stabilized or new one is
obtained.
DR – Fail
Back with
Change of
IP
1
Change IP Address back to
original DR Exec. IP
2
prepmaster.sh –d
(creates dump file)
3
Power On
4
scp
dump file