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 is displayed 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.
Plug‑in for MySQL supports MySQL Server Failover Clustering. Using the failover cluster network name, the plug-in is able to identify the current node that is in control of the MySQL Server Clustered Service and target it for backup.
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 about 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 Quest NetVault Backup Administrator’s Guide. |
|
• |
Before you continue, review all cluster-related information provided in the Quest NetVault 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
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. |
|
• |
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. |