> CommCell Console > Backup and Restore Agents > Databases > Google Cloud Database

Google Cloud Database for MySQL

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

The VM instance must have access to the Google Cloud service endpoints. The VM instance that is acting as a proxy must have communication with the database instances that will be backed up. To ensure this connectivity, the security group rule for database instance must be added. This allows connection from the proxy on the port where the database instance is running. The default port for MySQL is 3306.

Note

From Service Pack 20 onwards, you can create the hypervisor for Google Cloud Database only from the Command Center. However, you can still use the existing hypervisors and perform backup and restore operations from the CommCell Console.

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;

SSL and TLS Support

SSL is supported for MySQL version 5.7 and later. The supported TLS versions to create Google Cloud SSL encrypted MySQL instances are TLS 1.0, 1.1 and 1.2.

×

Loading...