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. 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.
1. Logical Backup Using Mysqldump
Mysqldump is a powerful and important MySQL backup tool that that performs logical backups. It is worthwhile to fully familiarize yourself with the various backup parameters and restoration policies of mysqldump.
Back up a single database or a specified table in a single database:
mysqldump [OPTIONS] database [tb1] [tb2]…
Back up multiple databases:
mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3…]
Back up all databases:
mysqldump [OPTIONS] –all-databases [OPTIONS]
2. Restoration from Physical Backup Using Xtrabackup
Xtrabackup is a MySQL database backup tool provided by Percona. According to the official introduction, “Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.” Xtrabackup can be used to perform incremental or full physical backups for MySQL databases.
3. Database Backup Using innobackupex
innobackupex –user=root -p /home/backup/
Files after the backup:
During the backup, a directory named according to the current data and time will be created under the backup directory to store the backup files.
For details, you can go to this tutorial.
Related Blog Posts
Using binary log files and positions to synchronize RDS data to a local database may easily be interrupted. This is because the positions of the RDS binary logs to which the local database points change (binary log positions differ between the master and slave nodes) when a failover, restart, or inter-node migration occurs on RDS. But the RDS 5.6 version employs the new synchronization method, i.e., GTID which can help to synchronize data between ECS and RDS without interruption whenever a failover, reboot, or migration occurs.
In this article, you will get some information on how to synchronize the data from ApsaraDB RDS for MySQL to a local user-defined database.
MySQL is the world’s most popular open-source database. As an important part of LAMP, a combination of open-source software (Linux + Apache + MySQL + Perl/PHP/Python), MySQL is widely used in various applications. Chinese Internet forum system Discuz! and blogging platform WordPress, which swept the Internet in the Web 2.0 era, are both built based on a MySQL-based underlying architecture. In the Web 3.0 era, leading Internet companies such as Alibaba, Facebook, and Google have all built mature and large database clusters based on the more flexible MySQL.
Related Market Products
Websoft9 MySQL is a pre-configured, ready to run image for running MySQL on Alibaba Cloud.MySQL is the world’s most popular open source database.
MySQL and MariaDB client for database management, administration and development. With the help of this intelligent MySQL client the work with data and code has become easier and more convenient.
This topic describes how to migrate a MySQL database from Google Cloud to Alibaba Cloud and the corresponding precautions.
DTS can migrate data from on-premises Oracle databases to RDS for MySQL databases for schema migration and existing data migration. This document introduces how to configure a data migration task in the DTS console to migrate data from an on-premises Oracle database to an RDS for MySQL database.
MySQL is one of the most popular open-source databases in the world. As a key component of the open-source software bundle LAMP (Linux, Apache, MySQL, and Perl/PHP/Python), MySQL has been widely applied to different scenarios.
Data Transmission Service (DTS) helps you migrate data between data storage types, such as relational database, NoSQL, and OLAP. The service supports homogeneous migrations as well as heterogeneous migration between different data storage types.
Most applications use structured database software for data storage, such as: My SQL, SQL Server, Oracle. This course introduces the basic concepts of structured data storage, storage modes, and data migrations, focusing on how to use the Alibaba Cloud data migration service and DTS(Data Transmission Service) for structured data migration to the cloud.