The MariaDB database management system is a branch of MySQL. It is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that Oracle has the potential risk of shutting down the source of
I. Purpose of the backup
Disaster recovery. Recovering corrupted data in the event of a disaster
Audit. What is the database at a certain point in time?
Test. Test if new features are available
Second, the classification
Topics We are not going to include:Security (Access to backup, permissions to restore data, whether files need to be encrypted) where backups are stored, including how far they should be from source data, and how to move data from source to
Summary of use of MySQL database InnoDB data recovery tool bitsCN.com This article introduces an open-source MySQL database InnoDB data recovery tool: innodb-tools, it extracts table row records from raw data files to restore data from lost or
MySQL online backup and recovery tools --> XtraBackup
1 Overview of Xtrabackup principles
Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to
If the data in the MySQL production database on the line is mistakenly deleted, and the DBA goes to recover the data, it is discovered that the database is not backed up, Binlog, or open. Is there any other means to try to recover the data? Percona
We know that data is at the heart of an enterprise IT architecture, and in order to prevent data loss or some other special purpose for some accidental reasons, it is especially important to make backups of the data at the usual times.First, why to
Mysql-12-mysql backup and recovery, mysql-12-mysql backup
1. Database Backup
Backup = copy and management to prevent data loss and record user operation records. The most effective backup is to back up the IT architecture.
Principles:
(1) databases
I. mysqldump backup combined with Binlog log recovery MySQL backups generally take the form of full-Library backups plus log backups, such as performing a full backup every day, and a binary log backup every hour. This allows you to recover data to
The MariaDB database management system is a branch of MySQL. It is mainly maintained by the open-source community and licensed by GPL. One of the reasons for developing this branch is that Oracle has the potential risk of shutting down the source of
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.