NetBackup™ for MariaDB Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.5)

Post-installation requirements for NetBackup

After you install:

  • (Windows) Ensure that the user who performs backups and restores has administrative privileges.

  • (Linux) Ensure that the user who performs backups and restores is a super user or has superuser privileges.

  • (Linux) Symbolic link: If a symbolic link does not exist, 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 the MariaDB Administration Guide.