Using the plug-in in a Failover Cluster environment
MySQL Server Failover Clustering: an overview
MySQL Failover Clustering (Active/Passive) is designed to provide high-availability for an entire MySQL Server instance. For example, you can configure a MySQL Server instance on one node of a failover cluster to fail over to any other node in the cluster during a hardware failure, OS failure, or a planned upgrade.
A failover cluster is a combination of one or more nodes (hosts) with one or more shared disks. Various resources hosted by the nodes, such as IP, shared storage, and an application — MySQL in this case — can be grouped to create a Clustered Service. A Virtual Service appears on the network as if it were a single computer running an application, but provides failover from one node to a different node if the current node becomes unavailable.
|
IMPORTANT: In NetVault Backup terminology, a clustered service is accessed by a Virtual Client. The references to Virtual Client in Plug‑in for MySQL are basically references to the Clustered Service in the MySQL Server Failover Cluster environment. |
This topic points out differences between the setup and usage of the plug-in in a Failover Cluster environment vs. a traditional one. It mirrors the topics found in the instructions for the MySQL Standard/Community option.
|
• |
The following topics only offer information on MySQL-specific settings required for the use of this plug-in in a Failover Cluster environment. They do not offer instructions on how to set up NetVault Backup’s Application Cluster Support to administer backups and restores of non-MySQL Server-related data and files. This process is not plug-in-specific, and you can find complete details in the Dell NetVault Backup Administrator’s Guide. |
|
• |
Before you continue, review all cluster-related information provided in the Dell NetVault Backup Administrator’s Guide to understand how the following information works with MySQL Server Failover Cluster functionality. |
Installing or upgrading the plug-in
To install the plug-in, complete the steps outlined in the following topics.
Installation prerequisites
|
• |
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, 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. This machine must exist outside the MySQL Server cluster, but have network connectivity to the nodes (hosts) within the cluster. |