NetVault Plug-in for MySQL 4.4

The Dell NetVault Backup (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. Additionally, using the MySQL Standard/Community option, Plug‑in for MySQL 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 a large number of recovery scenarios. Users no longer have to worry about understanding MySQL internals before being able to implement a backup policy that prevents committed transactions from being lost during backup and understanding the proper time 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 level

•

Consolidation of multiple storage engines into a single job

By relying on Plug‑in for MySQL to implement backup policies, users can be freed to focus on more critical tasks without risking the ability to recover exactly what is needed in the unfortunate event of a failure. In addition, the IT manager’s confidence is increased by knowing that MySQL data is protected, no matter what.

•

Speeds up restores to reduce downtime – With Plug‑in for MySQL, you select what needs to be restored, 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

•

Rename of databases during restores

•

Restores to alternate MySQL Instances

•

Ensure business continuity with automatic integration of backup devices – With offsite backups being an important part of the data protection plan for any mission-critical application, Plug‑in for MySQL takes advantage of NetVault Backup’s fundamental integration with a wide range of backup devices, which includes: Dell NetVault SmartDisk, tape libraries, stand-alone tape devices, virtual tape libraries (VTLs), and shared VTLs. NetVault Backup lets you select which backup device to store the backup on. You can store the backup online in a virtual tape library and duplicate the job to physical tape libraries that are shared by multiple MySQL Instances or other proprietary databases, or used for general backup purposes.

•

Supports advanced MySQL replication techniques –As detailed in the MySQL Reference Guide, MySQL features support 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 keep track of 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 email MySQL environments are being protected and stored offsite for disaster-recovery purposes. At the same time, it frees administrators from having to be available 24x7 because less experienced MySQL administrators can initiate restores with the confidence that they are performed correctly and as quickly as possible, thereby reducing downtime and improving business continuity.