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

To install the plug-in, complete the steps outlined in the following sections.
Installation prerequisites
The following prerequisites must be met before you install Plug‑in for MySQL in a clustered environment:
•
MySQL failover clustering environment in place – You must have a properly configured MySQL Cluster environment.
 
 
*IMPORTANT: Support for this feature was tested on Red Hat Enterprise Linux (RHEL) v5.x using the Red Hat Clustering and Clustered Storage Suite, and employing a two-node MySQL (v5.5) cluster configuration with shared storage containing the database data files and logs. If you intend to use clustering in a different configuration, make sure that you test backups and restores before deploying it in a production 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.
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 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.
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 via 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

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.
For information on the licensing process, including how to obtain the proper license keys, refer to the Dell NetVault Backup Installation Guide.

Configuring the plug-in

This section assumes that a Virtual Client has already been created for use with Plug‑in for MySQL Clustered Service. You must configure the actual Virtual Client from the NetVault Backup Server by performing the following steps on the primary node.
To configure the plug-in
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.
2
In the selection tree, open the newly created Virtual Client.
3
Open Plug‑in for MySQL, and select the All Instances node.
4
From the Actions list, select Configure.
5
On the Configure dialog, set the applicable configuration options.
The options available are the same as those covered in Configuring the plug-in.
 
 
*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.
6
If you anticipate having to create additional backup jobs or modify existing backup jobs on the secondary node, perform the following steps:
a
Fail over the primary node to the secondary node.
b
Repeat Step 1 through Step 5.
c
Fail back to the primary node.
7
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