Configure Azure MySQL Server Database Backups Using Commvault Cloud Infrastructure

You can use a guided setup to configure database backups for Azure MySQL databases that can be accessed via a public endpoint. This method uses the Commvault Cloud infrastructure, so you do not need to configure your own backup gateways.

Important

Commvault Cloud infrastructure backups for Azure databases are supported only for certain regions. If you do not see your region when configuring backups for your Azure Paas database, contact your Commvault Cloud customer support manager (CSM).
The Commvault Cloud software supports Azure for public clouds only. Sovereign clouds, such as in Germany or China, are not supported. For more information, go to Azure Regions Decision Guide on the Microsoft documentation website.

Before You Begin

You must have credentials to log on to the Azure portal.

Procedure

From the Command Center navigation pane, go to Service Catalog.

The Service Catalog page appears.
On the Database tile, click Configure.

The Select a Database Application dialog box appears.
Click Microsoft Azure.

The Configure Azure database page appears.
Select MySQL, and click Next.

The Select backup method page appears.
Select Backup Direct to Cloud, and then click Next.

The Region page appears.
Select the region where the Azure database is located, and then click Next.

The Configure Cloud Storage For Added Protection page appears.
For Storage location, select an existing cloud storage location or create a new storage location for the primary copy.

If you create a new storage location, click the refresh button and select the location.
To store a secondary copy, move the Secondary copy toggle key to the right, and then select the location for the secondary copy.
Click Next.

The Select a Plan page appears.
Select an existing backup plan or create a new backup plan.

If you create a new backup plan, click the refresh button and select the backup plan.
Click Next.

The Cloud Account page appears.
Select an existing cloud account or create a new cloud account.

If you create a new cloud account, click the + button and select the cloud account.
Click Next.

The Cloud Database Instance Details page appears.
In the Instance name box, enter a name for the instance.
Under the Connection details, enter the following details:
- From the Credential list, select a saved credential or add a new credential.
  Steps to add credential
  1. Click the + icon beside the Credentials list.
    
    The Add Credential dialog box appears.
  2. From Account type list, select a database account.
  3. From the Database type, select a database.
  4. From the Credential Vault list, select a credential vault to store credentials for different types of accounts.
  5. In the Credential name box, enter a name for the credential.
  6. Under the Azure AD/AWS IAM Authentication section, enter the following details:
    - In the Username box, enter the user name to access the Azure Database for MySQL application.
    - In the Password box, enter the password to access the Azure Database for MySQL application.
    Note
    
    If you move the Azure AD/AWS IAM Authentication toggle to right, you only need to enter the user name detail.
  7. The SSL certificate toggle key is unselected by default. By moving the this toggle key to right, you can perform the following actions:
    - In the SSL CA file field, provide the SSL CA file path on the proxy computer.
    - In the SSL Cert file field, provide the SSL certificate file path on the proxy computer.
    - In the SSL Key file field, provide the SSL key file path on the proxy computer.
  8. In the Description box, enter the details of the credential.
  9. Click Save.
- Maintenance DB: Enter the name of the system database.
- Endpoint: Enter the endpoint that you use to connect to the database.
  
  The endpoint includes the DNS name or the IP address, a colon, and the port number. For MySQL example, you can enter db.example.eu-central-1.abc.Azure.com:5432.
Click Next.

The Backup Content page appears and displays the content to be backed up.
To configure the rule criteria for automatic discovery of instances to back up, do the following:
1. Move the Rule based discovery toggle key to right.
2. From the Access node list, select an access node which runs the discovery job.
  
  Note
  
  All the access nodes must have VSA package installed for MySQL and cloud applications.
3. Under Content section, from the Add list, you can use the following two ways to add the instances:
  - Rule group
  - Cloud DB instances
4. If you select Rule group, do the following:
  1. Click Rule group.
    
    The Add rule group dialog box appears.
  2. From Match rule section, you can select either all or any depending as per requirement.
    - All: Each rule defined by the user must be satisfied for a database instance to be discovered.
    - Any: If any database instance satisfies at least one of the defined rules, it is discovered.
  3. Click Add.
  4. Click Save.
5. If you select Cloud DB instances, do the following:
  1. Click Cloud DB instances.
    
    The Add Cloud DB instances dialog box appears.
  2. From the instance list, select the instances you want add.
  3. Click Save.
6. From the Credential list, select an existing credential or add a new credential. The selected credential is used for all the added instances.
7. Click Next.
To manually select an instance to back up, move the Rule based discovery toggle key to the left, and do the following:
1. From the Instance name list, select an instance.
2. Under the Connection details section, enter the following details:
  1. From the Credential list, select a saved credential or add a new credential.
  2. In the Maintenance DB box, type the name of the system database that is used as the maintenance database.
  3. In the Endpoint box, type the name of the endpoint to connect to the database instance.
Click Next.

The system creates the instance and displays a summary page that shows the instance configuration.
Click Configure Another Region, or click Finish to go to the instance page.