Azure Databases: Decommissioning Redcap Database Steps

This document details the step by step process that will be undertaking before redcap database can be decommissioned.

Step 1: Backing up database on RIS server

• To ensure we can recover the data if needed, we will need to take a backup of the database.

• Taking a backup on the RIS server allows us to back up the database without any outside interruptions such as network or power outages.

• To perform the backup, we will need to login into the source database:

  • We’ll be backing up the following source database instances:
    • i2-redcap-dev-flex-mysql-02
    • redcap-qa-mysql-flex
    • 2-redcap-prod-mysql-flex

• to start, we’ll need to log into the RIS server, initialize the appropriate MySQL database image and test the connectivity to the database we want to back up:

• Next, after successfully testing the connectivity, we’ll then proceed to backing up the database and store it in the following directory /storage1/fs1/I2/Active/rdc2_etl/REDCap/backups directory

• All decommissioned database backups will follow this naming convention:
  • redcap_appd87m1_dev_decomm_120424.sql
  • redcap_appq32m1_qa_decomm_120424.sql
  • redcap_appp60m1_prod_decomm_120424.sql

script to perform database backups

time mysqldump -u andikefor -p -h 10.24.96.136  redcap_appd87m1 > redcap_appd87m1_dev_decomm_120424.sql

time mysqldump -u andikefor -p -h 10.24.96.133 redcap_appq32m1 > redcap_appq32m1_qa_decomm_120424.sql

time mysqldump -u andikefor -p -h 10.24.96.134 redcap_appp60m1 > redcap_appp60m1_prod_decomm_120424.sql