NetBackup™ for Greenplum Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (11.0)
  1. Introducing NetBackup for Greenplum
    1.  
      About NetBackup for Greenplum
    2.  
      NetBackup for Greenplum terminology
    3.  
      Features of NetBackup for Greenplum
    4.  
      NetBackup for Greenplum technical overview
    5.  
      Sequence of operation for NetBackup for Greenplum backups
  2. Installing NetBackup for Greenplum
    1.  
      Verifying the operating system and platform compatibility
    2.  
      NetBackup server and client requirements
    3.  
      Greenplum server software requirements
  3. Configuring NetBackup for Greenplum
    1.  
      About NetBackup for Greenplum configuration
    2. About configuring a backup policy for Greenplum
      1.  
        Adding a NetBackup for Greenplum policy
      2.  
        About policy attributes
      3.  
        Schedule properties
      4. NetBackup for Greenplum backup types
        1.  
          Configure an application backup schedule
        2.  
          Example application backup schedule
        3.  
          Configure automatic backup schedules
        4.  
          Example automatic backup schedule
      5.  
        Add clients to a policy
      6.  
        Adding NetBackup for Greenplum scripts to the backup selections list
    3. About the backup script for NetBackup for Greenplum
      1.  
        Modify the backup script for NetBackup for Greenplum
    4.  
      Best practices for Greenplum backups
    5.  
      Configuration options for backup jobs
    6.  
      Use of the --jobs option or backup streams and the effect on NetBackup jobs and throttling options
    7.  
      The nbgpbackup_config.yaml file
    8.  
      About permissions for NetBackup for Greenplum log files
    9.  
      Perform a manual backup
  4. Using NetBackup for Greenplum
    1.  
      About Greenplum database backups
    2.  
      Perform a user-directed backup for Greenplum
    3. About restoring a Greenplum database
      1.  
        Restore a Greenplum database
      2.  
        Redirect a restore to a different Greenplum configuration
  5. Troubleshooting NetBackup for Greenplum
    1. NetBackup debug logs and reports
      1.  
        Enabling the debug logs manually
      2.  
        About the bphdb directory on the database client
      3.  
        Setting the debug level
      4.  
        About NetBackup server reports
    2.  
      Minimizing time-out failures on large database restores
    3.  
      Troubleshooting of Greenplum backups that are canceled mid-backup
  6. Appendix A. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

Best practices for Greenplum backups

For the best backup performance all jobs need to run at the same time. For a list of configuration options, see the following topic:

See Configuration options for backup jobs.

You may be able to improve performance by making the following configuration changes. Make the changes in the following order:

  • Start with the gpbackup option --jobs 1 and the nbgpbackup configuration option number_of_streams equal to the number of segments per host.

    • The value for Maximum jobs per client (host property) should be set to at least the number_of_streams.

    • The value for Maximum concurrent jobs (storage unit) should be set as follows:

      number_of_streams * number of segments per host * (number of segment hosts + 1)

  • If the performance is not adequate, then increase the buffer_size or the number_of_buffers.

  • If the performance still is not adequate, then you can try the following configuration:

    --jobs = n

    number_of_streams = n * number of segments per host

    These settings increase the number of backup jobs that gpbackup starts in parallel.

    • The Maximum jobs per client should be at least n * number_of_streams.

    • The Maximum concurrent jobs on the storage unit should be:

      n * number_of_streams * number of segments per host * (number of segment hosts + 1)

  • If the number of backup jobs is more than the value for concurrent storage unit jobs in the previous bullet, some segment hosts may perform the backup slower than others. If you increase the end_image_timeout value it may keep all segment files in a single image.

  • If you use disk storage units, you may want to disable throttling. See the following article:

    https://www.veritas.com/content/support/en_US/article.100005434