Data Domain: DDBoostFS Plug-In Validation and Best Practices for MySQL Enterprise Backup
Summary: This KB article provides best practices and configuration guidelines for applications with the Data Domain DD Boost File System Plug-In (BoostFS). In addition, this article contains insights and tips about 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. ...
Instructions
Set up 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 run 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
- Disable software compression and encryption for better data deduplication.
- Avoid using incremental backup.
- One backup stream per database.
Extra Command options for boostfs mount from the Configuring and using BoostFS for Windows Guide:
- O data - cache=<enable|disable> |
Option to enable data-cache which results in performance improvement for MSSQL multistreams environment. Default value: Disable |
Extra Command options for boostfs mount from the 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 mount-to-mount BoostFS owner. Default value: false |
Additional Information
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