MySQL/MariaDB data backup and recovery under centos6.5 _ MySQL

Centos6.5 MySQLMariaDB data backup and recovery backup CentOS6CentOSMariaDB

MySQL/MariaDB data backup and recovery backup

Data is no longer important to us. how can we ensure the security of data as much as possible? what should we do when our data is lost, therefore, data backup is too important for our data security.

Data is no longer familiar to us, but it is also most common. we are exposed to various types of data every day, and the data records our common business information, therefore, data is very important for us. if such important data is lost, will it be impossible for us to do the relevant business, this should be a very troublesome issue. how can we protect the security of our data? we need to back up our data.

How to perform backup recovery: backup and recovery are the top priority in the work environment. why is backup and recovery required:

1. disaster recovery is generally implemented, such as natural disasters.

2. audit can be performed, such as what a data is like in the past.

3. for example, whether a new data storage method in the business architecture is accessible to the business

The purpose of backup is to recover data. if the backup data cannot be recovered when it is used, it is necessary to perform a recovery test on the backup data. In addition, we need to determine the sequence for testing.

Backup type: There are many types

Based on whether the database server is online during backup:

Cold backup: cold backup. the server must be offline, which means that read and write operations cannot be performed. this is the safest backup method and the most unreliable one.

Warm backup: warm backup, which applies a shared lock globally and is readable only. a non-writable backup is called a warm backup.

Hot backup: hot backup, database offline, read/write operations can be performed

InnoDB records data with a serial number. Therefore, the snapshot is automatically accelerated based on the MVCC (multi-Version Concurrency control) mechanism during Backup. each time a transaction is started, a snapshot of the current set is created, then, based on the MVCC mechanism, each serial number is recorded for it. during The backup, only the data before the serial number or serial number is backed up. otherwise, no backup will be performed, if the isolation level of a transaction is not particularly high, it will not affect the read/write operations of the transaction. in this way, the backup data must be consistent at the time point, so hot backup is required, it is generally completed by a transaction-based storage engine.

Classify data based on the data set during backup:

Full backup: full backup refers to the data of the entire database and the entire database of the current dataset.

Partial backup: only one copy of a table or a table is backed up. sometimes it is necessary to back up a single table.

Based on the backup interface (back up data files directly or export data through the mysql server)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] Next page