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

요약: 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. ...

이 문서는 다음에 적용됩니다. 이 문서는 다음에 적용되지 않습니다. 이 문서는 특정 제품과 관련이 없습니다. 모든 제품 버전이 이 문서에 나와 있는 것은 아닙니다.
기타 리소스 확인

지침

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

추가 정보

해당 제품

Data Domain
문서 속성
문서 번호: 000206562
문서 유형: How To
마지막 수정 시간: 24 9월 2025
버전:  3
다른 Dell 사용자에게 질문에 대한 답변 찾기
지원 서비스
디바이스에 지원 서비스가 적용되는지 확인하십시오.