Data Domain - DDBoostFS Plug-In Application Validation and Best Practices for MySQL: Percona Xtrabackup
Summary: 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. ...
Instructions
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 |
Additional Information
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