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 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.
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.