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

Configure MySQL instance

You can configure MySQL protection using the following environment variables:

  • (Optional) path - Add MySQL bin path to this environment variable for running queries and connecting to databases.

  • (Optional) LIB_MYSQL_CLIENT_<port> - This environment variable is used for MySQL multi-instance deployment.

    • For Windows set this environment variable to provide the location of libmysql.dll library.

    • For Linux set this environment variable to provide the location of libmysqlclient.so library.

  • (Optional) MYSQL_SOCKFILE_<port> - This environment variable is used for MySQL multi-instance deployment. For Linux set this environment variable to provide the location of respective instances mysql.sock file.

  • (Optional) MYSQL_BACKUP_DUMP_DIRECTORY - Set this environment variable as temporary backup dump directory for non streaming backup. For example, for Linux, user can set this environment variable to required location using below command:

    echo "export MYSQL_BACKUP_DUMP_DIRECTORY=/home/custom_dump_dir_location/" > > ~/.bashrc

    For Windows, user can create new environment variable and add path of folder location as below:

    MYSQL_BACKUP_DUMP_DIRECTORY=C:\custom_dump_dir_location

    Note:

    Ensure that provided backup dump directory is empty as post backup its content will be auto-deleted.

  • (Optional) LVM SNAPSHOT_SIZE - Set this environment variable to provide the snapshot size for LVM backup for Linux operating system only. You can set environment variable of LVM Snapshot size to 500 MB using below command:

    echo "export LVM_SNAPSHOT_SIZE=500MB" >> ~/.bashrc

    Note:

    The default snapshot size is set to 500MB.

For MySQL instance configured with SSL encryption

The following environment variables on the client side, identify the certificate and key files which clients use to establish encrypted connections to the server. These variables are similar to the ssl_ca, ssl_cert, and ssl_key system variables which are used on the server side whereas the following SSL environment variables identify the client public and private key. These environment variables are required in case of backup and recovery.

  • MYSQL_OPT_SSL_CA_port - Set this environment variable to provide the path of the Certificate Authority (CA) certificate file. This option must specify the same certificate used by the server. For example:

    For Windows: MYSQL_OPT_SSL_CA_3306=C:\mysql_certificate_folder\ca.pem

    For Linux: echo "export MYSQL_OPT_SSL_CA_3306=/mysql_certificate_folder/ca.pem" >> ~/.bashrc

  • MYSQL_OPT_SSL_CERT_port - Set this environment variable to provide the path of the client public key certificate file. For example:

    For Windows: MYSQL_OPT_SSL_CERT_3306=C:\mysql_certificate_folder\client-cert.pem

    For Linux: echo "export MYSQL_OPT_SSL_CERT_3306=/mysql_certificate_folder/client-cert.pem" >> ~/.bashrc

  • MYSQL_OPT_SSL_KEY_port - Set this environment variable to provide the path of the client private key file. For example:

    For Windows: MYSQL_OPT_SSL_KEY_3306=C:\mysql_certificate_folder\client-key.pem

    For Linux: echo "export MYSQL_OPT_SSL_KEY_3306=/mysql_certificate_folder/client-key.pem" >> ~/.bashrc