NetBackup™ for MariaDB Administrator's Guide

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

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 the logical volume.

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

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

  • Configure the DataStore policy.

  • (LVM) Verify that there is enough space for the snapshot in the volume group, and then set the snapshot size on 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.

  • Set the FLUSH and LOCK user privileges.

Run a backup from the command line

To run the backup from the command line

  1. Run the following command:

    nbmariadb -o backup

    -S primary_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

  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 using the DataStore policy type to call a backup script.

See Create a DataStore policy for MariaDB backups.