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
bindirectory to the PATH user environment variable.(Linux) If the nbmariadb.conf file does not exist, create the default configuration file. For more information, See The nbmariadb.conf configuration file.
(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.soorlibmysqlclient.soand ensure that it points tolibmariadb.so.<n>andlibmysqlclient.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.soin older versions of MariaDB andlibmariadb.so.in newer versions.For example, if the MySQL client library version is 18, then the symbolic link
libmysqlclient.sopoints tolibmysqlclient.so.18.
#ln -s /<mariaDB_lib_install_path>/libpq.so.5 libpq.soNote:
Ensure that you update the MARIADB_LIB_INSTALL_PATH parameter in the
nbmariadb.conffile 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.