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.4.x
Percona MySQL	5.5.x, 5.6.x, 5.7.x, 8.0.x, 8.4.x
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.x and 8.4.x

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.x and 8.4.x; 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.

From the navigation pane, go to Protect > Databases.

The database Overview tab appears.
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.
In the General tile, click Edit.

The Edit MySQL instance dialog box appears.
Under the Connection details section, make the required changes.
Click Update.

Software That Is Automatically Installed

File System Agent

The file system agent is automatically installed during the installation of this software, if it is not already installed. For file system system requirements, see the following:
The operating system must have been installed with at least the user level software option selected.

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.