> Commvault SaaS > Databases > Amazon Web Services > Amazon RDS > Amazon RDS Using Export > Amazon Aurora > Aurora MySQL

System Requirements for Amazon Aurora MySQL

To back up and restore MySQL data on an Amazon application, verify that your environment meets the requirements.

Before Configuring Backups, Verify Backup Gateway Region and Access to the Database

Before configuring backups of the database, do the following:

Software Requirements

  • Packages that are required on access nodes:

    • Virtual Server Agent

    • MySQL Agent

  • For information on supported Amazon EC2 instances as access nodes, see Supported Amazon EC2 Instance Families.

  • Access nodes that you run backup and restore operations on must have one of the following operating systems:

Operating system

Processor architecture

Amazon Linux 2023 AMI

  • 64-bit (Arm) (recommended)

  • 64-bit (x86)

Note

Supported only from MySQL 8.0.x onwards

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

  • 64-bit (Arm) (recommended)

  • 64-bit (x86)

CentOS 9.x, 8.x

  • x64

  • Compatible processors

Oracle Linux Enterprise 9.x, 8.x

  • x64

  • Compatible processors

Red Hat Enterprise Linux (RHEL) 9.x, 8.x

  • x64

  • Compatible processors

Rocky Linux 9.x, 8.x

  • x64

  • Compatible processors

Windows 2022, 2019, 2016

  • x64

  • Compatible processors

Note

If you have network configuration enabled on the access nodes, before you deploy the Linux proxy, configure a firewall on the cloud proxy and on-premises. For more information, see Configuring a Firewall to Install the Virtual Server Agent on a Cloud VM or Instance.

Hard Drive

A minimum of 100 GB of disk space is recommended. If a staging directory is required on the access node, the actual space needed will depend on the database being backed up and the configured settings.

Network Connectivity

  • Access nodes must have Layer 3 network connectivity to the upstream MediaAgent on port 8403. If the MediaAgent and the access node are in different accounts or in different Virtual Private Clouds (VPCs), you can configure Amazon VPC peering. For information, see VPC peering basics in the AWS documentation.

  • Access nodes must have connectivity to regional and global AWS service endpoints. For information, see Requirements for Connectivity to AWS Service Endpoints.

  • Access node machines must be able to connect to the RDS instance over its database port (For example, 3306 for MySQL), unless a custom port is configured.

Note

If you have network configuration enabled on the access nodes, before you deploy the Linux proxy, configure a firewall on the cloud proxy and on-premises.

Supported MySQL Versions

  • MySQL 8.4.x

  • MySQL 8.0.x

  • MySQL 5.7.x

Note

To back up and restore data using MySQL version 8 on Windows, install Microsoft Visual C++ libraries.

User Account Requirements

The MySQL user account must have the following minimum permissions to perform cloud based backup and restore operations using dump-based solutions:

  • SELECT

  • INSERT

  • UPDATE

  • DELETE

  • CREATE

  • DROP

  • RELOAD

  • PROCESS

  • REFERENCES

  • ALTER

  • SHOW DATABASES

  • CREATE TEMPORARY TABLES

  • INDEX

  • LOCK TABLES

  • EXECUTE

  • REPLICATION

  • SLAVE

  • REPLICATION CLIENT

  • CREATE VIEW

  • SHOW VIEW

  • CREATE ROUTINE

  • ALTER ROUTINE

  • CREATE USER

  • EVENT

  • TRIGGER ON

Example:

CREATE USER 'new_master_user'@'%' IDENTIFIED BY 'StrongPassword!';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'new_master_user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

SSL and TLS Support

SSL is supported for MySQL version 5.7 and later. The supported TLS versions to create Amazon SSL encrypted MySQL instances are TLS 1.0, 1.1, and 1.2.

×

Loading...