![]() ![]() it is the main way of optimizing size of backups with Handy Backup. ![]() Differential changes are calculated on byte level, i.e. It is important to understand how these two methods work with MySQL Backup plug-in in Handy Backup. To restore a differential MySQL backup you only need two backups: first snapshot and differential changes. Differential backup is similar to incremental backup, with the only difference that it calculates changes from first full backup. Restoration of a given MySQL snapshot requires you to have a full chain of increments from the first to the last backup. Incremental backup allows you to perform backup multiple times and copy only incremental changes with each run. In Handy Backup, there are a number of advanced options and two main optimization techniques: To reduce costs, the software must allow creating backups in the most efficient way. In commercial environments databases grow rapidly and may occupy hundreds of gigabytes of disk space. To learn more about destinations supported by Handy Backup, please see Backup Storage.ĭifferential and Incremental MySQL Backup This method is relatively expensive, but for many companies losses incurred by each minute of database downtime may cost much more. Backing up to USB or FireWire drives is the fastest way to restore backups after data loss events. Still it is important to remember that optical discs have limited capacity, and restoration of backups will require a lot of manual work. It is much cheaper and easier to have multiple copies of your backups on DVD or Blu-ray discs, and distribute them across several safe places, than to have several hard drives. You can back up MySQL to DVD or other optical discs – many companies consider this approach the most convenient in terms of handling, transportability and price. However, this method relies on network connectivity, and downloading backups of large databases may take a lot of time. Using FTP server or a NAS backup storage is a good idea, because the database becomes protected from local disasters. When a disaster strikes, the "time is money" mantra receives its most concrete and meaningful expression: losses incurred during downtime tend to grow geometrically. This is why it is so important to select the most cost- and performance-effective storage for your data. If backups can’t be restored in reliable manner, they are worthless.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |