Alibaba Cloud for MySQL

You can use the Commvault software to back up and restore a MySQL server instance that is hosted in the Alibaba RDS cloud.

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:

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;