Chat now with support
Chat with Support

NetVault Plug-in for MySQL 11.1 - User Guide

Introducing Dell™ 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 different than the traditional installation of this plug-in. This process is completed through the creation of a Virtual Client on the NetVault Backup Server. A Virtual Client is a group of nodes within the cluster that are seen by the NetVault Backup Server as a single client that is created to back up a single clustered service, for example, a MySQL Clustered Service. During the Virtual Client creation process, the plug-in is transferred from the NetVault Backup Server to selected nodes within a cluster and installed there.

Creating a Virtual Client

As noted earlier, the Virtual Client creation process is not plug-in-specific, and you can find complete details in the Dell NetVault Backup Administrator’s Guide. However, consider the following points during the Virtual Client creation process:

Assign a name to the Virtual Client: Dell recommends that you use the network name assigned to the MySQL Clustered Service as the NetVault Backup Virtual Client name. When a Virtual Client is browsed, NetVault Backup locates the node currently in control of the clustered service, and reveals the MySQL Server instance, for example, on the NetVault Backup Selections page. With a Virtual Client name set up as the MySQL Clustered Service network name, it is easier to recognize the MySQL Server instance for which the Virtual Client was created.
Only include relevant cluster nodes in the Virtual Client: The hosts that are to be included in the creation of a Virtual Client should only be those nodes within the cluster that are relevant to the MySQL Clustered Service that is to be backed up and restored.

After the creation of the Virtual Client, the plug-in is transferred to all designated cluster nodes and installed locally. You can use the installed Plug‑in for MySQL through the Virtual Client to back up and restore shared data; you can only perform backups and restores of data established as shared within the cluster.

Licensing the plug-in

An additional difference between using Plug‑in for MySQL in a clustered environment is how it is licensed for use. The plug-in supports backup and restore of shared data only. Hence, for a MySQL Server Failover Cluster environment, only a single license would be needed — a clustered application license for the Virtual Client.

For information on the licensing process, including how to obtain the proper license keys, see the Dell NetVault Backup Installation Guide.

Configuring the plug-in

This topic assumes that a Virtual Client has already been created for use with Plug‑in for MySQL Clustered Service. Configure the actual Virtual Client from the NetVault Backup Server by performing 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, and select the All Instances node.
4
From the Actions list, select Configure.
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
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating