Plug‑in for MySQL supports multiple MySQL Instances from a single MySQL Server, and each individual instance must be configured for use. The configuration options available vary, based on the OS in use on the MySQL Server and whether you use the MySQL Standard/Community option or MySQL Enterprise Backup option.
1 |
3 |
4 |
On the Configure dialog box, complete the applicable fields: |
• |
MySQL Instance Name (required): Enter the applicable name for the instance of MySQL; by default, the local host name is used. This value is used in the NetVault Backup WebUI. Quest strongly recommends that you use a generic name for the MySQL Instance instead of using a name associated with the machine on which the instance resides. This generic name improves portability and policy management across all affected clients. |
• |
MySQL Edition (required): Select the applicable option: MySQL Standard/Community or MySQL Enterprise Backup. The version that you are using determines which options are modifiable on this dialog box. |
• |
Username and Password (required): Enter the user name and password. Use an account that allows sufficient rights to read and write to the tables in the MySQL Instance’s database that is to be targeted for backup and restore, for example, an account with administrator privileges. |
IMPORTANT: NetVault Backup references Username and Password values each time it attempts to access the MySQL database for a selected instance, that is, for both backups and restores. If either of these values is changed for the MySQL Instance, it must be updated in these fields; otherwise, NetVault Backup cannot access the instance and job requests fail. |
• |
MySQL Base Directory (required): Enter the complete path to the base directory where the MySQL program files reside. |
• |
Windows-based Server: To locate the directory on Windows, query the Windows Registry for the “Location” value. |
• |
Linux-or UNIX-based Server: With a default installation of MySQL, the directory is located as follows: |
• |
MySQL Bin Directory: Enter the complete path to the directory that contains the MySQL executable files on the MySQL Server. By default, the directory is as follows: |
NOTE: The default path for the mysqlbackup utility varies depending on your environment and on whether you have customized the location. For example, with the Ubuntu 14 deb package, the utility is installed in /usr/bin/mysqlbackup by default. |
• |
Mysqldump Path: Enter the complete path and filename for the mysqldump utility, which is used during the backup and restore process. If a default installation of MySQL was performed for the target instance, the default value might appear based on the OS in use on the MySQL Server: |
• |
TCP Port (for Windows-based servers only): Each instance of MySQL requires its own port value for proper access. Default installations of MySQL use port 3306, which is displayed in this field by default. If a different port has been set up for the selected instance, enter the correct value. |
IMPORTANT: If multiple instances exist on a single MySQL Server, each is assigned its own port value, and this value must be entered in the Port Number field. This value is equivalent to what is revealed for the “port=” value, as found in the “my.ini” file for each instance. |
• |
Socket File Path (for Linux- and UNIX-based servers only): Enter the path and filename of the MySQL socket file. If a default installation of MySQL was performed, a default value is displayed in this field. By default, the socket file is located in the following directory: |
IMPORTANT: If a standard installation of MySQL was performed on the MySQL Server and the default directory was used, the Socket File path should remain at its default setting. However, if a different directory was selected during installation, enter the correct location in this field. To determine this path, issue the following command from a terminal session prompt on the MySQL Server: “ show variables like ‘socket’ ” If the correct Socket File variable is not entered, the plug-in does not perform backups and restores. |
• |
Default Character Set: The default character set is latin1. If you want to use a different character set for encoding, such as UTF-8, select it from the list. |
5 |
If you are using MySQL Standard/Community, complete the following fields: |
• |
MyISAM Backup Method: If your environment uses the MyISAM storage engine or table type, select this check box, and then select the applicable suboption. |
• |
Lock & Copy Table Files (default selection): To use the standard method of locking, flushing, and copying the table files, select this option. |
TIP: The plug-in uses the MySQL “--single-transaction” option for InnoDB tables; however, MyISAM does not support this option. This option is useful when used with transactional tables, such as InnoDB; it is not useful with other types of tables, such as MyISAM. When the plug-in completes a Full Backup, it requires a consistent state for all table types in the targeted MySQL Instance. Also, the backup job runs mysqldump for each table that is backed up, which means that all tables are not backed up at the same time. This backup method ensures that you can select specific database objects to restore, if necessary, instead of restoring the full MySQL Instance. If you prefer to use an online approach, in which tables are not locked to prevent updates, consider using a MySQL replication environment. In that environment, database users interact with the master MySQL Server, on which no tables are ever locked. The backups are taken from the slave MySQL Server. During the backup process, replication updates from the master server are paused until the backup is finished. For more information about using the plug-in with a replication setup, see Working with native MySQL replication. |
• |
Mysqldump: If the tables are subject to heavy use or loading, select this option to use the mysqldump utility instead of copying the tables. This setting might affect performance. |
• |
Enable MySQL Replication: If native MySQL Replication is enabled for this instance, select this check box. For more information, see Working with native MySQL replication. |
• |
Slave Instance: For replication-enabled instances, select this option if this instance is configured as a slave. |
• |
Master Instance: For replication-enabled instances, select this option if this instance is configured as the master. |
IMPORTANT: Do not select this option if you do not intend to configure replication; otherwise, backups fail. |
• |
Enable Point-In-Time Recovery: If you want to enable PIT backups and restores, select this check box. This setting lets you perform a recovery up to a point before, or after, data corruption occurs. To use this feature, enable the MySQL Binary Log as outlined in Enabling the Binary Log on the MySQL Server (Standard/Community option only). |
• |
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. By default, the path and file are as follows: |
• |
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. |
6 |
If you are using MySQL Enterprise Backup, complete the required Mysqlbackup Path field by entering the complete path to the directory where the mysqlbackup utility resides. |
NOTE: If you choose to use the utility instead of the .sh files, be aware that the default path for the mysqlbackup utility varies depending on your environment and on whether you have customized the location. For example, with the Ubuntu 14 deb package, the utility is installed in /usr/bin/mysqlbackup by default. |
1 |
3 |
Open the Plug‑in for MySQL node. |
4 |
Click the applicable instance, and select Configure from the context menu. |
IMPORTANT: In the Edit version, the MySQL Instance Name field is disabled. This field is for information only and displays the name of the selected instance. |
MySQL backup jobs typically include multiple storage engines, databases, and tables. Occasionally during the execution of a backup job, an unsupported storage engine is encountered or a database or table is inaccessible. If this situation is encountered, it prevents one or more items from being backed up successfully, but the remaining items selected in the backup job are backed up. A MySQL DBA must determine what action should be taken when these conditions are encountered:
1 |
In the Navigation pane, click Change Settings. |
2 |
3 |
4 |
• |
Locked Table: This issue occurs when a table selected for inclusion in the backup is locked by a client session other than the plug-in. |
• |
Manually Selected Table Unavailable: This issue occurs when an individual table is unavailable for backup for any reason, such as being dropped since the backup job was defined |
• |
Manually Selected Database Unavailable: This issue occurs when an individual database is unavailable for backup for any reason, such as being dropped since the backup job was defined |
• |
Unsupported Storage Engine: This issue occurs when a table is encountered during the backup that has a type of storage engine that the plug-in does not support. |
• |
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.” The errors are logged in the NetVault Backup binary logs and ignored on the Job Status page. A backup saveset is created that includes the items that were 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. That is, even if some of the objects were successfully backed up, the saveset is discarded. |
6 |
To save the settings, click Apply. |
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center