Chat now with support
Chat with Support

NetVault Plug-in for MySQL 13.2 - User Guide

Introducing NetVault Plug-in for MySQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data
Restoring data: an overview Restoring data Using advanced restore procedures for MySQL Standard/Community
Working with native MySQL replication Using the plug-in in a Failover Cluster environment Troubleshooting

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.

Backing up replication servers

Support for backing up native MySQL Replication environments has the following limitations:

•
Slave replication servers: Backup types supported include:
•
Full
•
Incremental
•
Differential
•
Individual Database/Table Copy Only
•
Masters replication servers: Backup types supported include:
•
Individual Database/Table Copy Only

Incremental and Differential Backups on the slave server require that you enable the “--log-slave-updates” option in MySQL. This option tells the slave to log the updates performed by its SQL thread to its own Binary Log. For this option to work, the slave must also be started with the “--log-bin” option to enable the Binary Log. Normally, this option is used to chain replication servers; however, it can also be used for Binary Log backups enabling PIT Recovery of a replicated environment without the complications of purging Binary Logs on the master server before they have been applied to the slaves.

Replication configuration backups

Using the Relay Log Index Path option, you can specify the full path name to the Relay Log Index file to include it in backups. By default, the status files, “master.info” and “relay-log.info,” reside in the same location. If you use the Relay Log Index Path option and the default filenames and locations are retained, the plug-in automatically backs up and restores all these files for a slave replication server.

Restoring replication servers

You can use Full, Incremental, and Differential Backups from the MySQL Replication Slave Instance to perform disaster recovery for the MySQL Replication Master Instance. After the Master Instance has been restored, you can use the same set of backups to restore each Slave Instance to the same level as the Master Instance, and then restart Replication, or you can reinitialize the Slave Instances using other initialization methods provided in the MySQL Reference Guide.

You can use Individual Database/Table backups from both the master and the slave to restore individual databases and tables to the master. If you want to resynchronize an individual table or database on a slave, Quest recommends that you use MySQL’s Replication process for resynchronization instead of restoring to the slave and then trying to get the slave synchronized with the master.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating