Google MySQL Reference (Beta)

This topic gives you reference information about the Google MySQL service (csb-google-mysql). It details the plans, configuration parameters, and binding credentials.

Caution The Google MySQL service offering is currently in beta and is intended for evaluation and test purposes only. Do not use this product in a production environment.

Plans

The table below lists the plans for Google MySQL:

Plan	Description
small	MySQL v5.7, minimum 2 cores, minimum 4 GB RAM, 10 GB storage
medium	MySQL v5.7, minimum 4 cores, minimum 8 GB RAM, 10 GB storage
large	MySQL v5.7, minimum 8 cores, minimum 16 GB RAM, 20 GB storage

Plan Configuration Parameters

When configuring Cloud Service Broker for GCP you can add additional plans. For how to configure plans, see Configure Services with Cloud Service Broker for GCP.

The following table lists parameters which can only be configured for additional plans:

Parameter Name	Values	Default
name*	The plan name	n/a
id*	A unique GUID	n/a
description*	Description of the new plan	n/a
display_name	Name to use when displaying plan in marketplace	n/a
free	When false, Service Instances of this Service Plan have a cost	true
bindable	Specifies whether Service Instances of the Service Plan can bind to applications	true
plan_updateable	Whether the Plan supports upgrade/downgrade/sidegrade to another version	true

^* Required

You can also add any of the configuration parameters listed in the parameters section to your plan.

To create plans with specific size and versions we recommend setting cores, storage_gb and mysql_version properties.

Note If you set a parameter at plan level, developers cannot change the value when creating or updating service instances.

Configuration Parameters

You can provision a service by running:

cf create-service csb-google-mysql PLAN-NAME SERVICE-INSTANCE-NAME -c '{"PARAMETER-NAME": "PARAMETER-VALUE"}'

You can update the configuration parameters for a service instance by running:

cf update-service SERVICE-INSTANCE-NAME -c '{"PARAMETER-NAME": "PARAMETER-VALUE"}'

The following table lists the parameters that you can configure, by using the -c flag, when provisioning a csb-google-mysql service:

Parameter Name	Type	Description	Default	Operation
cores	string	(Required unless defined in plan) Minimum number of cores for service instance, 1–64, multiples of 2.	2	provision and update
storage_gb	number	(Required unless defined in plan) Size of storage volume for service instance, 10–4096 GB.	10	provision and update
instance_name	string	Name for the mysql instance.	csb-mysql-INSTANCE-ID	provision
db_name	string	Name for the database.	csb-db	provision
region	string	The region of the MySQL instance.	us-central1	provision
authorized_network	string	The name of the Google Compute Engine network to which the instance is connected.	default	provision
authorized_network_id	string	The ID of the Google Compute Engine network to which the instance is connected.	""	provision
credentials	string	The GCP credentials.	The value the operator entered for Credentials in Ops Manager.	provision and update
project	string	The GCP project to use.	The value the operator entered for Project in Ops Manager.	provision and update

Binding Credentials

You can bind a service by running:

cf bind-service APP-NAME SERVICE-INSTANCE --binding-name BINDING-NAME

The format for binding credentials for Google MySQL is as follows:

{
    "name" : "DATABASE-NAME",
    "hostname" : "DATABASE-SERVER-HOST",
    "port" : "DATABASE-SERVER-PORT",
    "username" : "AUTHENTICATION-USERNAME",
    "password" : "AUTHENTICATION-PASSWORD",
    "use_tls" : false,
    "uri" : "DATABASE-CONNECTION-URI",
    "jdbcUrl" : "JDBC-FORMAT-CONNECTION-URI"
}