Backing up MySQL Arcadia metadata from one environment (Production) and restoring it another (Disaster Recovery)

In certain environment configurations you may have the desire to migrate and restore Arcadia metadata one-time to an upper (i.e. Production) or secondary environment (i.e. Disaster Recovery (DR)). Some environment configurations may even do this more frequently if backing up to a Disaster Recovery environment to ensure that Arcadia metadata remains intact.

Below is a MySQL example of the what steps can be followed to back-up the Arcadia metadata in a lower environment and successfully migrate it to another environment:

MySQL Example:

Backup from Production

As non-root user:

mysqldump --databases arcadia --single-transaction 
--user=<USER> --password > arcadia_database_20191121.sql

As root:

mysqldump --databases arcadia --single-transaction > 
arcadia_database_20191121.sql

Create new database, Arcadia user, and grants to Arcadia database in DR

CREATE DATABASE arcadia DEFAULT CHARACTER SET utf8;
CREATE USER 'arcadia'@'%' IDENTIFIED BY '<password>';
GRANT ALL ON arcadia.* TO 'arcadia'@'%’;

Restore database in DR

mysql -u arcadia -p arcadia < arcadia_database_20191121.sql