Hi,
What is the limit size to generate a backup using mysqldump?
For example i have a database size from about 20 GB, it is a good a idea to generate a backup using mysqldump?
What about taking a snapshot in linux?
Thanks.
Hi,
What is the limit size to generate a backup using mysqldump?
For example i have a database size from about 20 GB, it is a good a idea to generate a backup using mysqldump?
What about taking a snapshot in linux?
Thanks.
I would test a restore with it and see how long it takes. Is it acceptable? If not, then you will need something else, like XtraBackup or LVM snapshots.
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.