サポートと今すぐチャット
サポートとのチャット

NetVault Plug-in for MySQL 11.1 - 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-in in a Failover Cluster environment Troubleshooting

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.

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

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.
関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択