Warning: 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.

This topic provides reference information about the Google MySQL service (csb-google-mysql).

It details the plans, configuration parameters, and binding credentials.

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, minumum 4 cores, minumum 8 GB RAM, 10 GB storage
large MySQL v5.7, minumum 8 cores, minumum 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 table below lists the parameters that you can configure, 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 string (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

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"
}
check-circle-line exclamation-circle-line close-line
Scroll to top icon