Applying the Disaster Recovery Solution Fix
This fix for disaster recovery solution is only meant for Junos Space Network Management Platform Releases 18.3 and below.
To apply the fix for the disaster recovery solution:
- Execute the following command to apply changes for MySQL
replication issue on all the nodes of both the active and the standby
sites:
$ sed -i -e 's/mysqldump/mysqldump --max_allowed_packet=2G/g' /usr/nma/lib/DrUtil.pm
$ sed -i -e 's/mysqldump/mysqldump --max_allowed_packet=2G/g' /var/cache/jmp-geo/backup/script/backupReal.sh
Review the following changes:
- In the file /usr/nma/lib/DrUtil.pm:
Line 2271 my $code = system("/usr/bin/mysqldump --max_allowed_packet=2G --defaults-extra-file=$mysql_info -h $dbIp --quick --single-transaction --all-databases $tableIgnored $sequenceTableIgnored | sed -e 's/DEF INER[ ]*=[ ]*[^*]*\\*/\\*/' | /bin/gzip -c > $drMysqlDbFile"); - In the file /var/cache/jmp-geo/backup/script/backupReal.sh:
Line 52 /usr/bin/mysqldump --max_allowed_packet=2G --defaults-extra-file=$mysql_info -h $DB_IP --quick --single-transaction --all-databases $TABLE_IGNORE $SEQUENCE_TABLE_IGNORE | /bin/gzip -c > $DB_FILE
- In the file /usr/nma/lib/DrUtil.pm:
- Execute the following commands to apply fix for PgSQL
replication error on all the nodes of both the active and the standby
sites:
$ sed -i -e 's/grep receiver/grep \\\"wal receiver\\\"/g' /var/www/cgi-bin/secure/executeDrOperation.pl
Review the following change:
- In the file, /var/www/cgi-bin/secure/executeDrOperation:
sub isPgsqlReplicationGoing { my $out = NmaUtil::execAndLog1("ps -ef|grep \"wal receiver\" | grep -v grep", '0'); return $out; }
- In the file, /var/www/cgi-bin/secure/executeDrOperation: