6.7.1 General Requirements

MySQL Enterprise Backup is a MySQL Enterprise Feature that is separate from MySQL Workbench. For more information about its functionality, see the MySQL Enterprise Backup documentation at http://dev.mysql.com/doc/mysql-enterprise-backup/en. MySQL Workbench provides an interface to MySQL Enterprise Backup, as described in the following documentation. In addition to having MySQL Enterprise Backup installed on your host, the following general requirements also apply:

  • A recent version of MySQL Enterprise Backup. The MySQL Enterprise Backup support policy is to support the current GA version of MySQL Enterprise Backup, and the major version before that. This dictates the minimum MySQL Enterprise Backup version required by MySQL Workbench, which is the major version before the current GA release.

  • Managing both local and remote MySQL instances is available on Linux and macOS, and managing local MySQL instances is available on Microsoft Windows. Remote management is configured using SSH Remote Management.

  • A MySQL connection with a root user.

  • The MySQL server configuration file path must be set and correct for the MySQL connection.

  • The user running MySQL Workbench must be a sudo user (Linux and macOS) that is able to execute the MySQL Enterprise Backup binary.

  • Additionally, the sudo user must keep the HOME environment variable when executing system commands, which means adding the following to /etc/sudoers:

    env_keep +="HOME"

You can set the following prerequisites by clicking Settings:

  • A path to the MySQL Enterprise Backup executable. MySQL Enterprise Backup is available with eDelivery or My Oracle Support (MOS). MySQL Workbench attempts to locate the MySQL Enterprise Backup executable, so check the path and adjust it accordingly.

  • The path to the Backup Home Directory, where backup profiles and data is stored. This can be created from within Workbench from Settings.

  • The MySQL account for the Backup Process. The available actions depends on the current state of this set up, with options including:

    • Create MEB Account: Available if a backup user does not already exist.

    • Change Password: Available if a backup user does exist.

    • Fix Grants for MEB: Available if the user's privileges are invalid, which alters the user by adding the RELOAD, SUPER, and REPLICATION CLIENT ON *.* privileges.

Uninstalling Workbench notes

  • Uninstalling Workbench does not remove the associated MySQL Enterprise Backup backup tasks. To stop the scheduled backups, edit the related "Task Scheduler" entries on Windows, or remove the associated cron jobs on Linux and macOS.

  • Uninstalling Workbench does not remove the MySQL Enterprise Backup master related configuration file, the configuration files generated for each defined profile, nor the MySQL backups.

The following figure shows an example of the prerequisites.

Figure 6.26 Workbench: MySQL Enterprise Backup Settings

Content is described in the surrounding text.

If any of the requirements are not met, then an error will be generated when attempting to use MySQL Enterprise Backup features.

User Comments
Sign Up Login You must be logged in to post a comment.