Chat now with support
Chat with Support

NetVault Plug-in for MySQL 12.2 - 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

Enabling the Binary Log on the MySQL Server (Standard/Community option only)

Before you configure support for PIT backups and restores with the MySQL Standard/Community option, you must enable the MySQL Binary Log.

Enabling the log on a Linux- or UNIX-based MySQL Server

1
Access the MySQL installation directory, and locate the MySQL configuration file, for example, “my.cnf”.
The name and location of the file are contingent on your MySQL configuration. For more information, see your MySQL documentation.
2
Using a text editor, open the file, and locate the “[mysqld]” section.
3
To use the default MySQL directory to house the MySQL Binary Log, add the following entry:
log-bin
 
* 
IMPORTANT: If wanted, the “log-bin” entry added to the my.cnf file can be set up using the following syntax to specify a different file to house the Binary Log:

log-bin=<NameOfDestinationFile>

When you specify the name of the destination file for the Binary Log, use only the name of the file itself; do not include full path information or the filename extension. For more information about enabling the Binary Log, see the MySQL Reference Guide before continuing with installation of the plug-in.
4
To enable the changes, restart the MySQL Server.

Enabling the log on a Windows-based MySQL Server

1
Start the MySQL Administrator application; for more information, see the relevant MySQL documentation.
 
* 
IMPORTANT: If you do not have the MySQL Administrator installed, update the configuration file on a Linux or UNIX system and then stop and restart the MySQL service to enable the Binary Log.
2
In the MySQL Administrator window, click Startup Variables in the left pane.
3
In the right pane, select the Log Files tab.
4
Select the Binary Logfile Name check box, and either enter a unique name for the file, or leave the field blank to use the default value of log-bin.
 
* 
IMPORTANT: When you specify the name of the destination file for the Binary Log, use only the name of the file itself; do not include full path information or the filename extension. For more information about enabling the Binary Log, see the MySQL Reference Guide before continuing with installation of the plug-in.
5
Exit the MySQL Administrator application.
6
To enable the changes, restart the MySQL Server.

Reviewing the recommended configuration

While you can set up a single machine as both the NetVault Backup Server and the MySQL Server, that is, all software installation and configuration requirements are performed on a single machine, Quest recommends that these two entities exist on separate machines.

 
Table 1. Recommended configuration

MySQL Server machine
NetVault Backup Server machine

Software installed and configuration

Software installed and configuration

•
MySQL Database software (5.5 or later)
•
NetVault Backup Server and Client software
•
Plug‑in for MySQL
•
Binary Log enabled (MySQL Standard/Community option only)
•
mysqldump/mysqlbinlog utilities — compatible with the version of MySQL installed
•
mysqlbackup utility — MySQL Enterprise Backup option only
•
NetVault Backup Server software
•
MySQL Server added as a NetVault Backup Client — for details on adding a Client machine to the NetVault Backup Server, see the Quest NetVault Backup Administrator’s Guide.
 
* 
IMPORTANT: Sample images and procedures throughout this guide assume that you are using this two-machine environment and that configuration requirements have been met.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating