- What's New
- Service Overview
- Getting Started
- User Guide
-
Best Practices
- Using a Custom Script to Implement Consistent Backup for MySQL
- Using a Custom Script to Implement Consistent Backup for SAP HANA
- Using a Custom Script to Implement Consistent Backup for Other Linux Applications
- Troubleshooting a Custom Script Error
- Verifying the Application-Consistent Backup Result (Linux)
- Verifying the Application-Consistent Backup Result (Windows)
- Protecting SQL Server in Failover Cluster Mode
- Protecting SQL Server in Always on Availability Groups Mode
- Change History
- API Reference
-
FAQs
-
About Concepts
- What Is CSBS?
- What Are Full Backup and Incremental Backup?
- What Is Consistent Backup?
- What Are the Differences Between CSBS and VBS?
- What Is a Backup Policy?
- What Are the Differences Between Backup and Disaster Recovery?
- What Are the Differences Between Backup and Snapshot?
- Why Is the Disk Space Usage Displayed in the File System Different from the Backup Size?
-
About Pricing
- How Is CSBS Billed?
- How Do Yearly/Monthly Resource Packages Function When I Have Bought More Than One?
- Are CSBS and VBS Resource Packages Interoperable Between CSBS and VBS?
- Why Am I Charged in Pay-per-use Mode Although I Have Purchased Resource Package?
- What Exactly Are the Function Package and the Storage Package?
- Will the CSBS Backups Displayed on the VBS Page Be Charged Repeatedly?
- How Do I Query CSBS Pay-Per-Use Billing Details?
- Why Is the Fee Deducted After a Backup Is Deleted?
- How Do I Disable CSBS?
- How Do I Stop CSBS from Charging?
-
About Backup
- Does CSBS Support Backing Up All EVS Disks on an ECS?
- Do I Need to Stop the ECS Before Backing It Up?
- Can an ECS with Application Systems Be Backed Up?
- What Are the Minimum Backup Frequency and Maximum Number of Retained Backups Supported by CSBS?
- How Can I Distinguish Automatic Backups From Manual Backups?
- How Can I Configure a Backup Policy?
- Can I Choose to Back Up Only Some Partitions of a Disk?
- Does CSBS Support Cross-Region Backup for ECSs?
- Which Types of Databases Can Be Backed Up Using Database Server Backup?
- How Do I Select Among Database Server Backup, Cloud Server Backup, and Disk Backup?
- How Do I Migrate ECS Data Across Regions Using CSBS?
- Which Time Zone Is the Automatic Backup Time Based On?
- What Can I Do If a Backup Cannot Be Deleted?
- About Restoration
- Others
-
About Concepts
- Troubleshooting
- Videos
- Glossary
-
More Documents
-
User Guide (Paris and Amsterdam Regions)
- Service Overview
- Getting Started
- Management Operations
-
FAQs
- About Concepts
-
About Backup
- Does CSBS Support Backing Up All EVS Disks on an ECS?
- Do I Need to Stop the ECS Before Backing It Up?
- Can an ECS with Application Systems Be Backed Up?
- What Are the Minimum Backup Frequency and Maximum Number of Retained Backups Supported by CSBS?
- How Can I Distinguish Automatic Backups From Manual Backups?
- Does CSBS Support Cross-Region Backup for ECSs?
- About Restoration
- Others
- Troubleshooting Cases
- Change History
- API Reference (Paris and Amsterdam Regions)
-
User Guide (Paris and Amsterdam Regions)
- General Reference
Show all
Copied.
Procedure
- Encrypt the MySQL password.
- Log in to the MySQL server and run the cd /home/rdadmin/Agent/bin/ command to go to the Agent directory.
- Run the /home/rdadmin/Agent/bin/agentcli encpwd command. The following information is displayed:
Enter password:
Enter the MySQL password and press Enter. After the encrypted password is displayed, copy it to the clipboard.
- Run the cd /home/rdadmin/Agent/bin/thirdparty/ebk_user command to go to the directory saving the custom scripts and run the vi mysql_freeze.sh command to open the example MySQL freezing script.
The following figure shows an example. You need to set MYSQL_USER and MYSQL_PASSWORD based on your actual conditions, where MYSQL_PASSWORD should be the encrypted password obtained in step 1.
You can also run the sed command to modify the configuration:
sed -i 's/^MYSQL_PASSWORD=.*/MYSQL_PASSWORD="XXX"/' mysql_freeze.sh mysql_unfreeze.sh, where XXX indicates the password obtained in step 1.
If you run this command, both the freezing and unfreezing scripts will be modified and therefore step 3 is not needed.
- Run the vi mysql_unfreeze.sh command to open the example MySQL unfreezing script and change the username and password in the script to be consistent with your actual settings.
The mysql_unfreeze.sh and mysql_freeze.sh scripts can only be used to freezing and unfreezing databases. If other operations are required, you can add them in the scripts via compilation. For details, see Using a Custom Script to Implement Consistent Backup for Other Linux Applications.
CAUTION:
MySQL is frozen by running the FLUSH TABLES WITH READ LOCK command. This command will not trigger disk flushing on bin log. If bin log is enabled and the value of sync_binlog is not 1, some SQL operations saved in the backup image may not be recorded in bin log. To realize complete protection on bin log, set sync_binlog to 1.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot