How to set up the Disaster Recovery Environment for QMetry?

In the event of disasters, when your production server becomes unavailable, it is important to have a disaster recovery system in place to rely on. With such a system, we can get back on track without wasting valuable time and continue our work as usual. In the section below we are sharing the pre-requisites and the setup process that you can follow for setting up the Disaster Recovery Environment on your on-premise instance.

Pre-requisites
  • To have a disaster recovery setup you should have QMetry and Reports Installed on servers separate from production.

  • Database backup taken regularly based on your company policy should be ready to restore to the DR database server. This back up will be used to restore your data at the time of DR. Any data created after the time of the back up taken would not be available on the DR.

  • The DR environment should always be on the same version as the production. Whenever you upgrade production make sure the DR environment is also upgraded to the same version.

  • Since DR will have the currently available latest version of QMetry, therefore to certify the setup, ensure that your QMetry DR version and QMetry Production versions match.

Set up your DR as follows

  • Get new servers for QMetry, Reports, and/or database. Refer to the Deployment Guide for the architecture you want to follow. Assuming you would set up the 3 Tier Architecture (QMetry App, DB, and Reports on separate servers) you can follow step 2.

  • Install QMetry, MySQL DB, and Reports based on the Installation guide (3 Tier).

    • The installation is available for the latest version 8.7 only.

Steps in sequence at the time of DR:

  • Step 1 - Restore your QMetry DB to the DR database server.

  • Step 2 - Get the license file for QMetry by creating a ticket on the support portal with the mac address of your QMetry app server. Apply the license and restart services for both App and Reports.

  • Step 3 - Update the QMetry URL in the Jira app to redirect the integration on the new QMetry DR server.

  • Step 4 - Update the reports URL from QMetry "admin" login > Customization > Insights Configuration > Database Configuration and Sync Data tabs and run the Reports Sync.

Note: Ensure the QMetry version of production and DR are matching as mentioned in the pre-requisites.