Cloud SQL (MySQL) is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud. For more information, see the following:
This document describes the connections and parameters you can configure when using App Design Center to create a Cloud SQL for MySQL instance. The configuration parameters are based on the terraform-google-sql-db Terraform module.
Component connections
The following table includes the components that you can connect to a Cloud SQL (MySQL) instance, and the resulting updates to your application and its generated Terraform code.
Connected component |
Application updates |
Background information |
|---|---|---|
|
Connect from Compute Engine | |
| Secret Manager |
|
Use Secret Manager to handle secrets in Cloud SQL |
|
Roles and permissions | |
|
Connect from Cloud Run |
Required configuration parameters
If your template includes a Cloud SQL (MySQL) component, you must configure the following parameters before you deploy.
Parameter name |
Description and constraint information |
Background information |
|---|---|---|
Project ID |
The project where you want to deploy the Cloud SQL resource. |
Configure components |
Name |
name | Create a MySQL instance |
Database Version |
databaseVersion | SqlDatabaseVersion |
Region |
region | Manage instance locations |
Optional configuration parameters
The following parameters are optional. To display advanced parameters, in the Configuration area, select Show advanced fields.
Feature |
Parameter name |
Description and constraint information |
Background information |
|---|---|---|---|
Zone |
gceZone | Manage instance locations | |
Edition |
edition | Introduction to Cloud SQL for MySQL editions | |
Availability Type |
availabilityType | Availability in Cloud SQL | |
Enable Default Db |
If selected, create a default database. In the Db Name field, enter the name of the default database. |
Create a database on the Cloud SQL instance | |
Enable Default User |
If selected, create a default user. Enter a User Name and User Password for the default user. |
Default MySQL user | |
Root Password |
rootPassword | Initial root password when the instance is created. |
|
Machine |
Select a machine series and type for your instance. The options that you select determine available storage type and configuration options. You can't change the machine series after you create your instance. |
Machine series overview | |
Disk Autoresize |
Disk Autoresize |
storageAutoResize | Enable automatic storage increases |
Disk Autoresize Limit |
storageAutoResizeLimit | Automatic storage increase limit | |
Disk Size |
dataDiskSizeGb | Storage capacity | |
Disk Type |
dataDiskType | Storage type | |
Pricing Plan |
pricingPlan | SqlPricingPlan | |
Backup Configuration |
Binary Log Enabled |
binaryLogEnabled | Create a MySQL instance |
Enabled |
enabled | Create a MySQL instance | |
Start Time |
Create a MySQL instance | ||
Region |
location | Custom backup locations | |
Zone |
location | Custom backup locations | |
Transaction Log Retention Days |
transactionLogRetentionDays | Log retention period | |
Retained Backups |
retainedBackups | Logs and disk usage | |
Retention Unit |
retentionUnit | Logs and disk usage | |
IP Configuration |
Authorized Network Key |
authorizedNetworks[] | Authorize with authorized networks |
Authorized Network Value |
authorizedNetworks[] | Authorize with authorized networks | |
IPv4 Enabled |
ipv4Enabled | Configure Public IP | |
Private Network |
privateNetwork | Configure Private IP | |
SSL Mode |
sslMode | SSL mode | |
Allocated IP Range |
allocatedIpRange | Allocated IP address ranges for services | |
Enable Private Path for Google Cloud Services |
Private path for Google Cloud services | Create an instance that supports private services access and Private Service Connect | |
PSC Enabled |
pscEnabled | Private Service Connect overview | |
PSC Allowed Consumer Projects |
allowedConsumerProjects | Create an instance that supports private services access and Private Service Connect | |
Maintenance Version |
maintenanceVersion | Self-service maintenance | |
User Host |
The host for the default user. |
host | |
Deletion protection |
If selected, the Cloud SQL instance cannot be deleted. | Prevent deletion of an instance | |
User Deletion Policy |
To allow the user to be abandoned rather than deleted, enter |
MySQL users cannot be deleted if they have been granted SQL roles. |
|
Data Cache Enabled |
Data cache | Data cache overview | |
Additional Databases |
Name |
name | Create and manage databases |
Collation |
collation | Create and manage databases | |
Additional Users |
Name |
name | About MySQL users and roles |
Password |
Enter a password, or select Random Password to generate a password. |
About MySQL users and roles | |
Type |
SqlUserType | About MySQL users and roles | |
Host |
host | About MySQL users and roles | |
IAM Users |
ID |
The IAM user's ID. |
IAM authentication |
The IAM user's email. |
Add an individual IAM user or service account to a Cloud SQL instance | ||
Type |
type | Add an individual IAM user or service account to a Cloud SQL instance | |
Random Instance Name |
Add a random suffix to the end of the instance name. |
random_instance_name | |
Replica Database Version |