Adding an Instance for Google Cloud SQL for MySQL

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

Before You Begin

• To discover database instances, enable the Cloud SQL Admin and Cloud Resource Manager APIs in the project where service account is hosted.

• Your Google account must contain the following permissions to access the Google resources:

  Role	Title	Description	Permissions	Lowest Resource
  roles/cloudsql.viewer	Cloud SQL Viewer	Provides read-only access of Cloud SQL resource.	cloudsql.backupRuns.get cloudsql.backupRuns.list cloudsql.databases.get cloudsql.databases.list cloudsql.instances.export cloudsql.instances.get cloudsql.instances.list cloudsql.instances.listServerCas cloudsql.sslCerts.get cloudsql.sslCerts.list cloudsql.users.list resourcemanager.projects.get resourcemanager.projects.list serviceusage.quotas.get serviceusage.services.get serviceusage.services.list	Project

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The Databases page appears.

2. Click Add instance, and then select Cloud database service.

   The Add Cloud DB instance page appears.

3. From the Vendor list, select Google Cloud and then click Next.

   The Configure Google Cloud Database page appears.

4. From the Select A Database Service list, select MySQL and then click Next.

   The Configure Google Cloud Database - MySQL page appears.

5. For Select A Plan, select a backup plan and then click Next.

6. For Cloud Account, select an existing cloud account or create a new cloud account, and then click Next.

   The cloud account is represented in Commvault as a hypervisor. For instructions to create a Google Cloud hypervisor, see Configuring Backups for Google Cloud.

7. Under the Cloud Database Instance Details section, 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. You can also add a new credential.

      2. Click the + icon.

         The Add Credential dialog box appears.

      3. From Account type list, select a database account.

      4. From the Database type, select a database.

      5. From the Credential Vault list, select a credential vault to store credentials for different types of accounts.

      6. In the Credential name box, enter a name for the credential.

      7. In the Username box, enter the user name to access the GCP Database for MySQL application.

      8. In the Password box, enter the password to access the GCP Database for MySQL application.

         Note

         If you move the Use GCP service account toggle to right, you don't need to enter the user name detail or password.

      9. If SSL is enabled on the cloud, move the Use SSL options toggle key to the right, and then do the following:

         • In the SSL CA file field, provide the SSL CA file path on the proxy computer. (optional)

         • In the SSL Cert file field, provide the SSL certificate file path on the proxy computer. (optional)

         • In the SSL Key file field, provide the SSL key file path on the proxy computer. (optional)

   3. Click Next.

8. Click Add.

Results

• The new instance contains a default database group. The default database group includes all the data in the Google Cloud SQL for MySQL database. You cannot delete the default database group.