Chatee ahora con Soporte
Chat con el soporte

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

Performing a backup

1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In Job Name, specify a name for the job.
3
Click Create New next to the Selections list.
4
On the NetVault Backup Selections page, enter a name for the set in the Backup Selection Set box, and then open the NetVault Backup Client on which the plug-in is installed.
5
In the list of plug-ins, open Plug‑in for MySQL to display the MySQL Servers.
For a more granular selection, open the All Databases node to display the individual databases. In addition, you can open each individual database to display its individual tables, which can be selected as desired for inclusion in a backup job.
*IMPORTANT: If you select a granular set of data for backup with the MySQL Standard/Community option, you must select Individual Database/Table Copy Only as the backup type on the Backup Options tab. If any other form of backup is selected (that is, Full, Incremental, or Differential Backup), granular selections will be ignored, and the entire database will be backed up.For MySQL 5.0.x and later, stored procedures, functions, and triggers are automatically backed up with Full and Individual Database/Table Copy Only backups for the MySQL Standard/Community option.

For MySQL 5.0.x and later, the “information_schema” database will be displayed in the selection tree but it will not available for selection. This is because all the data contained in this database is generated dynamically, and does not exist in any permanent sense. Therefore, the plug-in automatically excludes the information_schema database from all backups.
7
Click Save to save the set.
1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In the Selections list, select an existing Backup Selection Set.

Setting backup options

1
Click Create New next to the Plugin Options list.
*IMPORTANT: If you specified the target instance of MySQL as a “Replication Master Instance” (that is, the Enable MySQL Replication and Master Instance options were selected in the Configure dialog for this instance), the Full, Incremental, and Differential forms of backup will be unavailable for selection. For more information, see Working with native MySQL replication.
Full Backup for All Databases (default selection) – To perform a complete backup of every database included in the current MySQL Instance, select this option.
Incremental Backup – To back up only the transaction logs that were generated since the last Full or Incremental Backup, select this option.
Differential Backup – To back up all the transaction logs that have been generated since the last Full or Incremental Backup, select this option. Each time a subsequent Differential is performed, it will contain all Binary Log files generated since the original Full was performed. After the backup is finished, the Binary Logs will be kept on the MySQL Instance.
Individual Database/Table Copy Only – To create a special-purpose copy of a MySQL environment that will not affect the overall backup and restore procedures for the database (for example, creating a test environment), select this option. When used, these copy backups will not affect the sequence established by a Full and Incremental/Differential MySQL backup scenario (that is, these backups have no affect on Binary Log records). This form of backup is independent of what should be established as a normal sequence of backups through the use of a Full and Incremental/Differential MySQL backup scenario. In addition, a copy backup cannot be used as a replacement for a Full Backup.
Lock All Tables with Read Access… – If you selected Full Backup and you want to prevent the loss of transactions by locking all the databases in the instance that currently have read-only access, select this check box. When this option is selected, users will be unable to insert, update, or delete data across the entire instance while the Full Backup is in progress. When this option is cleared, Plug‑in for MySQL locks each table during the backup process only when the table is being backed up; therefore, if the instance contains tables that are related, Dell strongly recommends that you select this option to ensure that all tables are locked during the process.
Purge Binary Logs… – This option is selected by default if Enable MySQL Replication is not selected and Enable Point-In-Time Recovery is selected. Dell recommends that you use this option, but you can decide how much control you want over the binary logs.
Complete with Warnings - Saveset Retained – The job returns a status of “Backup Completed with warnings” and a backup saveset is created that includes the items that were successfully backed up.
Complete without Warnings - Saveset Retained – The job completes and returns a status of “Backup Completed” and a backup saveset is created that includes the items that were successfully backed up.
Fail - Saveset Retained – The job returns a status of “Backup Failed.” However, a backup saveset is generated that includes the items that were successfully backed up.
Fail - No Saveset Retained – The job returns a status of “Backup Failed” and no saveset of backed up objects is kept.
4
In the Mysqldump options box, list the command options that you want the mysqldump utility to use for the job.
These options are added to the mysqldump command first, followed by the options generated internally by the plug-in. Because of this, an option that you enter here that contradicts one generated internally will be overridden by the one generated by the plug-in.
Errors detected by mysqldump that cause the job to fail will be embedded in the error log message in the job log.
For information on the options supported by your version of mysqldump, refer to the applicable MySQL documentation.
*WARNING: Be aware that you should not use the --routines (-R) or --triggers option with this feature. (Using these options interferes with backups of database tables, and while backups will succeed, restores might fail.) If there are stored procedures and triggers that need to be backed up for a database, the plug-in will generate mysqldump commands internally with the --routines and ‑‑triggers options.
5
Click Save to save the set.
6
In the Create New Set dialog, specify a name for the set, and click Save.
In the Plugin Options list, select the existing Backup Options Set that you want to use.

Setting backup options for MySQL Enterprise Backup

1
Click Create New next to the Plugin Options list.
Full Backup (default selection) – To back up every database and table selected in the current MySQL Instance, select this option.
Incremental Backup – To back up only the data (for InnoDB tables) or complete tables (for non-InnoDB tables) changed since the last Full or Incremental Backup, select this option.
3
Click Save to save the set.
4
In the Create New Set dialog, specify a name for the set, and click Save.
In the Plugin Options list, select the existing Backup Options Set that you want to use.

Finalizing and submitting the job

1
Use the Schedule, Target Storage, and Advanced Options lists to configure any additional required options.
2
Click Save or Save & Submit, whichever is applicable.
*TIP: To run a job that you have already created and saved, select Manage Job Definitions in the Navigation pane, select the applicable job, and click Run Now.
Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación