Home > Storage > PowerFlex > White Papers > Deploying MySQL Database on Dell PowerFlex with NVMe over TCP > Data protection of MySQL using PowerFlex snapshot
MySQL provides several options of backup strategies such as physical backup of entire instances or selected databases, tables, or both. MySQL provides additional backup options using mysqldump or hot backup options. However, as databases size grow, a snapshot-based backup becomes more efficient compared to a logical backup due to the long duration and performance overhead incurred while restoring a huge amount of data.
Storage-based snapshots, when following the procedure to create valid database backups, take seconds to create, regardless of the database size. In addition, they offer faster recovery as their data is immediately available and does not need to be copied back.
This section describes the following use cases: