Help Center/ Cloud Backup and Recovery/ Best Practices (Kuala Lumpur Region)/ Using a Custom Script to Implement Application-Consistent Backup/ Using a Custom Script to Implement Consistent Backup for MySQL/ Preparations
Updated on 2022-08-16 GMT+08:00
View PDF
Share

Preparations

The following example uses single-server MySQL 5.5 running on SUSE 11 SP3 to demonstrate how to use a custom script to freeze and unfreeze the MySQL database in order to implement application-consistent backup.

Context

An enterprise purchases Elastic Cloud Servers (ECSs) and installs MySQL 5.5 on ECSs for storing business data. As data increases, crash-consistent backup cannot meet the recovery time objective (RTO) and recovery point time (RPO) requirements and therefore application-consistent backup is needed.

Required Data

Table 1 Required data

Item

Description

Example

MySQL username

Username for connecting to the MySQL database

root

MySQL password

Password for connecting to the MySQL database

Example@123