Not the answer you need?
Register and ask your own question!

Restore of Backups faster.

ca1990ca1990 Current User Role Contributor

Hi There

How to restore the backups fastly at Percona MySQL ...Is there any specific tool..?

backup size is 200GB.

OS : Ubuntu 18 LTS

Best Answer

Answers

  • matthewbmatthewb Senior [email protected] Percona Staff Role

    Hello @ca1990 , the fastest methodology for backups is doing disk-based snapshots. If this is not something you can do, the next fastest is physical backup using a tool like Percona XtraBackup. This is fast to backup and fast to restore.

    The slowest method is logical, using mysqldump. This is slowest to backup and slowest to restore.

    Your backup is 200GB? What style? Logical? Physical? What tool did you use to take the backup?

  • ca1990ca1990 Current User Role Contributor

    @matthewb

    I use percona xtrabackup.

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.