Include Tables - Backup only required tables for better granularity and usability.Binlog and Relay log backup - Simplifies cloning source to replica servers for HA replication.Exclude Tables - Exclude unnecessary tables from your Backups, saving backup time and space.Backup Validation - Provides assurance checks to confirm backup integrity and quality by confirming that internal pages are valid and file checksums match.Streaming "Zero storage" Single Step Backup and Restore - Run a full or partial backup from one server and a restore to another in one streamed step without staged storage.Supports MySQL TDE - Enables secure archival quality backup and restore of TDE encrypted database files and keys.AES 256 encryption - Built in 256-bit Advanced Encryption Standard (AES) encryption to secure all the sensitive backup data.Advanced LZ4 Compression - Support highly efficient, low impact and ultra fast LZ4 compression, as well as LZMA and zlib.Direct Cloud Storage Backup via S3 and Swift APIs - Backup and Restore directly to/from Oracle Storage Cloud, S3 and other Cloud Storage using AWS S3 API.Technique 2 would bypass folders that do not contain mysql. The informationschema would register the folder as a database in the informationschema.schemata table. Online "Hot" Selective Restore - bring back only selected tables into a running database Technique 2 is better because, sometimes, users create folders for general purposes in /var/lib/mysql (datadir) which are not database related.Point-in-Time Recovery (PITR) - Recover to a specific transaction.Fast Recovery - Get servers back online and create replicated servers.Advanced Optimistic Backup - Uses heuristics to optimize and reduce backups and shorten recovery time by assessing usage patterns.Full Instance Backup - Backs up data, as well as configuration and other information to easily create a complete "replica".Partial Backup - Target particular tables or tablespaces.Incremental Backup - Backup only data that has changed since the last backup.High Performance - Save time with faster backup and recovery."Hot" Online Backups - Backups take place entirely online, without interrupting MySQL transactions.Export all the databases one by one to separate SQL dump files. Read this wiki: How to Add This Library into Your Project. How to Add This Library into Your Project. It delivers hot, online, non-blocking backups on multiple platforms including Linux, Windows, Mac & Solaris. A tool to backup and restore MySQL database in C/VB.NET/ASP.NET. MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. Only available in select Commercial Editions
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |