MySQL: System Requirements and User Accounts

Verify that your environment meets the following system requirements for the MySQL agent.

Database Application

Application

Version

MySQL, all editions (Community, Enterprise, Standard, Classic)

5.5.x, 5.6.x, 5.7.x, 8.0.x, 8.1, 8.2, 8.3, 8.4

Percona MySQL

MariaDB

5.5.x, 10.x.x, 11.x.x

Operating System

Important

Use the most recent version of the operating system that is listed. The Commvault software fully supports the most recent version of an operating system, until the vendor ends support. More recent versions of the Commvault software might not install on operating systems that are not supported by the vendor anymore. For information about the support lifecycle of an operating system, contact the vendor.

MySQL Community Server, Percona Server, Enterprise, Standard, or Classic Edition 8.0, 8.0, 8.1, 8.2, 8.3 and 8.4

Linux

Important

  • If you have SELinux enabled on the client computer, create the SELinux policy module as a root user before performing a backup. The SELinux Development package must be installed on the client.

  • You can install a Percona server only on Linux operating systems.

Operating system

Processor architecture

Amazon Linux 2023 AMI

  • x64

  • ARM64 processor

Amazon Linux 2 AMI (HVM) - Kernel 5.1, SSD Volume Type

  • x64

Debian 11.x

  • x64

Debian 10.x

  • x64

Debian 9.x

  • x64

Red Hat Enterprise Linux 9.x

  • x64

Red Hat Enterprise Linux/Oracle Linux Enterprise/CentOS 8.x

  • x86

  • x64

Red Hat Enterprise Linux/Oracle Linux Enterprise/CentOS 7.x with glibc 2.17.x

  • x86

  • x64

Rocky Linux 9.x

  • x64

SuSE Linux 15.0 SP6

  • x64

SuSE Linux 15.0

  • x64

SuSE Linux 15 SP6

  • x64

SuSE Linux 12 Initial Release

  • x64

Ubuntu 14.04 LTS

  • x64

Ubuntu 16.04 LTS

  • x64

Ubuntu 18.04 LTS

  • x64

Ubuntu 20.04 LTS

  • x64

Ubuntu 22.04 LTS

  • x64

Note

Amazon Linux 2023 AMI supports MySQL database version 8.x on ARM64 and x86.

Windows

Operating system

Processor architecture

Microsoft Windows Server 2022 Editions

All Windows-compatible processors are supported

Microsoft Windows Server 2019 Editions

All Windows-compatible processors are supported

Microsoft Windows Server 2016 Editions

All Windows-compatible processors are supported

MySQL Community Server, Percona Server, Enterprise, Standard, or Classic Edition 5.5.x, 5.6.x, 5.7.x, 8.0, 8.1, 8.2, 8.3 and 8.4; MariaDB 5.5.x, 10.0.x, 10.6.x to 11.x

FreeBSD

Operating system

Processor architecture

FreeBSD 10.x

  • x64

FreeBSD 9.x

  • x64

HP-UX

Operating system

Processor architecture

HP-UX 11i v3 (11.31)

Itanium

Solaris

In a UNIX virtualization environment using Solaris, you can back up and restore data in both global and non-global zones.

Operating system

Processor architecture

Solaris 11.x

  • x64

  • Sparc T/M series

Solaris 10 Update 6 or equivalent

  • x64

  • Sparc T/M series

Hard Drive

Component

Space required

Software

1 GB

Job results folder

256 MB

Log folder

256 MB

Clustering

If clustering is supported by the operating system, you can install the software on a cluster. For information about supported cluster types, see Support for Cluster Configuration.

Block-Level Backups

  • Block-level backups are supported only on Linux platforms. For supported Linux kernel version details, see MySQL Block-Level Backup.

  • Block-level backups are not supported on the Network File System (NFS).

Configuring User Accounts for Backups

The MySQL agent requires a MySQL Server user account that has sufficient privileges for the software to:

  • Perform backups and restores

  • Access the MySQL Server application

  • Stop or start the MySQL Server services

The following table illustrates the necessary privileges the user account should have to perform backup and restore operations:

Operations

Privileges MySQL User Should Have

Example Query to Grant the Permission

Backup

  • SHOW DATABASES

  • SUPER

  • RELOAD

  • SELECT

  • LOCK TABLES

  • PROCESS

  • EXECUTE

  • SHOW VIEW

mysql> GRANT SHOW DATABASES, SUPER, RELOAD, SELECT, LOCK TABLES, PROCESS, EXECUTE, SHOW VIEW ON *.* to '<backup_agent_user>'@'localhost' IDENTIFIED BY '<backup_agent_password>';
mysql> GRANT SHOW DATABASES, SUPER, RELOAD, SELECT, LOCK TABLES, PROCESS, EXECUTE, SHOW VIEW ON *.* to '<backup_agent_user>'@'127.0.0.1' IDENTIFIED BY '<backup_agent_password>';
mysql> FLUSH PRIVILEGES;

It is recommended to grant all Database Administrator privileges to perform backup operations for some versions.

Example: For MySQL 5.7 and later, you should grant all Database Administrator privileges to perform backup operations.

mysql> GRANT ALL PRIVILEGES ON *.* TO '<backup_agent_user>'@'localhost' IDENTIFIED BY '<backup_agent_password>';
mysql> GRANT ALL PRIVILEGES ON *.* TO '<backup_agent_user>'@'127.0.0.1' IDENTIFIED BY '<backup_agent_password>';
mysql> FLUSH PRIVILEGES;

Restore

Full Database Administrator privileges

mysql> GRANT ALL PRIVILEGES ON *.* TO '<restore_agent_user>'@'localhost' IDENTIFIED BY '<restore_agent_password>';
mysql> GRANT ALL PRIVILEGES ON *.* TO <restore_agent_user>'@'127.0.0.1' IDENTIFIED BY '<restore_agent_password>';
mysql> FLUSH PRIVILEGES;

Initially, the user account credentials is provided during the instance configuration after the installation of the Agent. You can change the user account at the instance level.

  1. From the navigation pane, go to Protect > Databases.

    The database Overview tab appears.

  2. On the Instances tab, click the database instance for which you want to change the user account at the instance level.

    The instance Overview tab appears.

  3. In the General tile, click Edit.

    The Edit MySQL instance dialog box appears.

  4. Under the Connection details section, make the required changes.

  5. Click Update.

Software That Is Automatically Installed

File System Agent
Microsoft Visual C++ Redistributable 2017

Starting with Service Pack 18, Microsoft Visual C++ Redistributable 2017 (vcredist2017.exe) is automatically installed.

If a computer does not have the most recent Windows updates, the installation of Microsoft Visual C++ Redistributable 2017 will fail in installing Universal C Runtime. The following Windows updates must be installed to prevent the installation failure. The updates are not required on the most recent Windows operating system versions, such as Microsoft Windows 10 and Microsoft Windows Server 2016, because these versions have the Universal C Runtime already installed.

  • KB2919355

  • KB2939087

  • KB2975061

  • KB2999226

DISCLAIMER

Certain third-party software and service releases (together, "Releases") may not be supported by Commvault. You are solely responsible for ensuring Commvault’s products and services are compatible with any such Releases.

×

Loading...