Updated on 2022-02-22 GMT+08:00

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 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

Huawei@123