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

Running the restore

With the prerequisites met, perform the following steps to restore a MySQL backup to a different machine.
To run the restore
1
In the Navigation pane, click Create Restore Job.
2
On the Create Restore Job - Choose Saveset page, select Plug‑in for MySQL from the Plugin Type list.
3
To filter the items displayed in the saveset table further, use the Client, Date, and Job ID lists.
The table displays the saveset name (Job Title and Saveset ID), creation date and time, and size. By default, the list is sorted alphabetically by saveset name.
4
In the saveset table, select the applicable item.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, Job Title, name of the NetVault Backup Server, name of the client from which the data was backed up, plug-in used to create the saveset, saveset creation date and time, saveset retirement setting, whether it is an Incremental Backup, whether it is an Archive, and saveset size.
5
To continue, click Next.
6
On the Create Selection Set page, select the data that you want to restore.
Display the individual MySQL Instance that was the target of the backup, navigate the selection tree until the applicable data items are located, and select them for inclusion.
7
With the applicable databases selected, click Edit Plugin Options, and then click the Restore Destination tab.
8
In the Restore Destination Details section, enter the following:
•
Username – Enter the user name established for the target instance on the new restore target (that is, what was set up in the Username field of the Configure dialog).
•
Password – Enter the password established for the target instance on the new restore target.
•
Instance Name – Enter the NetVault Backup name established for the target instance of MySQL on the new restore target.
9
If desired, select the applicable options on the Point-in-Time Recovery tab.
These options are not required to perform this form of restore. For more information, see Setting restore options.
10
Click Ok to save the settings, and then click Next.
11
In Job Name, specify a name for the job if you do not want to use the default setting.
Assign a descriptive title that lets you easily identify the job for monitoring its progress. The job name can contain alphanumeric and non-alphanumeric characters, but it cannot include non-English characters. On Linux, the names can have a maximum of 200 characters. On Windows, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
 
 
*IMPORTANT: Do not use special characters that are not supported in a file name on the target OS. For example, the characters /,\,*,@, and so on, should not be used on Windows. (This is because Plug‑in for MySQL tries to create a folder with the same name as the Job Title for restoring data temporarily.)
12
In the Target Client list, select the machine on which you want to restore the data.
 
 
*TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog.
13
Use the Schedule, Source Options, and Advanced Options lists to configure the any additional required options.
14
Click Submit to submit the job for scheduling.

Working with native MySQL replication

•
Using the plug-in in a native environment – an overview
•
Enabling replication support
•
Backing up replication servers
•
Restoring replication servers

Using the plug-in in a native environment – an overview

When you are using replication, all updates to the tables that are replicated should be performed on the master server. Otherwise, you must avoid conflicts between updates that users make to tables on the master and updates that they make to tables on the slave.
Replication offers benefits for robustness, speed, and system administration:
•
Robustness is increased with a master/slave setup. In the event of problems with the master, you can switch to the slave as a backup.
•
You can improve response time for clients by splitting the load for processing client queries between the master and slave servers. SELECT queries may be sent to the slave to reduce the query-processing load of the master. Statements that modify data should still be sent to the master so that the master and slave do not get out of synchrony. This load-balancing strategy is effective if non-updating queries dominate, which is the normal case.
•
Another benefit of using replication is that you can perform database backups using a slave server without disturbing the master. The master continues to process updates while the backup is being made.
Plug‑in for MySQL supports backup and recovery of single-master replication environments.

Enabling replication support

Replication support is enabled using the Configure dialog. For information on accessing this dialog, see Configuring the plug-in.
To enable replication
•
Enable MySQL Replication – If native MySQL Replication is enabled for this instance, select this check box.
•
Slave Instance – If the instance is configured as a Slave, select this option.
•
Master Instance – If the instance is configured as a Master, select this option.
•
Enable Point-In-Time Recovery – If you want to enable PIT backups and restores, select this check box.
•
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.
•
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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating