Chat now with support
Chat with Support

NetVault Plug-in for MySQL 12.2 - User Guide

Introducing NetVault Backup Plug-in for MySQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data Working with native MySQL replication Using the plug-in in a Failover Cluster environment Troubleshooting

Installing the software

Installation of the plug-in for a clustered environment is the same as the traditional installation of this plug-in. For more information, see Installing and removing the plug-in.

Configuring the plug-in

Perform the following steps on the primary node.

1
In the Navigation pane of the NetVault Backup WebUI on the NetVault Backup Server, click Create Backup Job, and click Create New next to the Selections list.
3
Open Plug‑in for MySQL.
4
Click the All Instances node, and select Configure from the context menu.
5
On the Configure dialog box, set the applicable configuration options.
IMPORTANT: Add each cluster instance in the Instances field of the Configure dialog box. To add an instance, specify the MySQL Clustered Service name as VIRTUAL SERVER NAME\INSTANCE NAME.
b

Backing up data

Open the Plug‑in for MySQL node on the NetVault Backup Selections page, and select the MySQL Server Virtual Server, or the items contained within, for inclusion in the backup.

The instance name displayed in this page is actually the MySQL Clustered Service. If other MySQL Server Clustered Services are running on this node, those instances are also displayed within the Plug‑in for MySQL node. Data from these other instances must not be selected for inclusion in the backup.

Restoring data

All options available for a restore with Plug‑in for MySQL are also available for Failover Clustering environments, and data selection is performed in the same way. The only difference is that restorable backups are displayed on the Create Restore Job — Choose Saveset page under the name of the primary node that was active during each backup. When a restore job is initiated, NetVault Backup communicates with all member Clients to determine which machine is in control of the failover cluster, and then targets this machine for the restore.

All the instructions offered for performing a restore can be used in the recovery of a failover cluster. For more information, see the various topics in Restoring Data. To restore a failover cluster to a standalone NetVault Backup Client, use the instructions provided in Recovering to an Alternate MySQL Server.

Related Documents