Performing MariaDB backups
Before you perform the backups, you must meet the following prerequisites:
Ensure that versions of the MariaDB agent and NetBackup are same. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.
(LVM users) Ensure that the MariaDB data directory and logs directory reside on the logical volume.
(Windows) Set the
NetBackup\bindirectory in the environment variable.For example,
Path =C:\Program Files\Veritas\Netbackup\bin(Windows) Set the
MariaDB\bindirectory in user environment variable.Configure the DataStore policy from the .
(LVM) Verify that there is enough space for the snapshot in the volume group, and then set the snapshot size in
nbmariadb.conffile 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.soand ensure that it points to the correctlibmariadb.so.<n>library version.Ensure that you update the MARIADB_LIB_INSTALL_PATH parameter in the
nbmariadb.conffile 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.conffile: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
- 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]
(Linux)-b backup_type
- (Optional) When prompted, type the database password. The NetBackup then connects to the database and initiates the backup.
You can schedule the MariaDB backups from the using the DataStore policy to call a backup script.
For more information, https://www.veritas.com/support/en_US/article.100041621