Using gpbackup and gprestore with BoostFS

    You install the BoostFS plug-in on the Greenplum Database host systems to provide access to a Data Domain system as a standard file system mount point. With direct access to a BoostFS mount point, gpbackup and gprestore can leverage the storage and network efficiencies of the DD Boost protocol for backup and recovery.

    For information about configuring BoostFS, you can download the BoostFS for Linux Configuration Guide from the Dell support site https://www.dell.com/support (requires login). After logging into the support site, you can find the guide by searching for “BoostFS for Linux Configuration Guide”. You can limit your search results by choosing to list only Manuals & Documentation as resources.

    To back up or restore with BoostFS, you include the option --backup-dir with the gpbackup or gprestore command to access the Data Domain system.

    Parent topic:

    Download the latest BoostFS RPM from the Dell support site (requires login).

    After logging into the support site, you can find the RPM by searching for “boostfs”. You can limit your search results by choosing to list only Downloads & Drivers as resources. To list the most recent RPM near the top of your search results, sort your results by descending date.

    These steps install BoostFS and create a mounted directory that accesses a Data Domain system.

    Perform the steps on all Greenplum Database hosts. The mounted directory you create must be the same on all hosts.

    1. Set up the BoostFS lockbox with the storage unit with the boostfs utility. Enter the Data Domain user password at the prompts.

      The <Storage\_Unit> is the Data Domain storage unit ID. The <Data_Domain_User> is a Data Domain user with access to the storage unit.

    2. Create the directory in the location you want to mount BoostFS.

      1. mkdir <<path_to_mount_directory>>

    3. Mount the Data Domain storage unit with the boostfs utility. Use the option -allow-others=true to allow other users to write to the BoostFS mounted file system.

    You can now run gpbackup and gprestore with the --backup-dir option to back up a database to <mounted\_directory> on the Data Domain system and restore data from the Data Domain system.

    Parent topic: Using gpbackup and gprestore with BoostFS

    Backing Up and Restoring with BoostFS

    These are required gpbackup options when backing up data to a Data Domain system with BoostFS.

    • --backup-dir - Specify the mounted Data Domain storage unit.
    • --no-compression - Deactivate compression. Data compression interferes with DD Boost data de-duplication.
    • --single-data-file - Create a single data file on each segment host. A single data file avoids a BoostFS stream limitation.

    When you use gprestore to restore a backup from a Data Domain system with BoostFS, you must specify the mounted Data Domain storage unit with the option .

    When you use the gpbackup option --single-data-file, you cannot specify the --jobs option to perform a parallel restore operation with gprestore.

    This example gpbackup command backs up the database test. The example assumes that the directory /boostfs-test is the mounted Data Domain storage unit.

      These commands drop the database test and restore the database from the backup.

      Parent topic: Using gpbackup and gprestore with BoostFS