Protect MySQL instances and databases
Use the following procedure for subscribing a protection plan to MySQL instance or database. When you subscribe an asset to a protection plan, you assign predefined backup settings to the asset.
Note:
The user with assigned RBAC role must have access to the assets that you want to manage and also to the protection plans you want to use.
To protect MySQL instance or database:
- On the left pane, click MySQL.
- On the Instances tab or Databases tab, click the box for the instance or the database and click Add protection.
- Select a protection plan and click Next.
- You can edit one or more of the following settings:
Schedules and retention
Change when backups occur and the backup start window.
Schedules
Full: Completes instance-backup using snapshot, xtrabackup, or mysqldump and completes database-backup using mysqldump utility.
Differential Incremental: Based on previous backup timestamp, NetBackup identify the changed set of transaction logs (Binlog files) and perform its backup.
Backup options
Snapshot: This option is used to take the snapshot of an instance. For Windows - VSS snapshot method is used. For Linux - LVM snapshot method is used.
Mysqldump: It is an utility of MySQL which performs logical backup of instance as well as individual database. It is recommended in case of non-lvm deployment.
xtrabackup: It is an utility which performs physical backup of an instance using an NFS share of existing NetBackup deduplication pool (MSDP) on Linux platform only.
Ensure the following:
xtrabackup utility is compatible with the MySQL installed.
Note:
The backup with Percona xtrabackup utility is not supported on zlinux (s390x) platform.
MSDP storage is configured. For more information, see NetBackup Deduplication guide > Configuring and managing universal shares > Prerequisites to configure universal shares section.
Binary path of xtrabackup utility must be exported in the path environment variable.
For Linux, use: echo "export PATH=$PATH:<xtrabackup_installation_path>" >> ~/.bashrc
You can configure environment variable XTRABACKUP_MAX_PROCESSES. See Configure MySQL instance .
Add the database instance password in MySQL instance configuration file (.cnf), in the following way for xtrabackup utility.
[xtrabackup]
password=<password>
Maximum Jobs per client should be set to greater than 1 in primary server.
Media server and storage server should be on Linux Platform only.
SpanFS storage unit is NOT supported.
Note:
Incremental backups are not supported in case of backup of individual database.
Adjust the Database options like Job limit and Backup method.
- Click Protect.
Note:
If MySQL instance is deployed on root LVM, then Snapshot backup method is not recommended. Also, ensure that the MySQL Data directory and Binary Log (bin log)/Tablespace directory reside on the same LVM.
In case of cluster deployment of MySQL, instances can be protected of source or replica node.