Chat now with support
지원 담당자와 채팅

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

Running the restore

With the prerequisites met, perform the following steps to restore a MySQL backup to a different machine.

1
2
On the Create Restore Job — Choose Saveset page, select Plug‑in for MySQL from the Plugin Type list.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, Job Title, server name, client name, plug-in name, saveset date and time, retirement setting, Incremental Backup or not, Archive or not, saveset size, and snapshot-based backup or not.
5
Click Next.
6
On the Create Selection Set page, select the data that you want to restore.
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 box.
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.
10
To save the settings, click Ok, and then click Next.
11
In Job Name, specify a name for the job if you do not want to use the default setting.
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 box.
13
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options.
14
Click Save or Save & Submit, whichever is applicable.
You can monitor progress on the Job Status page and view the logs on the View Logs page. For more information, see the Quest NetVault Backup Administrator’s Guide.

Working with native MySQL replication

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:

Plug‑in for MySQL supports backup and recovery of single-master replication environments.

Enabling replication support

Replication support is enabled using the Configure dialog box. For information about accessing this dialog box, see Configuring the plug-in.

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.
관련 문서