NetBackup™ Web UI MySQL Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.3)
  1. Overview
    1.  
      Overview of NetBackup for MySQL
  2. Managing MySQL instances and databases
    1.  
      Quick configuration checklist to protect MySQL instances and databases
    2.  
      Configure MySQL instance
    3.  
      Add MySQL instance
    4.  
      Manage credentials for an instance
    5.  
      Discover MySQL databases
    6.  
      Remove MySQL instances
    7.  
      Change the autodiscovery frequency of MySQL assets
  3. Managing MySQL environment credentials
    1.  
      Add new MySQL credentials
    2.  
      Default MySQL Administrator
    3.  
      Validate credentials of MySQL instance
    4.  
      View the credential name that is applied to an asset
    5.  
      Edit or delete a named credential
  4. Protecting MySQL instances and databases
    1.  
      Things to know before you protect MySQL instances and databases
    2.  
      Protect MySQL instances and databases
    3.  
      Customize protection settings for the MySQL assets
    4.  
      Remove protection from MySQL instances
    5.  
      View the protection status of MySQL instance
  5. Restoring MySQL instances and databases
    1.  
      Things to know before you restore the MySQL instances and databases
    2.  
      About the pre-restore check
    3.  
      Restore a MySQL instance and database
    4.  
      Restore target options
    5.  
      Pre-restore checks for MySQL
    6.  
      Steps to perform recovery after restore operation
    7.  
      Limitations
  6. Troubleshooting MySQL operations
    1.  
      Troubleshooting tips for NetBackup for MySQL
    2.  
      Error during MySQL credential addition
    3.  
      Error during the MySQL instances and databases discovery phase
    4.  
      Error during the MySQL Protection Plan Creation
    5.  
      Error while subscribing protection plan to MySQL asset
    6.  
      Error while removing MySQL asset
    7.  
      Error while backup of MySQL asset
    8.  
      Error while restoring MySQL asset image
  7. API for MySQL instances and databases
    1.  
      Using APIs to manage, protect or restore MySQL

Protect MySQL instances and databases

Use the following procedure for subscribing a protection plan to MySQL instance or database. When you subscribe an asset to a protection plan, you assign predefined backup settings to the asset.

Note:

The user with assigned RBAC role must have access to the assets that you want to manage and also to the protection plans you want to use.

To protect MySQL instance or database:

  1. On the left pane, click MySQL.
  2. On the Instances tab or Databases tab, click the box for the instance or the database and click Add protection.
  3. Select a protection plan and click Next.
  4. You can edit one or more of the following settings:

    • Schedules and retention

      Change when backups occur and the backup start window.

      Schedules

      • Full: Completes instance-backup using snapshot or mysqldump and completes database-backup using mysqldump utility.

      • Differential Incremental: Based on previous backup timestamp, NetBackup identify the changed set of transaction logs (Binlog files) and perform its backup.

    • Backup options

      • Snapshot: This option is used to take the snapshot of an instance. For Windows - VSS snapshot method is used. For Linux - LVM snapshot method is used.

      • Mysqldump: It is an utility of MySQL which performs logical backup of instance as well as individual database. It is recommended in case of non-lvm deployment.

      Note:

      Incremental backups are not supported in case of backup of individual database.

      Adjust the Database options like Job limit and Backup method.

  5. Click Protect.

    Note:

    If MySQL instance is deployed on root LVM, then Snapshot backup method is not recommended. Also, ensure that the MySQL Data directory and Binary Log (bin log)/Tablespace directory reside on the same LVM.

    In case of cluster deployment of MySQL, instances can be protected of source or replica node.