Updated on 2024-04-19 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 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