Veritas NetBackup™ for MySQL Administrator's Guide

Last Published:
Product(s): NetBackup (8.2)
Platform: Linux,UNIX,Windows

Performing the MySQL backups

This topic lists the prerequisites, describes the procedure to run MySQL backups, and the information to schedule the backup from the NetBackup Administration Console.

Prerequisites

Before you run the backup, ensure that you meet the following prerequisites.

  • Ensure that versions of the MySQL agent and NetBackup are same. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.

  • (LVM users) Ensure that MySQL data and logs directory reside on the logical volumes.

  • Configure the DataStore policy from the NetBackup Administration Console.

  • Add the database parameters and library path in the nbmysql.conf file.

  • Verify that there is enough space for the snapshot in the volume group, and then set the snapshot size in nbmysql.conf file or by the command line.

    Note:

    Ensure that the snapshot size is 50% more than the instance size that you want to backup.

  • Verify that the prerequisites and the post-installation requirements are met.

    For more information, See Installing prerequisites of NetBackup for MySQL Agent.

    For more information, See Post-installation requirements for NetBackup for MySQL Agent .

To run backup

  1. Run the following command:
    nbmysql -o backup 
    -S master_server_name 
    -P policy_name 
    -s schedule_name 
    -l mysql_lib_path 
    -z snapshot_size 
    [-p database_server_port] 
    [-u database_username]
  2. (Optional) Type the password, when the nbmysql command line prompts for the password.

Note:

Ensure that the MySQL agent and NetBackup are of same version for successful backup and restore operations.

Scheduling MySQL backups from NetBackup

You can schedule MySQL backups from NetBackup Administration Console using the DataStore policy to call a backup script.

For more information, https://www.veritas.com/support/en_US/article.100041374