Data Domain: DD BoostFS Plug-In Validation and Best Practices for MySQL my dumper

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

Ten artykuł dotyczy Ten artykuł nie dotyczy Ten artykuł nie jest powiązany z żadnym konkretnym produktem. Nie wszystkie wersje produktu zostały zidentyfikowane w tym artykule.
Sprawdź inne zasoby

Instrukcje

My dumper is a free, open-source online backup tool for MySQL data that provides:

  1. Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
  2. Easier to manage output (separate files for tables, dump metadata, and so on to view and parse data)
  3. Consistency: Maintains snapshots across all threads, provides accurate control and child log positions, so forth.

 

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

Disable compression:

 --compress/-c option

This enables output file compression during backup Disabled by default; if not specified on the CLI, compression remains off.

How to configure multiple streams.

This command enables multiple streams during backups or restores:

CLI option –threads (<64)

 

How to perform a backup.

/emc/src/mydumper/mydumper-0.9.1/mydumper --user=root --password=passwd --host=ostqa-len35.datadomain.com --port=3306 --
database db1 --threads=63 --outputdir /mounts/bfs/gen0


How to perform a restore.

/emc/src/mydumper/mydumper-0.9.1/myloader --user=root --password=passwd --host=ostqa-len35.datadomain.com --port=3306 --
threads=63 --directory=/mounts/bfs/gen1


How to configure multiple streams.
CLI option: Threads enable multiple streams during backup or restore as shown above.

Best Practices - MySQL Enterprise Backup

  1. Install my dumper on each MySQL server.
  2. Disable software compression and encryption for better data deduplication.
  3. Enable multiple streams for greater throughput.
  4. Multistream recovery is not supported.
  5. Up to 63 streams per BoostFS plug-in.
     

Additional command options for boostfs mount from the Configuring and using BoostFS for Windows Guide: 

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

Additional command options for boostfs mount from Configuring and using BoostFS for both Windows and Linux Guides:

Additional Command options for boostfs mount from Configuring and using BoostFS for both Windows and Linux Guides. .png

 

Dodatkowe informacje

Produkty, których dotyczy problem

Data Domain
Właściwości artykułu
Numer artykułu: 000206564
Typ artykułu: How To
Ostatnia modyfikacja: 14 sty 2026
Wersja:  2
Znajdź odpowiedzi na swoje pytania u innych użytkowników produktów Dell
Usługi pomocy technicznej
Sprawdź, czy Twoje urządzenie jest objęte usługą pomocy technicznej.