Help Center/ Cloud Backup and Recovery/ Best Practices (ME-Abu Dhabi Region)/ Using a Custom Script to Implement Application-Consistent Backup/ Verifying the Application-Consistent Backup Result (Linux)
Updated on 2022-02-22 GMT+08:00
View PDF
Share

Verifying the Application-Consistent Backup Result (Linux)

After application-consistent backup is implemented using customized scripts, perform the following operations to check whether the backup is successful: This section uses the MySQL database as an example.

  1. Log in to MySQL database and create a database.
  2. After the database is created, create a stored procedure. For details, see Figure 1.

    Figure 1 Creating a stored procedure

  3. Log in to CBR Console and create an application-consistent backup for the desired ECS.
  4. After the backup is complete, open the /home/rdadmin/Agent/log/rdagent.log file and view the freezing and unfreezing logs to determine the freezing and unfreezing times.
  5. Use the newly created application-consistent backup to restore the ECS. After the restoration is successful, log in to the ECS and database and check the time when the last data record is inserted.
  6. Compare the VSS freezing success time recorded in step 5 with the time recorded in step 4. Before the freezing is successful, data insertion is stopped. Therefore, the time in step 5 should be earlier than that in step 4. If the time in step 5 is earlier than that in step 4, the backup is successful.