Chat now with support
Chat with Support

NetVault Plug-in for MySQL 12.0 - User Guide

Introducing 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

Using the plug-in in a Failover Cluster environment

•
MySQL Server Failover Clustering: an overview
•
Installing or upgrading the plug-in
•
Configuring the plug-in
•
Backing up data
•
Restoring data

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.

Important considerations
•
Unless outlined in the topics that follow, backups and restores performed with the plug-in of clustered data are the same as backups and restores performed with traditional MySQL Server data.
•
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 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

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, 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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating