SQLDatabase
| Property | Value |
|---|---|
| Google Cloud Service Name | Cloud SQL |
| Google Cloud Service Documentation | /sql/docs/ |
| Google Cloud REST Resource Name | v1beta4.database |
| Google Cloud REST Resource Documentation | /sql/docs/postgres/admin-api/v1beta4/databases |
| Config Connector Resource Short Names | gcpsqldatabase gcpsqldatabases sqldatabase |
| Config Connector Service Name | sqladmin.googleapis.com |
| Config Connector Resource Fully Qualified Name | sqldatabases.sql.cnrm.cloud.google.com |
| Can Be Referenced by IAMPolicy/IAMPolicyMember | No |
| Config Connector Default Average Reconcile Interval In Seconds | 600 |
Custom Resource Definition Properties
Annotations
| Fields | |
|---|---|
cnrm.cloud.google.com/project-id
|
|
Spec
Schema
charset
:
string
collation
:
string
deletionPolicy
:
string
instanceRef
:
external
:
string
name
:
string
namespace
:
string
resourceID
:
string
| Fields | |
|---|---|
| Optional |
The charset value. See MySQL's [Supported Character Sets and Collations](https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html) and Postgres' [Character Set Support](https://www.postgresql.org/docs/9.6/static/multibyte.html) for more details and supported values. Postgres databases only support a value of 'UTF8' at creation time. |
| Optional |
The collation value. See MySQL's [Supported Character Sets and Collations](https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html) and Postgres' [Collation Support](https://www.postgresql.org/docs/9.6/static/collation.html) for more details and supported values. Postgres databases only support a value of 'en_US.UTF8' at creation time. |
| Optional |
The deletion policy for the database. Setting ABANDON allows the resource to be abandoned rather than deleted. This is useful for Postgres, where databases cannot be deleted from the API if there are users other than cloudsqlsuperuser with access. Possible values are: "ABANDON", "DELETE". Defaults to "DELETE". |
| Required |
The Cloud SQL instance. |
| Optional |
Allowed value: The `name` field of a `SQLInstance` resource. |
| Optional |
Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names |
| Optional |
Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/ |
| Optional |
Immutable. Optional. The name of the resource. Used for creation and acquisition. When unset, the value of `metadata.name` is used as the default. |
Status
Schema
conditions
:
-
lastTransitionTime
:
string
message
:
string
reason
:
string
status
:
string
type
:
string
observedGeneration
:
integer
selfLink
:
string
| Fields | |
|---|---|
conditions
|
Conditions represent the latest available observation of the resource's current state. |
conditions[]
|
|
conditions[].lastTransitionTime
|
Last time the condition transitioned from one status to another. |
conditions[].message
|
Human-readable message indicating details about last transition. |
conditions[].reason
|
Unique, one-word, CamelCase reason for the condition's last transition. |
conditions[].status
|
Status is the status of the condition. Can be True, False, Unknown. |
conditions[].type
|
Type is the type of the condition. |
observedGeneration
|
ObservedGeneration is the generation of the resource that was most recently observed by the Config Connector controller. If this is equal to metadata.generation, then that means that the current reported status reflects the most recent desired state of the resource. |
selfLink
|
|
Sample YAML(s)
Typical Use Case
# Copyright 2020 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
apiVersion
:
sql.cnrm.cloud.google.com/v1beta1
kind
:
SQLDatabase
metadata
:
labels
:
label-one
:
"value-one"
name
:
sqldatabase-sample
spec
:
charset
:
utf8mb4
collation
:
utf8mb4_bin
instanceRef
:
name
:
sqldatabase-dep
---
apiVersion
:
sql.cnrm.cloud.google.com/v1beta1
kind
:
SQLInstance
metadata
:
name
:
sqldatabase-dep
spec
:
region
:
us-central1
databaseVersion
:
MYSQL_5_7
settings
:
tier
:
db-n1-standard-1
