MySQL Processing Settings

You can specify how Veeam Agent for Linux must process a MySQL database.

Before You Begin

Before you start working on the MySQL tab, check the following:

  1. At the Guest Processing step of the wizard, the Enable application-aware processing check box is selected.
  2. At the Guest Processing step of the wizard, in the Application-Aware Processing Options window, a necessary protection group or individual computer is added to the list.

To learn more, see Guest Processing Settings.

  1. On the General tab, in the Applications section, Require successful processing or Try application processing, but ignore failures option is selected.

To learn more, see Application-Aware Processing.

  1. MySQL tables with the MyISAM storage engine must be locked to keep them in a consistent state while Veeam Agent is creating the system snapshot. To correctly process such tables, make sure that the user account you want to specify in the MySQL processing settings has the following instance-wide privileges:
  • SELECT. This privilege enables Veeam Agent to access tables' metadata and select for a lock the tables that use the MyISAM storage engine. Without this privilege, the processing of the MySQL database system will run successfully but MyISAM tables will not be locked, which may result in an inconsistent state of the backed up data.
  • LOCK TABLES. This privilege is required for locking the selected MyISAM tables. If some MyISAM tables are selected but the MySQL account does not have the LOCK TABLES privilege, the processing of the MySQL database system will fail.
  • RELOAD or FLUSH_TABLES. If some MyISAM tables are selected but the MySQL account does not have either RELOAD or FLUSH_TABLES privilege, the processing of the MySQL database system will fail.

To obtain information about the privileges that are assigned to an account, use MySQL functionality, for example, the SHOW GRANTS statement. To learn more, see MySQL documentation.

Configuring MySQL Processing

To specify how Veeam Agent for Linux must process a MySQL database system, perform the following:

  1. At the Guest Processing step of the wizard, click Applications.
  2. In the Application-Aware Processing Options window, select the necessary object, click Edit and switch to the MySQL tab.
  3. On the MySQL tab, specify a user account that Veeam Agent for Linux will use to connect to the MySQL database, from the Specify MySQL account with superuser privileges list, select a user account.

If you have not set up credentials beforehand, click the Manage accounts link or click Add on the right to add credentials.

By default, the User from password file option is selected in the list. With this option selected, Veeam Agent for Linux will connect to the MySQL database under the account specified in the password file on the Veeam Agent computer. The default location for the password file is /root/.my.cnf. For information about the password file format, see the Preparing Password File for MySQL Processing section in the Veeam Agent for Linux User Guide.

  1. If you want to specify a custom path to the password file, specify a full path in the Password file path field. Specifying relative paths is not supported.

For information on how Veeam Agent for Linux processes the MySQL database system, see the MySQL Backup section in the Veeam Agent for Linux User Guide.

MySQL Processing Settings 

Page updated 6/19/2024

Page content applies to build 12.2.0.334