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. ...
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
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