Chat now with support
Chat with Support

NetVault Plug-in for MySQL 4.4 - 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-inin a Failover Cluster environment Troubleshooting About Dell

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

Prior to configuring 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, refer to 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 desired, 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 exact name of the file itself; do not include full path information or the file-name extension. For more information on enabling the Binary Log, refer to 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
Launch the MySQL Administrator application (for more information, refer to the relevant MySQL documentation).
 
 
*IMPORTANT: If you do not have the MySQL Administrator installed, you must update the configuration file on a Linux/UNIX system and then stop and restart the MySQL service to enable binary logging.
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 exact name of the file itself; do not include full path information or the file-name extension. For more information on enabling the Binary Log, refer to 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), Dell recommends that these two entities exist on separate machines.
 
Table 1. Recommended configuration
MySQL Server machine
NetVault Backup Server machine
Software installed/configuration
Software installed/configuration
•
MySQL Database software (ver 5.0 or later)
•
NetVault Backup Server/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, refer to the Dell 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.

Installing the plug-in

To install the plug-in
1
Access the NetVault Configuration Wizard or Manage Clients page.
 
 
*NOTE: You can use the configuration wizard to install the plug-in on multiple clients at the same time (provided that the selected clients are all the same type). When you select multiple clients, make sure that the plug-in binary file is compatible with the OS and platforms of the target clients. From the Manage Clients page, you can only select one client for plug-in installation.
•
To access the NetVault Configuration Wizard page:
a
In the Navigation pane, click Guided Configuration.
b
On the NetVault Configuration Wizard page, click Install Plugins.
c
On the next page, select the applicable clients.
•
To access the Manage Clients page:
a
In the Navigation pane, click Manage Clients.
b
On the Manage Clients page, select the applicable machine, and click Manage.
c
On the View Client page, click the Install Plug-in button ().
2
Click Choose Plug-in File, navigate to the location of the “.npk” installation file for the plug-in (on the installation CD or the directory to which the file was downloaded from the web site).
Based on the operating system (OS) in use, the path for this software may vary on the installation CD.
3
Select the file entitled “mys-x-x-x-x.npk” (where xxxx represents the platform and version number), and click Open.
4
Click Install Plugin to begin installation.
After the plug-in is successfully installed, a message is displayed.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating