NetVault Plug-in for MySQL 12.2.1

NetVault Plug-in for MySQL 12.2.1 - User Guide

Introducing NetVault Backup Plug-in for MySQL

Introducing NetVault Backup Plug‑in for MySQL

•

NetVault Backup Plug‑in for MySQL: at a Glance

•

Key benefits

•

Feature summary

•

Target audience

•

NetVault Backup Plug-in for MySQL: at a Glance

NetVault Backup Plug‑in for MySQL: at a Glance

Quest® NetVault® Backup Plug‑in for MySQL (Plug‑in for MySQL) consolidates the backup and recovery of multiple MySQL storage engines into a single job without complex scripting. If you use the MySQL Enterprise Backup option (MEB-based method), the plug-in supports hot backups of InnoDB tables during backup. If you use the MySQL Standard/Community option (mysqldump-based method), the plug-in supports warm backups of all tables while keeping data online with read-only access. Also, using the MySQL Standard/Community option, the plug-in offers improved point-in-time (PIT) functionality to perform more granular restores — which lets you restore to a precise point and reduce data loss.

Key benefits

•

Increases confidence and reduces risk while deploying MySQL: Plug‑in for MySQL eliminates the need to create complex backup scripts and is flexible enough to account for many recovery scenarios. You do not have to worry about understanding MySQL internals before implementing a backup policy that prevents the loss of committed transactions during backup and understanding when to purge the Binary Logs. This knowledge is built into the plug-in.

Plug‑in for MySQL’s flexible backup features also include:

•

Full, Incremental, and Differential Backups while data is online and accessible

•

Common user interface across multiple storage engines

•

Protection down to the table and view level

•

Consolidation of multiple storage engines into a single job

By relying on the plug-in to implement your backup policies, you can focus on more critical tasks without risking your ability to recover what is needed if a failure occurs. In addition, the IT manager’s confidence is increased by knowing that MySQL data is protected.

•

Speeds up restores to reduce downtime: You select what to restore, the backup set to restore from, and, if applicable, the time or position point to restore to; and the plug-in automatically performs the restore. Restores are faster due to minimized human interaction, and the potential for syntax errors is eliminated.

Additional Plug‑in for MySQL restore features include:

•

Full, Incremental, and both time-based and position-based PIT Restores

•

Restores of complete instances, individual databases, or individual tables and views

•

Rename of databases during restores

•

Restores to alternate MySQL Instances

•

Ensure business continuity: With offsite backups being an important part of the data-protection for business-critical applications, the plug-in takes advantage of NetVault Backup’s integration with a range of backup devices. NetVault Backup lets you select which backup device to store the backup on. You can store the backup online in a virtual tape library (VTL). You can also duplicate the job to physical tape libraries shared by multiple MySQL Instances, other proprietary databases, or even general backup files.

•

Supports advanced MySQL replication techniques –As detailed in the MySQL Reference Guide, MySQL supports one-way, asynchronous replication, in which one server acts as the master, while one or more other servers act as slaves.

In single-master replication, the master server writes updates to its Binary Logs and maintains an index of those files to track log rotation. The Binary Logs serve as a record of updates to be sent to any slave servers. When a slave connects to its master, it informs the master of the position up to which the slave read the logs at its last successful update. The slave receives any updates that have taken place since that time, and then blocks and waits for the master to notify it of new updates.

Plug‑in for MySQL gives you the confidence that your MySQL environments are protected and stored offsite for disaster-recovery purposes. At the same time, it frees administrators from having to be available 24x7. Less-experienced personnel can initiate restores, thus reducing downtime and improving business continuity.