Backup and Restore
Backing up the MyQ database on the MS Cluster
The automatic and manual backup processes do not differ from the standard backup processes described in “Backing up MyQ Data”. The only setting that requires special attention is the backup destination folder. It is recommended to save the backup files on the shared cluster disk.
Restoring the MyQ database on the MS Cluster (all nodes)
Before restoring the MyQ database, MyQ has to be installed and set up on all the MS Cluster nodes.
Now you need to restore the MyQ database and settings on the active node of the Cluster (the current owner of the MyQ server role) via the following steps:
Start All services via MyQ Easy Config.
Open the Database tab in MyQ Easy Config.
In the Main Database section, click Restore.... Select the database _*.zip file, and click Open. If the backup is password protected, there is a prompt to provide the password. The database is restored and, if needed, upgraded as well.
Repeat the process for all the other nodes.
Using Database Encryption
If you are using the Database Encryption feature in MyQ Easy Config, it is necessary to perform the following steps after encrypting or restoring your database:
Stop all Cluster resources except for Storage and Server Name.
Open MyQ Easy Config on the active node and start all services.
Enable DB encryption.
Stop All services in MyQ Easy Config.
Copy the DB encryption key to all the other nodes. The key is located by default in
“C:\Program Files\MyQ\Firebird\plugins\keyholder.conf”.Start All MyQ services in MyQ Easy Config, and bring all the resources online via Failover Cluster Manager.