System Requirements for Amazon RDS for 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:

Verify that the AWS backup gateway is deployed in the same region and VPC as the AWS database.
Verify that the AWS backup gateway can access the AWS databases. For more information, go to Automatically connecting an EC2 instance and an RDS database on the Amazon RDS website.
See the following:
- System Requirements for AWS Backup Gateways
- For instructions to create an AWS backup gateway, which is part of configuring backups, see the "Configuring Backups" page for the database, under AWS Cloud Databases. For example, Configuring Backups for Amazon DocumentDB Instances.

Software Requirements

Packages that are required on access nodes:
- Virtual Server Agent
- MySQL Agent
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 8.x, 7.x	x64 Compatible processors
Oracle Linux Enterprise 9.x, 8.x, 7.x	x64 Compatible processors
Red Hat Enterprise Linux 9.x, 8.x, 7.x	x64 Compatible processors
Rocky 9.x, 8.x	x64 Compatible processors
Windows 2022, 2019, 2016, 2012	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.

Supported MySQL Versions

MySQL 8.4.x
MySQL 8.0.x
MySQL 5.7.x

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!';<br/>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;<br/>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.