Chat now with support
Chat with Support

NetVault Plug-in for MySQL 4.4 - 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-inin a Failover Cluster environment Troubleshooting About Dell

Installing the plug-in

MySQL failover clustering environment in place – You must have a properly configured MySQL Cluster environment.
Separate NetVault Backup Server machine – The machine that is to serve as the NetVault Backup Server must be properly configured and it must exist outside the MySQL Server cluster, but have network connectivity to the nodes (hosts) within the cluster.
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.
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 strongly recommends that the network name assigned to the MySQL Clustered Service be used as the NetVault Backup Virtual Client name. When a Virtual Client is browsed, NetVault Backup will locate the node currently in control of the clustered service, and reveal 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.

Licensing the plug-in

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

Configuring the plug-in

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.
Open Plug‑in for MySQL, and select the All Instances node.
From the Actions list, select Configure.
On the Configure dialog, set the applicable configuration options.
*IMPORTANT: You must add each cluster instance in the Instances field of the Configure dialog. To add an instance, specify the MySQL Clustered Service name as VIRTUAL SERVER NAME\INSTANCE NAME.
Click OK to save the settings.

Backing up data

Backing up data using Plug‑in for MySQL that has been set up for use in a Virtual Client is relatively simple. 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.
Note that the instance name displayed in this page is actually the MySQL Clustered Service that is established as the Virtual Client during the installation process (as outlined in Creating a Virtual Client). If other MySQL Server Clustered Services are running on this node, those instances will also be displayed within the Plug‑in for MySQL node. Data from these other instances must not be selected for inclusion in the backup.
*NOTE: When you back up or restore data, make sure that you execute the process using the Virtual Client and not from one of the nodes. If you open or expand one of the nodes and drill down through the hierarchy, you will see the MySQL Clustered Service and, depending on which node is active, you might be able to drill down and select items. While the system might use this instance in maintaining log information, you should not attempt to execute any processes at this level.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating