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

Removing the plug-in

On the Manage Clients page, select the applicable client, and click Manage.
In the Installed Software table on the View Client page, select Plug‑in for MySQL, and click the Remove Plugin button ().
In the Confirm dialog, click Remove.

Removing a specific MySQL Instance

In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
Open Plug‑in for MySQL, and select the applicable instance.
From the Actions list, select Remove Server.

Configuring the plug-in

Configuring default settings

In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
From the Actions list, select Add New Server.
On the Configure dialog, complete the applicable fields:
MySQL Instance Name (required) – Enter the applicable name for the instance of MySQL (by default, the local host name is used). This value will be used in the NetVault Backup WebUI.
MySQL Edition (required) – Select the applicable option: MySQL Standard/Community or MySQL Enterprise Backup. The version that you are using determines which options are modifiable on this dialog.
Username and Password (required) – Enter the user name and password that allows sufficient rights to read and write to the tables in the MySQL Instance’s database that is to be targeted for backup and restore (for example, an account with administrator privileges).
*IMPORTANT: NetVault Backup references Username and Password values each time it attempts to access the MySQL database for a selected instance (that is, for both backups and restores). If either of these values is changed for the MySQL Instance, it must be updated in these fields; otherwise, NetVault Backup will be unable to access the instance and job requests will fail.
MySQL Base Directory (required) – Enter the complete path to the base directory where the MySQL program files reside.
Windows-based Server – To locate the directory on Windows, query the Windows Registry for the “Location” value.
Linux/UNIX-based Server – With a default installation of MySQL, the directory is located as follows:
MySQL Bin Directory – Enter the complete path to the directory that contains the MySQL executable files on the MySQL Server. By default, the directory is as follows:
Mysqldump Path – Enter the complete path and file name for the mysqldump utility, which is used during the backup and restore process. If a default installation of MySQL was performed for the target instance, the default value might appear based on the OS in use on the MySQL Server:
TCP Port (for Windows-based Servers only) – Each instance of MySQL requires its own port value for proper access. Default installations of MySQL use port 3306, which appears in this field by default. If a different port has been set up for the selected instance, enter the correct value.
*IMPORTANT: If multiple instances exist on a single MySQL Server, each is assigned its own port value, and this value must be entered in the Port Number field.This value is equivalent to what is revealed for the “port=” value, as found in the “my.ini” file for each instance.
Socket File Path (for Linux/UNIX-based Servers only) – Enter the path and file name of the MySQL socket file. If a default installation of MySQL was performed, a default value will appear in this field. By default, the socket file is located in the following directory:
*IMPORTANT: If a standard installation of MySQL was performed on the MySQL Server and the default directory was used, the Socket File path should remain at its default setting. However, if a different directory was selected during installation, you must enter the correct location in this field. To determine this path, issue the following command from a terminal session prompt on the MySQL server:

“ show variables like ‘socket’ ”

If the correct Socket File variable is not entered, the plug-in will not perform backups and restores.
Default Character Set – The default character set is latin1. If you want to use a different character set for encoding (such as UTF-8), select it from the list.
If you are using MySQL Standard/Community, complete the following fields:
MyISAM Backup Method – If your environment uses the MyISAM storage engine or table type, select this check box, and then select the applicable suboption.
Lock & Copy Table Files (default selection) – Select this option to use the standard method of locking, flushing, and copying the table files.
Mysqldump – If the tables are subject to heavy use or loading, select this option to use the mysqldump utility instead of copying the tables. Be aware that this might impact performance.
Enable MySQL Replication – If native MySQL Replication is enabled for this instance, select this check box. For more information, see Working with native MySQL replication.
Slave Instance – For replication-enabled instances, select this option if this instance is configured as a slave.
Master Instance – For replication-enabled instances, select this option if this instance is configured as the master.
*IMPORTANT: Do not select this option if you do not intend to configure replication; otherwise, backups will fail.
Enable Point-In-Time Recovery – If you want to enable PIT backups and restores, select this check box. This lets you perform a recovery up to a point prior to, or after, data corruption occurs. To use this feature, you must enable the MySQL Binary Log as outlined in Enabling the Binary Log on the MySQL Server (Standard/Community option only).
Binary Log Index Path – If you selected the Enable Point in Time Recovery check box, use this field to specify the complete path to the Binary Log Index file. By default, the path and file are as follows:
Relay Log Index Path – If you are configuring a Slave Instance, enter the complete path to the Relay Log Index file to include it in backups.
If you are using MySQL Enterprise Backup, complete the required Mysqlbackup Path field by entering the complete path to the directory where the mysqlbackup utility resides.
Click OK to save the settings.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating