Data Domain - DDBoostFS Plug-In Application Validation and Best Practices for MySQL: Percona Xtrabackup

Riepilogo: This kb provides best practices and configuration guidelines for applications with the Data Domain DD Boost File System Plug-In (BoostFS). In addition, the kb contains insights and tips on how the application should be configured to maximize all the benefits of BoostFS. Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server, MySQL®, and MariaDB®. Percona XtraBackup**, downloaded over a million times, ensures uninterrupted application availability during planned maintenance by performing secure, non-blocking, and compressed backups on transactional systems. It is a reliable MySQL hot backup solution that maintains server performance in production environments. ...

Questo articolo si applica a Questo articolo non si applica a Questo articolo non è legato a un prodotto specifico. Non tutte le versioni del prodotto sono identificate in questo articolo.

Istruzioni

Setup BoostFS
Install BoostFS on the MySQL server to be backed up.

Create a mount point /backup and mount DD Storage Unit using BoostFS.

Disable compression and encryption

 

--compress[=name] Compress individual backup files using the specified compression algorithm.

Currently the only supported algorithm is 'quicklz'. It is also the default algorithm, i.e. the one used when --compress is used without an argument.

By default compression is disabled, so backup command without this option will backup without compression.

--encrypt=name Encrypt individual backup files using the specified encryption algorithm.


Configure multiple streams

CLI option --parallel as shown in above backup/restore command enables multi-stream (<64).


How to perform a backup.

/usr/bin/xtrabackup --user=root --password=Password@123 --host=ostqa-len35.datadomain.com --port=3306 --databases=db1 --
parallel=50 --backup --target-dir=/mounts/bfs/gen0 --data-dir=/mnt/1tbpart/mysql &> xtrabackup-$BFSPREFIX.out


How to perform a restore.

/usr/bin/xtrabackup --user=root --password=Password@123 --host=ostqa-len35.datadomain.com --port=3306 --databases=db1 --
parallel=60 --copy-back --target-dir=/mounts/bfs/gen0 --data-dir=/mnt/1tbpart/mysql &> xtrabackup-$BFSPREFIX.out


Best Practices - Percona Xtrabackup
1. Disable software compression and encryption for better datadeduplication.
2. Enable multiple streams for greater throughput.
3. Multi-stream recovery is not supported.
4. Up to 63 streams per BoostFS plug-in.

Extra Command options for boostfs mount from Configuring and using BoostFS for both Windows and Linux Guides. 
 

Option Description
-o allow-others=<true | false>

Allow users on the client system other than the owner of the boostfs mount. 

Default value: false

 

Informazioni aggiuntive

This white paper focuses on the deployment and configuration of Dell EMC™ DD Boost - File System (BoostFS) for Windows and Linux application hosts. 

Boostfs Drivers & Downloads
https://www.dell.com/support/home/en-us/product-support/product/data-domain-boost-file-system/drivers

Boostfs configuration guides 
https://www.dell.com/support/home/en-us/product-support/product/data-domain-boost-file-system/docs

 
 

Prodotti interessati

Data Domain
Proprietà dell'articolo
Numero articolo: 000206566
Tipo di articolo: How To
Ultima modifica: 30 set 2025
Versione:  3
Trova risposta alle tue domande dagli altri utenti Dell
Support Services
Verifica che il dispositivo sia coperto dai Servizi di supporto.