NetVault Plug-in for MySQL 12.0

Tchater maintenant avec le support

System requirements

Before installing Plug‑in for MySQL 12.0, ensure that your system meets the requirements outlined in the Quest NetVault Backup Compatibility Guide available at https://support.quest.com/technical-documents.

Upgrade and compatibility

•

Plug‑in for MySQL 12.0 requires NetVault Backup 11.4.5 or later. For complete supported-platform information, see the Quest NetVault Backup Compatibility Guide.

•

Upgrades and new installs of MySQL: As explained in bug 68807 for MySQL, mysql_install_db ignores /etc/my.cnf in MySQL 5.6. Because MySQL 5.6 creates InnoDB statistic tables (slave_master_info, mysql/slave_relay_log_info, innodb_index_stats, innodb_table_stats, and slave_worker_info) and adds them to the installation directory (basedir) of MySQL, you might encounter a conflict with the innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend option contained in the “my.cnf” file. The file_path option places the InnoDB files one directory level higher than the basedir, which can cause the following error to is displayed in the MySQL error log:

"[Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal

data dictionary of InnoDB though the .frm file for the table exists. See

http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you

can resolve the problem."

Until you address this error, the plug-in cannot browse the main MySQL database, and the following error is displayed: "Failed to fetch row from query result: showtable status like 'innodb\_index\_stats'"

It can also cause backup jobs to stop responding.

Because this option originated from a recommended sample “my.cnf” file for an earlier version of MySQL, this issue usually occurs on upgrades or new installs that retained the earlier version of the “my.cnf” file. Quest recommends that you do not use the file_path option on new installations and that you move the ibdata files to basedir for upgrades. For assistance, contact MySQL Support. (22367)

•

Upgrades from NetVault Backup Server from 9.2: If you upgrade your NetVault Backup Server from 9.2 to 11.4.5 or later, the settings you configured for error conditions encountered by the Plug‑in for MySQL are returned to their defaults. If you modified the settings for error conditions encountered by the plug-in, Quest recommends that you reinstall the plug-in, reconfigure its settings, and re-create MySQL backup jobs.