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

Target audience

While advanced MySQL database administrator (DBA) skills are not required to create and run routine backup operations, they are required for defining an efficient backup-and-recovery strategy and performing advanced recovery scenarios.

Recommended additional reading

Quest recommends that you have the following documentation available for reference while setting up and using this plug-in.

•
MySQL <X> Reference Guide (where <X> refers to the version of MySQL installed on the MySQL Server):
•
MySQL 5.7: http://dev.mysql.com/doc/refman/5.7/en/index.html
•
MySQL 5.6: http://dev.mysql.com/doc/refman/5.6/en/index.html
•
MySQL 5.5: http://dev.mysql.com/doc/refman/5.5/en/index.html
•
NetVault Backup documentation:
•
Quest NetVault Backup Installation Guide: This guide provides details on installing the NetVault Backup Server and Client software.
•
Quest NetVault Backup Administrator’s Guide: This guide explains how to use NetVault Backup and describes the functionality common to all plug-ins.
•
Quest NetVault Backup CLI Reference Guide: This guide provides a description of the command-line utilities.
You can download these guides from https://support.quest.com/technical-documents.

 

Installing and removing the plug-in

•
Installation prerequisites
•
Reviewing the recommended configuration
•
Installing or upgrading the plug-in
•
Removing the plug-in
•
Removing a specific MySQL Instance

Installation prerequisites

Before installing Plug‑in for MySQL, verify that the following software is installed and properly configured on the machine that is to serve as the MySQL Server:

•
NetVault Backup Server and Client software: At a minimum, the NetVault Backup Client must be installed on the machine configured as the MySQL Server.
•
MySQL Database software
•
Enable the Binary Log on the MySQL Server (MySQL Standard/Community option only): This setting allows for support of point-in-time (PIT) backups and restores of the MySQL Server. For more information, see Enabling the Binary Log on the MySQL Server (Standard/Community option only).
•
Proper version of the MySQL Database Client package: The plug-in interacts with components installed with the MySQL Client package and lets you access more functionality with the plug-in. The version of the components installed with this package must be compatible with the installed version of MySQL. Primarily, these two MySQL components should be installed and their version verified:
•
mysqldump: This utility lets you perform backups and restores of multiple types of MySQL storage engines. Verify that the version of this component is compatible with the current version of MySQL, and that it is not the version provided with an earlier version of Plug‑in for MySQL.
•
mysqlbinlog: This utility lets you use PIT backups and restores. Ensure that the proper version of this component is available for use with the installed version of MySQL.
•
MySQL Enterprise Backup: If you want to use the MySQL Enterprise Backup option (MEB-based method) in a standalone (noncluster) environment, your environment must meet the following requirements:
•
For Windows, Linux, and UNIX environments, your MySQL Server must use version 5.6 or 5.7.
•
Version 3.12 or 4.0 of the MySQL Enterprise Backup product must be installed. MySQL Enterprise Backup is available with MySQL Enterprise Edition and with select Commercial Editions. For installation instructions, see the applicable documentation for your MySQL Enterprise Edition product.
•
You can use version 3.12 of the MEB option with MySQL 5.6 on Windows Server 2008 R2, Windows Server 2012 R2, Windows Server 2016, and Red Hat Enterprise Linux (RHEL) 7.x.
•
You can use version 4.0 of the MEB option with MySQL 5.7 on Windows Server 2008 R2, Windows 2012 R2, Windows Server 2016, and RHEL 6.x and 7.x.
 
* 
IMPORTANT: If you use Windows Server 2008 R2 or Windows Server 2016, use Windows Computer Management to add Local account and member of Administrators group to the machine's local Administrators group.

If you use RHEL 6.x, verify that the libraries are up-to-date before continuing.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating