Veritas NetBackup™ for MariaDB Administrator's Guide

Last Published:
Product(s): NetBackup (8.1.1)
  1. Introduction to NetBackup for MariaDB Agent
    1.  
      About NetBackup for MariaDB Agent
    2.  
      Features of NetBackup for MariaDB
    3.  
      The NetBackup for MariaDB Agent package
    4.  
      About the NetBackup for MariaDB Agent license
    5.  
      NetBackup for MariaDB documentation
  2. Installing the NetBackup for MariaDB Agent
    1.  
      Planning the Installation of NetBackup for MariaDB Agent
    2.  
      Verifying the operating systems and the platforms
    3.  
      Installing prerequisites for NetBackup for MariaDB Agent
    4.  
      Post-installation requirements for NetBackup for MariaDB Agent
    5.  
      Describing the NetBackup for MariaDB Agent package
    6.  
      Installing NetBackup for MariaDB Agent
    7.  
      Authenticating the password
    8.  
      Uninstalling the NetBackup for MariaDB Agent
  3. Configuring the NetBackup for MariaDB
    1.  
      The nbmariadb.conf configuration file
    2.  
      Configuring NetBackup for MariaDB backups with DataStore policies
  4. The NetBackup for MariaDB backups and restores
    1.  
      About MariaDB backups
    2.  
      Performing MariaDB backups
    3.  
      Validating the backup information
    4.  
      Querying the backups
    5.  
      Deleting backup information from the NetBackup catalog files
    6.  
      About restoring MariaDB backups
    7.  
      Performing the restores for MariaDB databases
    8.  
      Redirected restores
    9.  
      Disaster recovery
  5. Troubleshooting for NetBackup for MariaDB
    1.  
      Troubleshooting errors when using NetBackup for MariaDB
  6. Appendix A. About NetBackup for MariaDB commands and conventions
    1.  
      About NetBackup for MariaDB commands
    2.  
      About NetBackup for MariaDB command conventions
  7. Appendix B. The NetBackup for MariaDB commands
    1.  
      nbmariadb -o backup
    2.  
      nbmariadb -o restore
    3.  
      nbmariadb -o query
    4.  
      nbmariadb -o delete

Performing MariaDB backups

Prerequisites

Before you perform the backups, you must meet the following prerequisites:

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

  • (Windows) Set the NetBackup\bin directory in the environment variable.

    For example, Path =C:\Program Files\Veritas\Netbackup\bin

  • (Windows) Set the MariaDB\bin directory in user environment variable.

  • Configure the DataStore policy from the NetBackup Administration Console.

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

    Note:

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

  • (Linux) Create a symbolic link libmariadb.so and ensure that it points to the correct libmariadb.so.<n> library version.

    Ensure that you update the MARIADB_LIB_INSTALL_PATH parameter in the nbmariadb.conf file with the absolute path of the symbolic link.

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

  • Set the FLUSH and LOCK user privileges.

  • Set the following parameters in the nbmariadb.conf file:

    • DB_USER

    • DB_PORT

    • MASTER_SERVER_NAME

    • POLICY_NAME

    • SCHEDULE_NAME

    • MARIADB_LIB_INSTALL_PATH

    • (Linux) SNAPSHOT_SIZE

  • Verify the installing prerequisites and post-installation requirements.

    For more information, See Installing prerequisites for NetBackup for MariaDB Agent.

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

To run the backup

  1. Run the following command:

    nbmariadb -o backup

    -S master_server_name

    -P policy_name

    -s schedule_name

    (Linux)-z snapshot_size

    -l mariadb_library_path

    [-portnum db_port]

    [-u db_user]

  2. (Optional) When prompted, type the database password. The NetBackup then connects to the database and initiates the backup.
Scheduling MariaDB backups from the NetBackup

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

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