System Requirements for Google Cloud SQL for MySQL

Updated

To back up and restore MySQL data on a Google application, verify that your environment has the required software and a firewall.

Software Requirements

  • Package required on access nodes

    • Virtual Server Agent

    • MySQL Agent

  • Access nodes that you run backup and restore operations on must have one of the following operating systems:

    • Red Hat Enterprise Linux 8.x

    • Red Hat Enterprise Linux 7.x

    • CentOS 8.x

    • CentOS 7.x

    • Windows 2012

    • Windows 2016

    • Windows 2019

Note: If you have network configuration enabled on the access nodes, before you deploy the Linux proxy, configure a firewall on the cloud proxy and on-premises. For more information, see Configuring a Firewall to Install the Virtual Server Agent on a Cloud VM or Instance.

Supported MySQL Versions

  • MySQL 5.6.x

  • MySQL 5.7.x

  • MySQL 8.0.x

Note: To back up and restore data using MySQL version 8 on Windows, install Microsoft Visual C++ libraries.

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

The supported TLS versions to create Google Cloud SSL encrypted MySQL instances are TLS 1.0, 1.1 and 1.2.

You can create or modify a cloud MySQL instance when SSL is enabled on the cloud.

Creating an Instance

  1. Download the CreateCloudMysqlInstance.xml file and save it on the proxy computer from where the command will be executed.

  2. Execute the following command after substituting the parameter values:

    ./qoperation execute -af 'CreateCloudMysqlInstance.xml' -appName 'MySQL' -clientName "GCP cloud" -instanceName 'instance1' -port 'RDSdb publicIP:3306' -SAUser/userName 'root' -SAUser/password ‘password' -version '8.0' -sslCa '/tmp/server-ca.pem' -sslCert '/tmp/client-cert.pem' -sslKey '/tmp/client-key.pem' -planEntity/planId '12' -cloudDBEngineType 'MySQL'

Modifying an Instance

  1. Download the ModifyCloudMysqlInstance.xml file and save it on the proxy computer from where the command will be executed.

  2. Execute the following command after substituting the parameter values:

    ./qoperation execute -af 'ModifyCloudMysqlInstance.xml' -appName 'MySQL' -clientName "GCP cloud " -instanceName 'instance1' -sslCa '/newtestssl/server-ca.pem' -sslCert '/newtestssl/client-cert.pem' -sslKey '/newtestssl/client-key.pem'  -cloudDBEngineType 'MySQL'