To back up and restore MySQL data on an Amazon application, verify that your environment has the required software and a firewall.
Software Requirements
-
All access nodes must have the following packages:
-
Virtual Server Agent
-
MySQL Agent
-
-
Access nodes that you run backup and restore operations on must have one of the following operating systems:
-
Amazon Linux 2 on ARM64 (AWS Graviton), x86-64
-
CentOS 7.x
-
Red Hat Enterprise Linux 7.x
-
Red Hat Enterprise Linux 8.x
-
Windows 2012
-
Windows 2016
-
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.
Supported MySQL Versions
-
MySQL 8.0.x
-
MySQL 5.7.x
-
MySQL 5.6.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:
|
|
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 for the installation and continued operation of export-based protection.
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.