SQLInstance

---

Warning: Some fields, when updated, might cause the instance to restart. To see the fields that can cause the instance to restart, see the REST Resource: instances documentation.

Property	Value
Google Cloud Service Name	Cloud SQL
Google Cloud Service Documentation	/sql/docs/
Google Cloud REST Resource Name	v1beta4.instance
Google Cloud REST Resource Documentation	/sql/docs/postgres/admin-api/v1beta4/instances
Config Connector Resource Short Names	gcpsqlinstance gcpsqlinstances sqlinstance
Config Connector Service Name	sqladmin.googleapis.com
Config Connector Resource Fully Qualified Name	sqlinstances.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

cloneSource:
  binLogCoordinates:
    binLogFileName: string
    binLogPosition: integer
  databaseNames:
  - string
  pointInTime: string
  sqlInstanceRef:
    external: string
    name: string
    namespace: string
databaseVersion: string
encryptionKMSCryptoKeyRef:
  external: string
  name: string
  namespace: string
instanceType: string
maintenanceVersion: string
masterInstanceRef:
  external: string
  name: string
  namespace: string
region: string
replicaConfiguration:
  caCertificate: string
  clientCertificate: string
  clientKey: string
  connectRetryInterval: integer
  dumpFilePath: string
  failoverTarget: boolean
  masterHeartbeatPeriod: integer
  password:
    value: string
    valueFrom:
      secretKeyRef:
        key: string
        name: string
  sslCipher: string
  username: string
  verifyServerCertificate: boolean
resourceID: string
rootPassword:
  value: string
  valueFrom:
    secretKeyRef:
      key: string
      name: string
settings:
  activationPolicy: string
  activeDirectoryConfig:
    domain: string
  advancedMachineFeatures:
    threadsPerCore: integer
  authorizedGaeApplications:
  - string
  availabilityType: string
  backupConfiguration:
    backupRetentionSettings:
      retainedBackups: integer
      retentionUnit: string
    binaryLogEnabled: boolean
    enabled: boolean
    location: string
    pointInTimeRecoveryEnabled: boolean
    startTime: string
    transactionLogRetentionDays: integer
  collation: string
  connectorEnforcement: string
  crashSafeReplication: boolean
  dataCacheConfig:
    dataCacheEnabled: boolean
  databaseFlags:
  - name: string
    value: string
  deletionProtectionEnabled: boolean
  denyMaintenancePeriod:
    endDate: string
    startDate: string
    time: string
  diskAutoresize: boolean
  diskAutoresizeLimit: integer
  diskSize: integer
  diskType: string
  edition: string
  insightsConfig:
    queryInsightsEnabled: boolean
    queryPlansPerMinute: integer
    queryStringLength: integer
    recordApplicationTags: boolean
    recordClientAddress: boolean
  ipConfiguration:
    allocatedIpRange: string
    authorizedNetworks:
    - expirationTime: string
      name: string
      value: string
    enablePrivatePathForGoogleCloudServices: boolean
    ipv4Enabled: boolean
    privateNetworkRef:
      external: string
      name: string
      namespace: string
    pscConfig:
    - allowedConsumerProjects:
      - string
      pscEnabled: boolean
    requireSsl: boolean
    sslMode: string
  locationPreference:
    followGaeApplication: string
    secondaryZone: string
    zone: string
  maintenanceWindow:
    day: integer
    hour: integer
    updateTrack: string
  passwordValidationPolicy:
    complexity: string
    disallowUsernameSubstring: boolean
    enablePasswordPolicy: boolean
    minLength: integer
    passwordChangeInterval: string
    reuseInterval: integer
  pricingPlan: string
  replicationType: string
  sqlServerAuditConfig:
    bucketRef:
      external: string
      name: string
      namespace: string
    retentionInterval: string
    uploadInterval: string
  tier: string
  timeZone: string

Fields
cloneSource Optional	object Create this database as a clone of a source instance. Immutable.
cloneSource.binLogCoordinates Optional	object Binary log coordinates, if specified, identify the position up to which the source instance is cloned. If not specified, the source instance is cloned up to the most recent binary log coordinates.
cloneSource.binLogCoordinates.binLogFileName Optional	string Name of the binary log file for a Cloud SQL instance.
cloneSource.binLogCoordinates.binLogPosition Optional	integer Position (offset) within the binary log file.
cloneSource.databaseNames Optional	list (string) (SQL Server only) Clone only the specified databases from the source instance. Clone all databases if empty.
cloneSource.databaseNames[] Optional	string
cloneSource.pointInTime Optional	string Timestamp, if specified, identifies the time to which the source instance is cloned.
cloneSource.sqlInstanceRef Optional	object The source SQLInstance to clone
cloneSource.sqlInstanceRef.external Optional	string The SQLInstance selfLink, when not managed by Config Connector.
cloneSource.sqlInstanceRef.name Optional	string The `name` field of a `SQLInstance` resource.
cloneSource.sqlInstanceRef.namespace Optional	string The `namespace` field of a `SQLInstance` resource.
databaseVersion Optional	string The MySQL, PostgreSQL or SQL Server (beta) version to use. Supported values include MYSQL_5_6, MYSQL_5_7, MYSQL_8_0, POSTGRES_9_6, POSTGRES_10, POSTGRES_11, POSTGRES_12, POSTGRES_13, POSTGRES_14, POSTGRES_15, SQLSERVER_2017_STANDARD, SQLSERVER_2017_ENTERPRISE, SQLSERVER_2017_EXPRESS, SQLSERVER_2017_WEB. Database Version Policies includes an up-to-date reference of supported versions.
encryptionKMSCryptoKeyRef Optional	object
encryptionKMSCryptoKeyRef.external Optional	string A reference to an externally managed KMSCryptoKey. Should be in the format `projects/[kms_project_id]/locations/[region]/keyRings/[key_ring_id]/cryptoKeys/[key]`.
encryptionKMSCryptoKeyRef.name Optional	string The `name` of a `KMSCryptoKey` resource.
encryptionKMSCryptoKeyRef.namespace Optional	string The `namespace` of a `KMSCryptoKey` resource.
instanceType Optional	string The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
maintenanceVersion Optional	string Maintenance version.
masterInstanceRef Optional	object
masterInstanceRef.external Optional	string The SQLInstance selfLink, when not managed by Config Connector.
masterInstanceRef.name Optional	string The `name` field of a `SQLInstance` resource.
masterInstanceRef.namespace Optional	string The `namespace` field of a `SQLInstance` resource.
region Optional	string Immutable. The region the instance will sit in. Note, Cloud SQL is not available in all regions. A valid region must be provided to use this resource. If a region is not provided in the resource definition, the provider region will be used instead, but this will be an apply-time error for instances if the provider region is not supported with Cloud SQL. If you choose not to provide the region argument for this resource, make sure you understand this.
replicaConfiguration Optional	object The configuration for replication.
replicaConfiguration.caCertificate Optional	string Immutable. PEM representation of the trusted CA's x509 certificate.
replicaConfiguration.clientCertificate Optional	string Immutable. PEM representation of the replica's x509 certificate.
replicaConfiguration.clientKey Optional	string Immutable. PEM representation of the replica's private key. The corresponding public key in encoded in the client_certificate.
replicaConfiguration.connectRetryInterval Optional	integer Immutable. The number of seconds between connect retries. MySQL's default is 60 seconds.
replicaConfiguration.dumpFilePath Optional	string Immutable. Path to a SQL file in Google Cloud Storage from which replica instances are created. Format is gs://bucket/filename.
replicaConfiguration.failoverTarget Optional	boolean Immutable. Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. If the master instance fails, the replica instance will be promoted as the new master instance. Not supported for Postgres.
replicaConfiguration.masterHeartbeatPeriod Optional	integer Immutable. Time in ms between replication heartbeats.
replicaConfiguration.password Optional	object Immutable. Password for the replication connection.
replicaConfiguration.password.value Optional	string Value of the field. Cannot be used if 'valueFrom' is specified.
replicaConfiguration.password.valueFrom Optional	object Source for the field's value. Cannot be used if 'value' is specified.
replicaConfiguration.password.valueFrom.secretKeyRef Optional	object Reference to a value with the given key in the given Secret in the resource's namespace.
replicaConfiguration.password.valueFrom.secretKeyRef.key Required*	string Key that identifies the value to be extracted.
replicaConfiguration.password.valueFrom.secretKeyRef.name Required*	string Name of the Secret to extract a value from.
replicaConfiguration.sslCipher Optional	string Immutable. Permissible ciphers for use in SSL encryption.
replicaConfiguration.username Optional	string Immutable. Username for replication connection.
replicaConfiguration.verifyServerCertificate Optional	boolean Immutable. True if the master's common name value is checked during the SSL handshake.
resourceID Optional	string Immutable. Optional. The name of the resource. Used for creation and acquisition. When unset, the value of `metadata.name` is used as the default.
rootPassword Optional	object Initial root password. Required for MS SQL Server.
rootPassword.value Optional	string Value of the field. Cannot be used if 'valueFrom' is specified.
rootPassword.valueFrom Optional	object Source for the field's value. Cannot be used if 'value' is specified.
rootPassword.valueFrom.secretKeyRef Optional	object Reference to a value with the given key in the given Secret in the resource's namespace.
rootPassword.valueFrom.secretKeyRef.key Required*	string Key that identifies the value to be extracted.
rootPassword.valueFrom.secretKeyRef.name Required*	string Name of the Secret to extract a value from.
settings Required	object The settings to use for the database. The configuration is detailed below.
settings.activationPolicy Optional	string This specifies when the instance should be active. Can be either ALWAYS, NEVER or ON_DEMAND.
settings.activeDirectoryConfig Optional	object
settings.activeDirectoryConfig.domain Required*	string Domain name of the Active Directory for SQL Server (e.g., mydomain.com).
settings.advancedMachineFeatures Optional	object
settings.advancedMachineFeatures.threadsPerCore Optional	integer The number of threads per physical core. Can be 1 or 2.
settings.authorizedGaeApplications Optional	list (string) DEPRECATED. This property is only applicable to First Generation instances, and First Generation instances are now deprecated. see https://cloud.google.com/sql/docs/mysql/deprecation-notice for information on how to upgrade to Second Generation instances. Specifying this field has no-ops; it's recommended to remove this field from your configuration.
settings.authorizedGaeApplications[] Optional	string
settings.availabilityType Optional	string The availability type of the Cloud SQL instance, high availability (REGIONAL) or single zone (ZONAL). For all instances, ensure that settings.backup_configuration.enabled is set to true. For MySQL instances, ensure that settings.backup_configuration.binary_log_enabled is set to true. For Postgres instances, ensure that settings.backup_configuration.point_in_time_recovery_enabled is set to true. Defaults to ZONAL.
settings.backupConfiguration Optional	object
settings.backupConfiguration.backupRetentionSettings Optional	object
settings.backupConfiguration.backupRetentionSettings.retainedBackups Required*	integer Number of backups to retain.
settings.backupConfiguration.backupRetentionSettings.retentionUnit Optional	string The unit that 'retainedBackups' represents. Defaults to COUNT.
settings.backupConfiguration.binaryLogEnabled Optional	boolean True if binary logging is enabled. If settings.backup_configuration.enabled is false, this must be as well. Can only be used with MySQL.
settings.backupConfiguration.enabled Optional	boolean True if backup configuration is enabled.
settings.backupConfiguration.location Optional	string Location of the backup configuration.
settings.backupConfiguration.pointInTimeRecoveryEnabled Optional	boolean True if Point-in-time recovery is enabled.
settings.backupConfiguration.startTime Optional	string HH:MM format time indicating when backup configuration starts.
settings.backupConfiguration.transactionLogRetentionDays Optional	integer The number of days of transaction logs we retain for point in time restore, from 1-7. (For PostgreSQL Enterprise Plus instances, from 1 to 35.).
settings.collation Optional	string Immutable. The name of server instance collation.
settings.connectorEnforcement Optional	string Specifies if connections must use Cloud SQL connectors.
settings.crashSafeReplication Optional	boolean DEPRECATED. This property is only applicable to First Generation instances, and First Generation instances are now deprecated. see https://cloud.google.com/sql/docs/mysql/deprecation-notice for information on how to upgrade to Second Generation instances. Specifying this field has no-ops; it's recommended to remove this field from your configuration.
settings.dataCacheConfig Optional	object Data cache configurations.
settings.dataCacheConfig.dataCacheEnabled Optional	boolean Whether data cache is enabled for the instance.
settings.databaseFlags Optional	list (object)
settings.databaseFlags[] Optional	object
settings.databaseFlags[].name Required*	string Name of the flag.
settings.databaseFlags[].value Required*	string Value of the flag.
settings.deletionProtectionEnabled Optional	boolean Configuration to protect against accidental instance deletion.
settings.denyMaintenancePeriod Optional	object
settings.denyMaintenancePeriod.endDate Required*	string End date before which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01.
settings.denyMaintenancePeriod.startDate Required*	string Start date after which maintenance will not take place. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01.
settings.denyMaintenancePeriod.time Required*	string Time in UTC when the "deny maintenance period" starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00.
settings.diskAutoresize Optional	boolean Enables auto-resizing of the storage size. Defaults to true.
settings.diskAutoresizeLimit Optional	integer The maximum size, in GB, to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
settings.diskSize Optional	integer The size of data disk, in GB. Size of a running instance cannot be reduced but can be increased. The minimum value is 10GB.
settings.diskType Optional	string Immutable. The type of data disk: PD_SSD or PD_HDD. Defaults to PD_SSD.
settings.edition Optional	string The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.
settings.insightsConfig Optional	object Configuration of Query Insights.
settings.insightsConfig.queryInsightsEnabled Optional	boolean True if Query Insights feature is enabled.
settings.insightsConfig.queryPlansPerMinute Optional	integer Number of query execution plans captured by Insights per minute for all queries combined. Between 0 and 20. Default to 5.
settings.insightsConfig.queryStringLength Optional	integer Maximum query length stored in bytes. Between 256 and 4500. Default to 1024.
settings.insightsConfig.recordApplicationTags Optional	boolean True if Query Insights will record application tags from query when enabled.
settings.insightsConfig.recordClientAddress Optional	boolean True if Query Insights will record client address when enabled.
settings.ipConfiguration Optional	object
settings.ipConfiguration.allocatedIpRange Optional	string The name of the allocated ip range for the private ip CloudSQL instance. For example: "google-managed-services-default". If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression [a-z]([-a-z0-9]*[a-z0-9])?.
settings.ipConfiguration.authorizedNetworks Optional	list (object)
settings.ipConfiguration.authorizedNetworks[] Optional	object
settings.ipConfiguration.authorizedNetworks[].expirationTime Optional	string
settings.ipConfiguration.authorizedNetworks[].name Optional	string
settings.ipConfiguration.authorizedNetworks[].value Required*	string
settings.ipConfiguration.enablePrivatePathForGoogleCloudServices Optional	boolean Whether Google Cloud services such as BigQuery are allowed to access data in this Cloud SQL instance over a private IP connection. SQLSERVER database type is not supported.
settings.ipConfiguration.ipv4Enabled Optional	boolean Whether this Cloud SQL instance should be assigned a public IPV4 address. At least ipv4_enabled must be enabled or a private_network must be configured.
settings.ipConfiguration.privateNetworkRef Optional	object
settings.ipConfiguration.privateNetworkRef.external Optional	string A reference to an externally managed Compute Network resource. Should be in the format `projects/{{projectID}}/global/networks/{{network}}`.
settings.ipConfiguration.privateNetworkRef.name Optional	string The `name` field of a `ComputeNetwork` resource.
settings.ipConfiguration.privateNetworkRef.namespace Optional	string The `namespace` field of a `ComputeNetwork` resource.
settings.ipConfiguration.pscConfig Optional	list (object) PSC settings for a Cloud SQL instance.
settings.ipConfiguration.pscConfig[] Optional	object
settings.ipConfiguration.pscConfig[].allowedConsumerProjects Optional	list (string) List of consumer projects that are allow-listed for PSC connections to this instance. This instance can be connected to with PSC from any network in these projects. Each consumer project in this list may be represented by a project number (numeric) or by a project id (alphanumeric).
settings.ipConfiguration.pscConfig[].allowedConsumerProjects[] Optional	string
settings.ipConfiguration.pscConfig[].pscEnabled Optional	boolean Whether PSC connectivity is enabled for this instance.
settings.ipConfiguration.requireSsl Optional	boolean
settings.ipConfiguration.sslMode Optional	string Specify how SSL connection should be enforced in DB connections. This field provides more SSL enforcment options compared to requireSsl. To change this field, also set the correspoding value in requireSsl if it has been set.
settings.locationPreference Optional	object
settings.locationPreference.followGaeApplication Optional	string A Google App Engine application whose zone to remain in. Must be in the same region as this instance.
settings.locationPreference.secondaryZone Optional	string The preferred Compute Engine zone for the secondary/failover.
settings.locationPreference.zone Optional	string The preferred compute engine zone.
settings.maintenanceWindow Optional	object Declares a one-hour maintenance window when an Instance can automatically restart to apply updates. The maintenance window is specified in UTC time.
settings.maintenanceWindow.day Optional	integer Day of week (1-7), starting on Monday.
settings.maintenanceWindow.hour Optional	integer Hour of day (0-23), ignored if day not set.
settings.maintenanceWindow.updateTrack Optional	string Receive updates earlier (canary) or later (stable).
settings.passwordValidationPolicy Optional	object
settings.passwordValidationPolicy.complexity Optional	string Password complexity.
settings.passwordValidationPolicy.disallowUsernameSubstring Optional	boolean Disallow username as a part of the password.
settings.passwordValidationPolicy.enablePasswordPolicy Required*	boolean Whether the password policy is enabled or not.
settings.passwordValidationPolicy.minLength Optional	integer Minimum number of characters allowed.
settings.passwordValidationPolicy.passwordChangeInterval Optional	string Minimum interval after which the password can be changed. This flag is only supported for PostgresSQL.
settings.passwordValidationPolicy.reuseInterval Optional	integer Number of previous passwords that cannot be reused.
settings.pricingPlan Optional	string Pricing plan for this instance, can only be PER_USE.
settings.replicationType Optional	string DEPRECATED. This property is only applicable to First Generation instances, and First Generation instances are now deprecated. see https://cloud.google.com/sql/docs/mysql/deprecation-notice for information on how to upgrade to Second Generation instances. Specifying this field has no-ops; it's recommended to remove this field from your configuration.
settings.sqlServerAuditConfig Optional	object
settings.sqlServerAuditConfig.bucketRef Optional	object The name of the destination bucket (e.g., gs://mybucket).
settings.sqlServerAuditConfig.bucketRef.external Optional	string The StorageBucket selfLink, when not managed by Config Connector.
settings.sqlServerAuditConfig.bucketRef.name Optional	string The `name` field of a `StorageBucket` resource.
settings.sqlServerAuditConfig.bucketRef.namespace Optional	string The `namespace` field of a `StorageBucket` resource.
settings.sqlServerAuditConfig.retentionInterval Optional	string How long to keep generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s"..
settings.sqlServerAuditConfig.uploadInterval Optional	string How often to upload generated audit files. A duration in seconds with up to nine fractional digits, terminated by 's'. Example: "3.5s".
settings.tier Required	string The machine type to use. See tiers for more details and supported versions. Postgres supports only shared-core machine types, and custom machine types such as db-custom-2-13312. See the Custom Machine Type Documentation to learn about specifying custom machine types.
settings.timeZone Optional	string Immutable. The time_zone to be used by the database engine (supported only for SQL Server), in SQL Server timezone format.

* Field is required when parent field is specified

Status

Schema

availableMaintenanceVersions:
- string
conditions:
- lastTransitionTime: string
  message: string
  reason: string
  status: string
  type: string
connectionName: string
dnsName: string
firstIpAddress: string
instanceType: string
ipAddress:
- ipAddress: string
  timeToRetire: string
  type: string
observedGeneration: integer
privateIpAddress: string
pscServiceAttachmentLink: string
publicIpAddress: string
selfLink: string
serverCaCert:
  cert: string
  commonName: string
  createTime: string
  expirationTime: string
  sha1Fingerprint: string
serviceAccountEmailAddress: string

Fields
availableMaintenanceVersions	list (string) Available Maintenance versions.
availableMaintenanceVersions[]	string
conditions	list (object) Conditions represent the latest available observations of the SQLInstance's current state.
conditions[]	object
conditions[].lastTransitionTime	string Last time the condition transitioned from one status to another.
conditions[].message	string Human-readable message indicating details about last transition.
conditions[].reason	string Unique, one-word, CamelCase reason for the condition's last transition.
conditions[].status	string Status is the status of the condition. Can be True, False, Unknown.
conditions[].type	string Type is the type of the condition.
connectionName	string The connection name of the instance to be used in connection strings. For example, when connecting with Cloud SQL Proxy.
dnsName	string The dns name of the instance.
firstIpAddress	string
instanceType	string The type of the instance. The valid values are:- 'SQL_INSTANCE_TYPE_UNSPECIFIED', 'CLOUD_SQL_INSTANCE', 'ON_PREMISES_INSTANCE' and 'READ_REPLICA_INSTANCE'.
ipAddress	list (object)
ipAddress[]	object
ipAddress[].ipAddress	string
ipAddress[].timeToRetire	string
ipAddress[].type	string
observedGeneration	integer 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.
privateIpAddress	string
pscServiceAttachmentLink	string The link to service attachment of PSC instance.
publicIpAddress	string
selfLink	string The URI of the created resource.
serverCaCert	object
serverCaCert.cert	string The CA Certificate used to connect to the SQL Instance via SSL.
serverCaCert.commonName	string The CN valid for the CA Cert.
serverCaCert.createTime	string Creation time of the CA Cert.
serverCaCert.expirationTime	string Expiration time of the CA Cert.
serverCaCert.sha1Fingerprint	string SHA Fingerprint of the CA Cert.
serviceAccountEmailAddress	string The service account email address assigned to the instance.

Sample YAML(s)

Mysql SQL Instance

# 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: SQLInstance
metadata:
  name: sqlinstance-sample-mysql
spec:
  databaseVersion: MYSQL_5_7
  region: us-central1
  settings:
    tier: db-f1-micro

Mysql SQL Instance High Availability

# 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: SQLInstance
metadata:
  name: sqlinstance-sample-mysqlhighavailability
spec:
  databaseVersion: MYSQL_5_7
  region: us-central1
  settings:
    tier: db-g1-small
    diskSize: 25
    diskType: PD_SSD
    availabilityType: REGIONAL
    backupConfiguration:
      binaryLogEnabled: true
      enabled: true

Mysql SQL Instance With Replication

# 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: SQLInstance
metadata:
  name: sqlinstance-sample1-mysqlwithreplication
spec:
  databaseVersion: MYSQL_5_7
  region: us-central1
  settings:
    tier: db-f1-micro
    backupConfiguration:
        binaryLogEnabled: true
        enabled: true
        startTime: "18:00"
    ipConfiguration:
      requireSsl: true
    locationPreference:
        zone: us-central1-b
---
apiVersion: sql.cnrm.cloud.google.com/v1beta1
kind: SQLInstance
metadata:
  name: sqlinstance-sample2-mysqlwithreplication
spec:
  databaseVersion: MYSQL_5_7
  region: us-central1
  masterInstanceRef: 
    name: sqlinstance-sample1-mysqlwithreplication
  replicaConfiguration:
    connectRetryInterval: 30
  settings:
    tier: db-f1-micro
    ipConfiguration:
      requireSsl: true
    locationPreference:
        zone: us-central1-a

Postgres SQL Instance High Availability

# 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: SQLInstance
metadata:
  name: sqlinstance-sample-postgreshighavailability
spec:
  databaseVersion: POSTGRES_9_6
  region: us-central1
  settings:
    tier: db-custom-1-3840
    availabilityType: REGIONAL

Private Ip Instance

# 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: SQLInstance
metadata:
  name: sqlinstance-sample-private-ip
spec:
  databaseVersion: MYSQL_5_7
  region: us-central1
  settings:
    tier: db-f1-micro
    ipConfiguration:
      ipv4Enabled: false
      privateNetworkRef:
        name: sqlinstance-dep-private-ip
---
apiVersion: compute.cnrm.cloud.google.com/v1beta1
kind: ComputeAddress
metadata:
  name: sqlinstance-dep-private-ip
spec:
  addressType: INTERNAL
  location: global
  purpose: VPC_PEERING
  prefixLength: 16
  networkRef:
    name: sqlinstance-dep-private-ip
---
apiVersion: compute.cnrm.cloud.google.com/v1beta1
kind: ComputeNetwork
metadata:
  name: sqlinstance-dep-private-ip
spec:
  autoCreateSubnetworks: false
---
apiVersion: servicenetworking.cnrm.cloud.google.com/v1beta1
kind: ServiceNetworkingConnection
metadata:
  name: sqlinstance-dep-private-ip
spec:
  networkRef:
    name: sqlinstance-dep-private-ip
  reservedPeeringRanges:
    - name: sqlinstance-dep-private-ip
  service: servicenetworking.googleapis.com

SQL Server Instance

# Copyright 2022 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: SQLInstance
metadata:
  name: sqlinstance-sample-sqlserver
  annotations:
    # Replace ${PROJECT_ID?} with your project ID
    cnrm.cloud.google.com/project-id: ${PROJECT_ID?}
spec:
  region: us-central1
  databaseVersion: SQLSERVER_2017_EXPRESS
  settings:
    tier: db-custom-1-3840
    sqlServerAuditConfig:
      bucketRef:
        name: ${PROJECT_ID?}-sqlinstance-dep-sqlserver
  rootPassword:
    value: "1234"
---
apiVersion: storage.cnrm.cloud.google.com/v1beta1
kind: StorageBucket
metadata:
  annotations:
    cnrm.cloud.google.com/force-destroy: "false"
  # StorageBucket names must be globally unique. Replace ${PROJECT_ID?} with your project ID.
  name: ${PROJECT_ID?}-sqlinstance-dep-sqlserver

Note: If you have any trouble with instantiating the resource, refer to Troubleshoot Config Connector.