Home > Storage > Data Storage Essentials > Storage Resource Manager (SRM) > Dell SRM: Disaster Recovery and Federated Architecture > PROD PBE server
Replicate the master database from the PROD PBE server to the DR PBE server for DR architecture as follows:
PROD-PBE-HOSTNAME# /opt/APG/Databases/MySQL/Default/bin/mysqldump -hlocalhost -P 53306 -uapg -pwatch4net -S /opt/APG/Databases/MySQL/Default/data/mysql.sock master > /opt/APG/masterdb.sql
PROD-PBE-HOSTNAME# ssh-keygen
Copy your public ssh key over to the DR PBE server:
PROD-PBE-HOSTNAME# ssh-copy-id DR-PBE-HOSTNAME
PermitRootLogin yes
PubkeyAuthentication yes
PROD-PBE-HOSTNAME# scp /opt/APG/masterdb.sql root@DR-PBE-HOSTNAME:/opt/APG/. && ssh DR-PBE-HOSTNAME "chown apg:apg /opt/APG/masterdb.sql"
Here is a PROD PBE crontab configuration file for root user (crontab -e):
0 23 * * * /opt/APG/Databases/MySQL/Default/bin/mysqldump -hlocalhost -P 53306 -uapg -pwatch4net -S /opt/APG/Databases/MySQL/Default/data/mysql.sock master > /opt/APG/masterdb.sql && scp /opt/APG/masterdb.sql root@DR-PBE-HOSTNAME:/opt/APG/. && ssh DR-PBE-HOSTNAME "chown apg:apg /opt/APG/masterdb.sql"