System Requirements for Amazon RDS for MySQL

To back up and restore MySQL data on an Amazon application, verify that your environment has the required software and a firewall.

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

• 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:

Supported MySQL Versions

• MySQL 8.4.x

• MySQL 8.0.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!';
  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;

  - You do not require a root user account to install or operate the export-based backup and recovery solution. Use a non-root user account with sudo privileges for the installation and operations. For more information, see installation of UNIX agents by a non-root user with sudo 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.