Adding an Instance for Microsoft Azure Database for MySQL

To manage a database, you can either use an existing instance or add a new instance.

Before You Begin

Configure the permissions to access the Azure resources. Download the AzureDBBackupRole.json file and use it to apply the permissions.

Procedure

From the navigation pane, go to Protect > Databases.

The database Overview page appears.
On the top right corner of the page, from the Add instance list, select Cloud database service.

The Add Cloud DB instance dialog box appears.
Select Microsoft Azure, and then click Next.

The Configure Azure Database page appears.
Select MySQL, then click Next.

The Configure Azure database - MySQL page appears.
From the Plan section, select a backup plan, and then click Next.
From the Cloud account list, select an existing cloud account or create a new cloud account.

The cloud account is represented in Commvault as a hypervisor. For instructions to create an Azure hypervisor, see Configuring Backups for Azure Virtual Machines.
To add a new cloud account, proceed as follows:
Steps to add a new cloud account
1. Beside the Cloud account list, click +.
  
  The Add cloud account dialog box appears.
2. In the Name box, type the name for the account.
3. Enter information about the subscription:
  - For the traditional authentication method of deployment, enter the following information:
    - Subscription ID: Enter the subscription ID for the Azure account.
    - Credential: If you have already configured the credentials entity, select the credentials from the list. To define a new credential, click + beside the list. For more information, see Adding credential.
  - For the managed identity authentication method of deployment, configure the following settings:
    - Connect using managed identities for Azure resources: Move the toggle key to the right.
    - Subscription ID: Enter the subscription ID for the Azure account.
4. From the Access node list, select access nodes that have both the Virtual Server and Cloud Apps packages installed.
  
  Note
  
  If you configure this cloud account to use managed identity authentication, select only Azure access nodes that use managed identity authentication so that backups and restores will be successful. The access node must be an Azure virtual machine in the same subscription that contains the Cosmos DB account that you want to back up.
Click Next.

The Backup Content page appears.
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 for which you want to create the rules.
  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.
    Steps to add a new 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 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.
  2. In the Endpoint box, type the name of the endpoint to connect to the database instance.
  3. If SSL is enabled on the cloud, move the Use SSL options toggle key to the right, and then in the SSL CA file box, enter the SSL CA file path in the proxy computer.
    
    Note
    
    For a Windows client computer, if the instance creation with SSL certificate fails, you can select only the Use SSL options check box, and leave the SSL CA file box blank. For more information, go to "Connecting to server using the MySQL CLI over SSL" on the Microsoft documentation website.
Click Next.

Tip

For Azure Single servers, enter the user name in the syntax username@hostname.
To filter the content that is backed up, click Edit, select or clear the tables, and then click Save.

The Summary page appears.
Review the summary, and then click Finish.

Results

The new instance contains a default database group. The default database group includes all the data in the Microsoft Azure Database for MySQL database. You cannot delete the default database group.