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

Post-installation requirements for NetBackup for MariaDB Agent

After you install

  • (Windows) Configure the NetBackup for MariaDB agent to run with administrative privileges.

  • (Windows) Add the NetBackup bin directory to the PATH user environment variable.

  • (Linux) The user of the agent is a superuser or has superuser privileges.

  • (Linux) Symbolic link: If a symbolic link does not exists, create a symbolic link libmariadb.so or libmysqlclient.so and ensure that it points to libmariadb.so.<n> and libmysqlclient.so.<n> respectively, where <n> is the MariaDB client library version. You can create the symbolic link at your chosen directory.

    The client library name is libmysqlclient.so in older versions of MariaDB and libmariadb.so. in newer versions.

    For example, if the MySQL client library version is 18, then the symbolic link libmysqlclient.so points to libmysqlclient.so.18.

    Note:

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

  • Set the privileges for the MariaDB users for backup and restore operations.

    Table: User and privileges lists the user type and the privileges for the respective user.

Table: User and privileges

User type

Privileges

Backup

LOCK TABLES, SELECT FILE, RELOAD, SUPER, UPDATE, TRIGGER, SHOW, VIEW, EXECUTE, and EVENT.

Restore

CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, DELETE, UPDATE, TRIGGER, SUPER, and CREATE VIEW.

To set the MariaDB server user privileges, run the following MariaDB commands:

GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, FILE, INDEX, ALTER, SUPER, LOCK TABLES, CREATE VIEW, SHOW VIEW, TRIGGER, CREATE ROUTINE, DELETE, EVENT, ALTER ROUTINE ON, *.* TO 'USER' @ 'localhost' IDENTIFIED BY 'PASSWORD';

For more information, refer to MariaDB Administration Guide.