Azure Database for MySQL

You need the following components when you want to perform MySQL database backup operations on your Azure database:

An Azure MySQL instance.
A Commvault proxy server that resides in the Azure cloud and has the MySQL Agent.
A Commvault Windows client that has the Virtualization Agent.
An optional on-premises MediaAgent.

Configure one of the following Azure resource deployment models:

When setting up the resource deployment model, assign contributor role to the virtual machine or access node.

If you want to restrict access, you can assign a customized role (CvMySQLRole.json).

Data Flow

You can use the Commvault software to back up and restore MySQL data on the Azure Database for MySQL Single Servers and Azure Database for MySQL Flexible Servers.

When you perform a backup operation, the Commvault software invokes the MySQL mysqldump client utility to perform the backup operation.

When you perform a restore operation, the Commvault software restores the dump file to the specified database on the destination client.

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;