1. Download the RDS official extract tool kit: rds_backup_extract.
An RDS backup file is a compressed package. It must be extracted first. Download the extract tool here rds_backup_extract (sh file). Currently, the tool kit only supports 64-bit Linux systems.
bash rds_backup_extract -f backup.tar.gz/back.xb.gz -C directory
2. Install the backup restoration tool: Percona XtraBackup 2.2.
RDS backup uses Version 2.2.9, so we recommend you download Version 2.2.9 or a later version.
3. Extract backup files
bash rds_backup_extract -f /home/mysql/backup/hins575175_xtra_20150429091224.tar.gz -C /home/mysql/data
4. Restore data using the backup file
innobackupex --defaults-file=/home/mysql/data/backup-my.cnf --apply-log /home/mysql/data
If it displays "completed OK", the operations was executed successfully.
5. Configure the environment
Due to version issues, comment out innodb_fast_checksum, innodb_page_size and innodb_log_block_size in backup-my.cnf in the extracted files.
6. Modify the file owner
Modify the file owner and confirm that the file belongs to the mysql user.
chown -R mysql:mysql /home/mysql/data
7. Start the mysqld process and log on for verification
mysqld_safe --defaults-file=/home/mysql/data/backup-my.cnf --user=mysql --datadir=/home/mysql/data &
8. Execute the following SQL statements and then create new users as the mysql.user table does not contain users created in the RDS:
delete from mysql.db where user<>'root' and char_length(user)>0; delete from mysql.tables_priv where user<>'root' and char_length(user)>0; flush privileges;
For details, you can go to Database Backup and Restoration Solutions.
You can configure a backup policy to adjust the cycles of RDS data backup and log backup. As a result, RDS enables the auto-backup feature. You can also manually back up RDS data.
Instance backup files occupy backup space. Charges are incurred if the used space exceeds the free quota. You must set a backup cycle appropriately to cater to the service requirements based on the available backup space.
ApsaraDB supports data backup and log backup. To recover data to a point in time, you must enable the log backup function.
And you will also learn the backup policies and how to configure automatic backup and manual backup in this document.
Create backups. Up to 10 backups can be created for an instance in a single day. The following conditions must be met, otherwise backup creation will fail:
This API is used to modify the backup policy. The RDS system periodically backs up instances according to the user-defined system configuration.
Alibaba Cloud Database Backup Service (DBS) is a secure and cost-efficient solution for continuous data protection. The service offers strong protection for data stored in multiple environments, such as enterprise data centers, hybrid clouds, public clouds, and third-party cloud vendors.
In this article, we will show you how to make use of the new Database Backup Service to perform database backup and restore process.
This article mainly introduces the principles of MySQL database backup and restoration, so that you can better understand the ApsaraDB for RDS backup and restoration mechanisms. Specifically, we will be exploring how to create physical and logical backups on ApsaraDB for RDS using mysqldump, Percona XtraBackup, and innobackupex.
If you are not familiar with these two types of backups, then you should definitely read up about them, as these two backups can be crucial to maintaining stable business operations. Basically, physical backup is just a physical copy stored in another location by merely copying files. This can be done through a hot backup or a cold backup. Logical backup on the other hand focuses storing data elements, and can be useful when it comes to more granular recovery. Instead of focusing on the differences of these two backups, you should focus on integrating them to provide a more robust backup solution.
ApsaraDB for RDS uses mysqldump to logically back up data to the MySQL database. XtraBackup can be used for a full physical backup at the instance level.
Alibaba Cloud Database Service has been recognized as A Strong Performer by Forrester. To celebrate the achievement and progress made by Alibaba Cloud database, we are now giving out attractive offers exclusively for our customers. Please refer to the Terms and Conditions section for details and rules of the offers.
Alibaba Clouder - August 1, 2019
Alibaba Clouder - August 2, 2019
Alibaba Clouder - February 24, 2020
Alibaba Clouder - August 2, 2019
Alibaba Clouder - July 5, 2019
Jack008 - May 6, 2020
More Posts by Alibaba Clouder