Shulou(Shulou.com)05/31 Report--

This article mainly explains the "MYSQL data enterprise backup", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "MYSQL data enterprise backup" bar!

MySQL enterprise backup

MySQL enterprise backup is an ideal solution for MySQL database backup.

Backup

The MySQL enterprise backup tool performs online "hot backup", non-blocking MySQL database backup. Full backups can be performed on all InnoDB databases without interrupting MySQL queries or updates. In addition, incremental backups are supported, backing up only data that has changed since the last backup. Another part of the backup, which supports specific tables or tablespaces to back up as needed.

Restore

The MySQL Enterprise backup tool can restore all data using a full backup. Consistent point-in-time recovery (PITR) enables database administrators to perform a restore to a specific point in time. Using MySQL backup and binlog, database administrators can also perform fine-grained rollforward recovery to a specific transaction. Partial restore allows you to restore part of the target table or tablespace. In addition, database administrators can restore backups to a separate location, or quickly establish replication configuration or management.

Compress

The MySQL Enterprise backup tool supports the creation of compressed backup files, which can save 70 to more than 90 percent of storage space compared to actual database files, reducing storage and other costs.

Characteristic advantage backup full backup full backup is for all InnoDB data incremental backups only partial backup of data changed since the last full backup specific tables and tablespaces InnoDB table online backup online backup No hindrance to query or update hot and cold backups for MySQL online and offline backup recovery full recovery can be completed from a full backup of InnoDB data point-in-time recovery (PITR) perform recovery and rollback to a certain point in time the backup can be rolled back to a specific transaction To obtain finer recovery granularity, partial recovery of specific tables or spaces, restore to a separate location, backup files of compressed InnoDB for fast establishment of replication configuration or management of advanced functional backups can be compressed and stored, saving up to 90% of blocking files backup of InnoDB tables completely online, querying or updating specific tablespaces or specific tables without blocking files improves performance Reduce backup time, reduce IO requirements dirty data detection copy InnoDB data and log files page checksum task synchronization allows other backup tasks to synchronize tasks in real time only the actual data is backed up without copying unused blocks. Use fewer reads and writes for backup and recovery, backup files take up less space for easy installation and high performance across the enterprise

Unlimited database size scalability, suitable for small to large databases running outside the MySQL process space outside the MySQL process space to run a separate process, can reduce risk and enhance performance. MySQL enterprise backup does not need to install any additional database programs, DLLs, scripts, stored procedures or table script interface command line interface in MySQL instance can be easily integrated into a variety of scheduling system storage engine backup multiple storage engines InnoDB, MyISAM, Merge, Partition, Archive backup MyISAM table MyISAM table replication, users can read the MyISAM table, but can not modify thank you for reading The above is the content of "enterprise backup of MYSQL data". After the study of this article, I believe you have a deeper understanding of the problem of enterprise backup of MYSQL data, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.