TECHNICAL WHITE PAPER
Disaster Recovery
for MySQL with
FlashArray


Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER
Contents
Introduction
Selecting the Right Disaster-recovery Solution 
Unified Block and File on FlashArray
Protecting MySQL with Backup Utilities 




Protecting MySQL Using FlashArray Data Services 
 
 
Summary 
Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER
Introduction

























Selecting the Right Disaster-recovery Solution







Tool Description Documentation
Backup Utilities
 


 


 


 


FlashArray Data Service
 


 


TABLE 1 
Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER
Unified Block and File on FlashArray






 

 
 
 
FIGURE 1 


 Data reduction

 High availability
 Always-on ransomware remediation

 On-demand data portability

 Rich data services

Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER
Protecting MySQL with Backup Utilities


mysqldump








note: mysqldump performs backup and restore operations on user-defined databases only.


FIGURE 2 
Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER
How to Use mysqldump

Method Syntax Examples
Backup
 





 

























Restore
 


 


















TABLE 2 
Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER



note: mysqldump requires the database to be temporarily locked during backup, which can impact database performance.
Performance




FIGURE 3 
Best Usage Scenarios




Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER
mysqlpump












FIGURE 4 
Uncomplicate Data Storage, Forever
TECHNICAL WHITE PAPER
How to Use mysqlpump

Method Syntax Examples
Backup
 





 













































Note:




Note: 


 

 

 

Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Method Syntax Examples
Restore
 


 






mysql -u<username>
-p<password>
--databases <dbname> <
<backup_le_name.extension>
mysql -uroot -ppassword --databases
database1 < db1_tb1.sql

To restore compressed backup les, rst decompress the backup le to the
required format and restore it.

lz4_decompress <backuplename.lz4> <backup.sql>, and then run the restore
com mand.

zlib_decompress <backuplename.zlib> <backup.sql>, and then run the restore
com mand.
TABLE 3 


Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Performance





FIGURE 5 
Best Usage Scenarios





MySQL Enterprise Backup








Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
FIGURE 6 
How to Use MySQL Enterprise Backup

Method Syntax Examples
Backup
 































Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Method Syntax Examples
Compression




















Incremental Backups


 

 

 
















 


 










Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Method Syntax Examples




















 
























TABLE 4 



Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Performance




FIGURE 7 
Best Usage Scenarios




Percona XtraBackup











Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
FIGURE 8 
How to Use Percona XtraBackup



Method Syntax Examples
Backup
 
















 













Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Method Syntax Examples










 


















TABLE 5 
Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Prepare Incremental Backups Syntax Examples


xtrabackup --prepare
--apply-log-only
--target-dir=<backup_dir_
path>
xtrabackup --prepare
--apply-log-only
--target-dir=/backup/xbp/














 


 





































TABLE 6 



Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Performance




FIGURE 9 


FIGURE 10 
note: The throughput for XtraBackup restores remains consistent whether the backup is compressed or uncompressed. This is
because Percona Xtrabackup compresses data in real-time during backups, necessitating decompression of backup files before
restoration can begin.
Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Best Usage Scenarios





note: Percona XtraBackup works with FlashArray File only when using Purity 6.4.2 and later.
Protecting MySQL Using FlashArray Data Services



Pure Storage Volume Snapshots and Asynchronous Replication





 Efficiency

 No snapshot hierarchy

 No performance degradation

 Portability

 Rapid recovery




Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER





FIGURE 11 
How to Use
1. Configuration

2. Volume creation:


3. Volume mapping:

4. Snapshot creation: 


5. Restore from snapshot:



6. Snapshot scheduling and monitoring:


Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
Outcomes for Administrators





ActiveDR









 POD replication


 Continuous change tracking

 Single-command failover


 Multi-direction replication

FIGURE 12 
Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER





How to Use Active DR
1. Purity ActiveDR configuration

2. Purity installation
3. Primary storage-node configuration

4. Secondary storage-node configuration

5. Replication settings configuration

6. Configuration testing

7. Purity ActiveDR system monitoring


note: It is important to note that while Purity ActiveDR can provide real-time replication and failover capabilities, you should
carefully plan and test the system before using it in a production environment. You should also be familiar with DR procedures and
should plan for the possibility of data loss or corruption in the event of a failure.
Outcomes for Administrators






Uncomplicate Data Storage, Forever

TECHNICAL WHITE PAPER
purestorage.com 800.379.PURE
PS2422-02-en 02/24
©2024 Pure Storage, the Pure Storage P Logo, ActiveCluster, ActiveDR, Evergreen, FlashArray, FlashArray//C, FlashArray//X,
FlashArray//XL, FlashArray//E, Pure Cloud Block Store, Pure1, SafeMode, and the marks in the Pure Storage Trademark List are
trademarks or registered trademarks of Pure Storage Inc. in the U.S. and/or other countries. The Trademark List can be found at
purestorage.com/trademarks. Other names may be trademarks of their respective owners.
Summary











