Data Domain - DDBoostFS Plug-In Application Validation and Best Practices for MySQL: Enterprise Backup

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. MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking backups on multiple platforms including Linux. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

Setup BoostFS
Install BoostFS on the MySQL server to be backed up.
Create a mountpoint /backup and mount DD Storage Unit using BoostFS.

How to disable compression and encryption:

--compress=TRUE/FALSE (default) by default compression is disabled, so backup command without this option will backup without compression.
--encrypt=TRUE/FALSE (default) by default encryption is disabled, so backup command without this option will backup without encryption.


How to perform a backup.

mysqlbackup --no-defaults --debug --force --trace=0 --user=root --password=passwd --host=ostqa-len35.datadomain.com --port=3306 --with-timestamp --backup-dir=/mounts/bfs/si-gen1 --backup-image=/mounts/bfs/si-gen1.img backup-to-image &> mysqlbackup-$BFSPREFIX.out


How to start a restore.

mysqlbackup --no-defaults --debug --force --trace=0 --user=root --password=passwd --host=ostqa-len35.datadomain.com --port=3306 --with-timestamp --backup-dir=/mounts/bfs/si-gen1 --backup-image=/mounts/bfs/si-gen1.img --datadir=/mnt/1tbpart/mysql copy-backand-apply-log &> mysqlbackup-$BFSPREFIX.out


Best Practices - MySQL Enterprise Backup
1. Disable software compression and encryption for better datadeduplication
2. Avoid using incremental backup
3. One backup stream per database

Extra Command options for boostfs mount from Configuring and using BoostFS for Windows Guide. 
 

- O data - cache=<enable|disable> Option to enable data-cache which results in performance improvement for MSSQL multi-streams environment.
Default value: Disable



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 mount to mount BoostFS.

Default value: false

Additional Information

Affected Products

Data Domain
Article Properties
Article Number: 000206562
Article Type: How To
Last Modified: 24 Sep 2025
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.