Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/sql/docs/postgres/admin-api/rest/v1/instances below:

REST Resource: instances | Cloud SQL for PostgreSQL

• Resource: DatabaseInstance
  • JSON representation
• SqlInstanceState
• Settings
  • JSON representation
• SqlAvailabilityType
• SqlPricingPlan
• SqlReplicationType
• SqlActivationPolicy
• IpConfiguration
  • JSON representation
• AclEntry
  • JSON representation
• SslMode
• PscConfig
  • JSON representation
• CaMode
• LocationPreference
  • JSON representation
• DatabaseFlags
  • JSON representation
• SqlDataDiskType
• MaintenanceWindow
  • JSON representation
• SqlUpdateTrack
• BackupConfiguration
  • JSON representation
• BackupRetentionSettings
  • JSON representation
• RetentionUnit
• TransactionalLogStorageState
• SqlActiveDirectoryConfig
  • JSON representation
• DenyMaintenancePeriod
  • JSON representation
• InsightsConfig
  • JSON representation
• PasswordValidationPolicy
  • JSON representation
• Complexity
• SqlServerAuditConfig
  • JSON representation
• Edition
• ConnectorEnforcement
• ConnectionPoolConfig
  • JSON representation
• ConnectionPoolFlags
  • JSON representation
• IpMapping
  • JSON representation
• SqlIpAddressType
• SqlInstanceType
• OnPremisesConfiguration
  • JSON representation
• InstanceReference
  • JSON representation
• SelectedObjects
  • JSON representation
• ReplicaConfiguration
  • JSON representation
• MySqlReplicaConfiguration
  • JSON representation
• SqlBackendType
• SqlSuspensionReason
• SqlScheduledMaintenance
  • JSON representation
• SqlOutOfDiskReport
  • JSON representation
• SqlOutOfDiskState
• AvailableDatabaseVersion
  • JSON representation
• SqlNetworkArchitecture
• ReplicationCluster
  • JSON representation
• GeminiInstanceConfig
  • JSON representation
• DnsNameMapping
  • JSON representation
• ConnectionType
• DnsScope

A Cloud SQL instance resource.

{
  "kind": string,
  "state": enum (SqlInstanceState),
  "databaseVersion": enum (SqlDatabaseVersion),
  "settings": {
    object (Settings)
  },
  "etag": string,
  "failoverReplica": {
    "name": string,
    "available": boolean
  },
  "masterInstanceName": string,
  "replicaNames": [
    string
  ],
  "maxDiskSize": string,
  "currentDiskSize": string,
  "ipAddresses": [
    {
      object (IpMapping)
    }
  ],
  "serverCaCert": {
    object (SslCert)
  },
  "instanceType": enum (SqlInstanceType),
  "project": string,
  "ipv6Address": string,
  "serviceAccountEmailAddress": string,
  "onPremisesConfiguration": {
    object (OnPremisesConfiguration)
  },
  "replicaConfiguration": {
    object (ReplicaConfiguration)
  },
  "backendType": enum (SqlBackendType),
  "selfLink": string,
  "suspensionReason": [
    enum (SqlSuspensionReason)
  ],
  "connectionName": string,
  "name": string,
  "region": string,
  "gceZone": string,
  "secondaryGceZone": string,
  "diskEncryptionConfiguration": {
    object (DiskEncryptionConfiguration)
  },
  "diskEncryptionStatus": {
    object (DiskEncryptionStatus)
  },
  "rootPassword": string,
  "scheduledMaintenance": {
    object (SqlScheduledMaintenance)
  },
  "satisfiesPzs": boolean,
  "databaseInstalledVersion": string,
  "createTime": string,
  "availableMaintenanceVersions": [
    string
  ],
  "maintenanceVersion": string,
  "upgradableDatabaseVersions": [
    {
      object (AvailableDatabaseVersion)
    }
  ],
  "replicationCluster": {
    object (ReplicationCluster)
  },
  "satisfiesPzi": boolean,
  "nodes": [
    {
      object (PoolNodeConfig)
    }
  ],
  "dnsNames": [
    {
      object (DnsNameMapping)
    }
  ],
  "outOfDiskReport": {
    object (SqlOutOfDiskReport)
  },
  "sqlNetworkArchitecture": enum (SqlNetworkArchitecture),
  "pscServiceAttachmentLink": string,
  "dnsName": string,
  "primaryDnsName": string,
  "writeEndpoint": string,
  "geminiConfig": {
    object (GeminiInstanceConfig)
  },
  "nodeCount": integer
}

string

This is always sql#instance.

enum (SqlInstanceState)

The current serving state of the Cloud SQL instance.

enum (SqlDatabaseVersion)

The database engine type and version. The databaseVersion field cannot be changed after instance creation.

object (Settings)

The user settings.

string

This field is deprecated and will be removed from a future version of the API. Use the settings.settingsVersion field instead.

object

The name and status of the failover replica.

string

The name of the failover replica. If specified at instance creation, a failover replica is created for the instance. The name doesn't include the project ID.

boolean

The availability status of the failover replica. A false status indicates that the failover replica is out of sync. The primary instance can only failover to the failover replica when the status is true.

string

The name of the instance which will act as primary in the replication setup.

string

The replicas of the instance.

string (Int64Value format)

This item is deprecated!

The maximum disk size of the instance in bytes.

string (Int64Value format)

This item is deprecated!

The current disk usage of the instance in bytes. This property has been deprecated. Use the "cloudsql.googleapis.com/database/disk/bytes_used" metric in Cloud Monitoring API instead. Please see this announcement for details.

object (IpMapping)

The assigned IP addresses for the instance.

object (SslCert)

SSL configuration.

enum (SqlInstanceType)

The instance type.

string

The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.

string

This item is deprecated!

The IPv6 address assigned to the instance. (Deprecated) This property was applicable only to First Generation instances.

string

The service account email address assigned to the instance.\This property is read-only.

object (OnPremisesConfiguration)

Configuration specific to on-premises instances.

object (ReplicaConfiguration)

Configuration specific to failover replicas and read replicas.

enum (SqlBackendType)

The backend type. SECOND_GEN: Cloud SQL database instance. EXTERNAL: A database server that is not managed by Google.

This property is read-only; use the tier property in the settings object to determine the database type.

string

The URI of this resource.

enum (SqlSuspensionReason)

If the instance state is SUSPENDED, the reason for the suspension.

string

Connection name of the Cloud SQL instance used in connection strings.

string

Name of the Cloud SQL instance. This does not include the project ID.

string

The geographical region. Can be: * us-central (FIRST_GEN instances only) * us-central1 (SECOND_GEN instances only) * asia-east1 or europe-west1.

Defaults to us-central or us-central1 depending on the instance type. The region cannot be changed after instance creation.

string

The Compute Engine zone that the instance is currently serving from. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary zone. WARNING: Changing this might restart the instance.

string

The Compute Engine zone that the failover instance is currently serving from for a regional instance. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary/failover zone.

object (DiskEncryptionConfiguration)

Disk encryption configuration specific to an instance.

object (DiskEncryptionStatus)

Disk encryption status specific to an instance.

string

Initial root password. Use only on creation. You must set root passwords before you can connect to PostgreSQL instances.

object (SqlScheduledMaintenance)

The start time of any upcoming scheduled maintenance for this instance.

boolean

This status indicates whether the instance satisfies PZS.

The status is reserved for future use.

string

Output only. Stores the current database version running on the instance including minor version such as MYSQL_8_0_18.

string (Timestamp format)

Output only. The time when the instance was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

string

Output only. instances.list all maintenance versions applicable on the instance

string

The current software version on the instance.

object (AvailableDatabaseVersion)

Output only. All database versions that are available for upgrade.

object (ReplicationCluster)

Optional. A primary instance and disaster recovery (DR) replica pair. A DR replica is a cross-region replica that you designate for failover in the event that the primary instance experiences regional failure. Applicable to MySQL and PostgreSQL.

boolean

Output only. This status indicates whether the instance satisfies PZI.

The status is reserved for future use.

object (PoolNodeConfig)

Output only. Entries containing information about each read pool node of the read pool.

object (DnsNameMapping)

Output only. The list of DNS names used by this instance.

object (SqlOutOfDiskReport)

This field represents the report generated by the proactive database wellness job for OutOfDisk issues. * Writers: * the proactive database wellness job for OOD. * Readers: * the proactive database wellness job

enum (SqlNetworkArchitecture)

string

Output only. The link to service attachment of PSC instance.

string

Output only. The dns name of the instance.

string

This item is deprecated!

Output only. DEPRECATED: please use writeEndpoint instead.

string

Output only. The dns name of the primary instance in a replication group.

object (GeminiInstanceConfig)

Gemini instance configuration.

integer

The number of read pool nodes in a read pool.

The current serving state of the database instance.

Deprecated

This item is deprecated!

Database instance settings.

{
  "settingsVersion": string,
  "authorizedGaeApplications": [
    string
  ],
  "tier": string,
  "kind": string,
  "userLabels": {
    string: string,
    ...
  },
  "availabilityType": enum (SqlAvailabilityType),
  "pricingPlan": enum (SqlPricingPlan),
  "replicationType": enum (SqlReplicationType),
  "storageAutoResizeLimit": string,
  "activationPolicy": enum (SqlActivationPolicy),
  "ipConfiguration": {
    object (IpConfiguration)
  },
  "storageAutoResize": boolean,
  "locationPreference": {
    object (LocationPreference)
  },
  "databaseFlags": [
    {
      object (DatabaseFlags)
    }
  ],
  "dataDiskType": enum (SqlDataDiskType),
  "maintenanceWindow": {
    object (MaintenanceWindow)
  },
  "backupConfiguration": {
    object (BackupConfiguration)
  },
  "databaseReplicationEnabled": boolean,
  "crashSafeReplicationEnabled": boolean,
  "dataDiskSizeGb": string,
  "activeDirectoryConfig": {
    object (SqlActiveDirectoryConfig)
  },
  "collation": string,
  "denyMaintenancePeriods": [
    {
      object (DenyMaintenancePeriod)
    }
  ],
  "insightsConfig": {
    object (InsightsConfig)
  },
  "passwordValidationPolicy": {
    object (PasswordValidationPolicy)
  },
  "sqlServerAuditConfig": {
    object (SqlServerAuditConfig)
  },
  "edition": enum (Edition),
  "connectorEnforcement": enum (ConnectorEnforcement),
  "deletionProtectionEnabled": boolean,
  "timeZone": string,
  "enableDataplexIntegration": boolean
  "connectionPoolConfig": {
  }
}

string (Int64Value format)

The version of instance settings. This is a required field for update method to make sure concurrent updates are handled properly. During update, use the most recent settingsVersion value for this instance and do not try to update this value.

string

This item is deprecated!

The App Engine app IDs that can access this instance. (Deprecated) Applied to First Generation instances only.

string

The tier (or machine type) for this instance, for example db-custom-1-3840. WARNING: Changing this restarts the instance.

string

This is always sql#settings.

map (key: string, value: string)

User-provided labels, represented as a dictionary where each label is a single key value pair.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.

enum (SqlAvailabilityType)

Availability type. Potential values: * ZONAL: The instance serves data from only one zone. Outages in that zone affect data accessibility. * REGIONAL: The instance can serve data from more than one zone in a region (it is highly available)./

For more information, see Overview of the High Availability Configuration.

enum (SqlPricingPlan)

The pricing plan for this instance. This can be either PER_USE or PACKAGE. Only PER_USE is supported for Second Generation instances.

enum (SqlReplicationType)

This item is deprecated!

The type of replication this instance uses. This can be either ASYNCHRONOUS or SYNCHRONOUS. (Deprecated) This property was only applicable to First Generation instances.

string (Int64Value format)

The maximum size to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.

enum (SqlActivationPolicy)

The activation policy specifies when the instance is activated; it is applicable only when the instance state is RUNNABLE. Valid values: * ALWAYS: The instance is on, and remains so even in the absence of connection requests. * NEVER: The instance is off; it is not activated, even if a connection request arrives.

object (IpConfiguration)

The settings for IP Management. This allows to enable or disable the instance IP and manage which external networks can connect to the instance. The IPv4 address cannot be disabled for Second Generation instances.

boolean

Configuration to increase storage size automatically. The default value is true.

object (LocationPreference)

The location preference settings. This allows the instance to be located as near as possible to either an App Engine app or Compute Engine zone for better performance. App Engine co-location was only applicable to First Generation instances.

object (DatabaseFlags)

The database flags passed to the instance at startup.

enum (SqlDataDiskType)

The type of data disk: PD_SSD (default) or PD_HDD. Not used for First Generation instances.

object (MaintenanceWindow)

The maintenance window for this instance. This specifies when the instance can be restarted for maintenance purposes.

object (BackupConfiguration)

The daily backup configuration for the instance.

boolean

Configuration specific to read replica instances. Indicates whether replication is enabled or not. WARNING: Changing this restarts the instance.

boolean

This item is deprecated!

Configuration specific to read replica instances. Indicates whether database flags for crash-safe replication are enabled. This property was only applicable to First Generation instances.

string (Int64Value format)

The size of data disk, in GB. The data disk size minimum is 10GB.

object (SqlActiveDirectoryConfig)

Active Directory configuration, relevant only for Cloud SQL for SQL Server.

string

The name of server Instance collation.

object (DenyMaintenancePeriod)

Deny maintenance periods

object (InsightsConfig)

Insights configuration, for now relevant only for Postgres.

object (PasswordValidationPolicy)

The local user password validation policy of the instance.

object (SqlServerAuditConfig)

SQL Server specific audit configuration.

enum (Edition)

Optional. The edition of the instance.

enum (ConnectorEnforcement)

Specifies if connections must use Cloud SQL connectors. Option values include the following: NOT_REQUIRED (Cloud SQL instances can be connected without Cloud SQL Connectors) and REQUIRED (Only allow connections that use Cloud SQL Connectors).

Note that using REQUIRED disables all existing authorized networks. If this field is not specified when creating a new instance, NOT_REQUIRED is used. If this field is not specified when patching or updating an existing instance, it is left unchanged in the instance.

boolean

Configuration to protect against accidental instance deletion.

string

Server timezone, relevant only for Cloud SQL for SQL Server.

boolean

Optional. When this parameter is set to true, Cloud SQL instances can connect to Vertex AI to pass requests for real-time predictions and insights to the AI. The default value is false. This applies only to Cloud SQL for MySQL and Cloud SQL for PostgreSQL instances.

boolean

Optional. By default, Cloud SQL instances have schema extraction disabled for Dataplex. When this parameter is set to true, schema extraction for Dataplex on Cloud SQL instances is activated.

boolean

Optional. When this parameter is set to true, Cloud SQL retains backups of the instance even after the instance is deleted. The ON_DEMAND backup will be retained until customer deletes the backup or the project. The AUTOMATED backup will be retained based on the backups retention setting.

object (ConnectionPoolConfig)

Optional. The managed connection pooling configuration for the instance.

The availability type of the given Cloud SQL instance.

The pricing plan for this instance.

Specifies when the instance is activated.

The instance starts upon receiving requests.

This item is deprecated!

IP Management configuration.

{
  "ipv4Enabled": boolean,
  "privateNetwork": string,
  "requireSsl": boolean,
  "authorizedNetworks": [
    {
      object (AclEntry)
    }
  ],
  "sslMode": enum (SslMode),
  "customSubjectAlternativeNames": [
    string
  ],
  "pscConfig": {
    object (PscConfig)
  },
  "serverCaMode": enum (CaMode),
  "serverCaPool": string
}

boolean

Whether the instance is assigned a public IP address or not.

string

The resource link for the VPC network from which the Cloud SQL instance is accessible for private IP. For example, /projects/myProject/global/networks/default. This setting can be updated, but it cannot be removed after it is set.

boolean

Use sslMode instead.

Whether SSL/TLS connections over IP are enforced. If set to false, then allow both non-SSL/non-TLS and SSL/TLS connections. For SSL/TLS connections, the client certificate won't be verified. If set to true, then only allow connections encrypted with SSL/TLS and with valid client certificates. If you want to enforce SSL/TLS without enforcing the requirement for valid client certificates, then use the sslMode flag instead of the requireSsl flag.

object (AclEntry)

The list of external networks that are allowed to connect to the instance using the IP. In 'CIDR' notation, also known as 'slash' notation (for example: 157.197.200.0/24).

string

The name of the allocated ip range for the private ip Cloud SQL 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])?.

enum (SslMode)

Specify how SSL/TLS is enforced in database connections. If you must use the requireSsl flag for backward compatibility, then only the following value pairs are valid:

For PostgreSQL and MySQL:

• sslMode=ALLOW_UNENCRYPTED_AND_ENCRYPTED and requireSsl=false
• sslMode=ENCRYPTED_ONLY and requireSsl=false
• sslMode=TRUSTED_CLIENT_CERTIFICATE_REQUIRED and requireSsl=true

For SQL Server:

• sslMode=ALLOW_UNENCRYPTED_AND_ENCRYPTED and requireSsl=false
• sslMode=ENCRYPTED_ONLY and requireSsl=true

The value of sslMode has priority over the value of requireSsl.

For example, for the pair sslMode=ENCRYPTED_ONLY and requireSsl=false, sslMode=ENCRYPTED_ONLY means accept only SSL connections, while requireSsl=false means accept both non-SSL and SSL connections. In this case, MySQL and PostgreSQL databases respect sslMode and accepts only SSL connections.

string

Optional. Custom Subject Alternative Name(SAN)s for a Cloud SQL instance.

object (PscConfig)

PSC settings for this instance.

enum (CaMode)

Specify what type of CA is used for the server certificate.

string

Optional. The resource name of the server CA pool for an instance with CUSTOMER_MANAGED_CAS_CA as the serverCaMode. Format: projects/{PROJECT}/locations/{REGION}/caPools/{POOL_ID}

An entry for an Access Control list.

{
  "value": string,
  "expirationTime": string,
  "name": string,
  "kind": string
}

string

The allowlisted value for the access control list.

string (Timestamp format)

The time when this access control entry expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

string

Optional. A label to identify this entry.

string

This is always sql#aclEntry.

The SSL options for database connections.

Allow non-SSL/non-TLS and SSL/TLS connections. For SSL connections to MySQL and PostgreSQL, the client certificate isn't verified.

When this value is used, the legacy requireSsl flag must be false or cleared to avoid a conflict between the values of the two flags.

Only allow connections encrypted with SSL/TLS. For SSL connections to MySQL and PostgreSQL, the client certificate isn't verified.

When this value is used, the legacy requireSsl flag must be false or cleared to avoid a conflict between the values of the two flags.

Only allow connections encrypted with SSL/TLS and with valid client certificates.

When this value is used, the legacy requireSsl flag must be true or cleared to avoid the conflict between values of two flags. PostgreSQL clients or users that connect using IAM database authentication must use either the Cloud SQL Auth Proxy or Cloud SQL Connectors to enforce client identity verification.

Only applicable to MySQL and PostgreSQL. Not applicable to SQL Server.

PSC settings for a Cloud SQL instance.

{
  "allowedConsumerProjects": [
    string
  ],
  "pscEnabled": boolean
}

string

The 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).

boolean

Whether PSC connectivity is enabled for this instance.

Various Certificate Authority (CA) modes for certificate signing.

Preferred location. This specifies where a Cloud SQL instance is located. Note that if the preferred location is not available, the instance will be located as close as possible within the region. Only one location may be specified.

{
  "followGaeApplication": string,
  "zone": string,
  "secondaryZone": string,
  "kind": string
}

string

This item is deprecated!

The App Engine application to follow, it must be in the same region as the Cloud SQL instance. WARNING: Changing this might restart the instance.

string

The preferred Compute Engine zone (for example: us-central1-a, us-central1-b, etc.). WARNING: Changing this might restart the instance.

string

The preferred Compute Engine zone for the secondary/failover (for example: us-central1-a, us-central1-b, etc.).

string

This is always sql#locationPreference.

Database flags for Cloud SQL instances.

{
  "name": string,
  "value": string
}

string

The name of the flag. These flags are passed at instance startup, so include both server options and system variables. Flags are specified with underscores, not hyphens. For more information, see Configuring Database Flags in the Cloud SQL documentation.

string

The value of the flag. Boolean flags are set to on for true and off for false. This field must be omitted if the flag doesn't take a value.

The type of disk that is used for a v2 instance to use.

This field is deprecated and will be removed from a future version of the API.

This item is deprecated!

Maintenance window. This specifies when a Cloud SQL instance is restarted for system maintenance purposes.

{
  "hour": integer,
  "day": integer,
  "updateTrack": enum (SqlUpdateTrack),
  "kind": string
}

integer

Hour of day - 0 to 23. Specify in the UTC time zone.

integer

Day of week - MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, or SUNDAY. Specify in the UTC time zone. Returned in output as an integer, 1 to 7, where 1 equals Monday.

enum (SqlUpdateTrack)

Maintenance timing settings: canary, stable, or week5. For more information, see About maintenance on Cloud SQL instances.

string

This is always sql#maintenanceWindow.

Database instance backup configuration.

{
  "startTime": string,
  "enabled": boolean,
  "kind": string,
  "binaryLogEnabled": boolean,
  "replicationLogArchivingEnabled": boolean,
  "location": string,
  "pointInTimeRecoveryEnabled": boolean,
  "backupRetentionSettings": {
    object (BackupRetentionSettings)
  },
  "transactionLogRetentionDays": integer,
  "transactionalLogStorageState": enum (TransactionalLogStorageState)
}

string

Start time for the daily backup configuration in UTC timezone in the 24 hour format - HH:MM.

boolean

Whether this configuration is enabled.

string

This is always sql#backupConfiguration.

boolean

(MySQL only) Whether binary log is enabled. If backup configuration is disabled, binarylog must be disabled as well.

boolean

Reserved for future use.

string

Location of the backup

boolean

Whether point in time recovery is enabled.

object (BackupRetentionSettings)

Backup retention settings.

integer

The number of days of transaction logs we retain for point in time restore, from 1-7.

enum (TransactionalLogStorageState)

Output only. This value contains the storage location of transactional logs used to perform point-in-time recovery (PITR) for the database.

We currently only support backup retention by specifying the number of backups we will retain.

{
  "retentionUnit": enum (RetentionUnit),
  "retainedBackups": integer
}

enum (RetentionUnit)

The unit that 'retainedBackups' represents.

integer

Depending on the value of retentionUnit, this is used to determine if a backup needs to be deleted. If retentionUnit is 'COUNT', we will retain this many backups.

The units that retainedBackups specifies, we only support COUNT.

This value contains the storage location of the transactional logs used to perform point-in-time recovery (PITR) for the database.

Active Directory configuration, relevant only for Cloud SQL for SQL Server.

{
  "kind": string,
  "domain": string
}

string

This is always sql#activeDirectoryConfig.

string

The name of the domain (e.g., mydomain.com).

Deny maintenance Periods. This specifies a date range during when all CSA rollout will be denied.

{
  "startDate": string,
  "endDate": string,
  "time": string
}

string

"deny maintenance period" start date. If the year of the start date is empty, the year of the end date also must be empty. In this case, it means the deny maintenance period recurs every year. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01

string

"deny maintenance period" end date. If the year of the end date is empty, the year of the start date also must be empty. In this case, it means the no maintenance interval recurs every year. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01

string

Time in UTC when the "deny maintenance period" starts on startDate and ends on endDate. The time is in format: HH:mm:SS, i.e., 00:00:00

Insights configuration. This specifies when Cloud SQL Insights feature is enabled and optional configuration.

{
  "queryInsightsEnabled": boolean,
  "recordClientAddress": boolean,
  "recordApplicationTags": boolean,
  "queryStringLength": integer,
  "queryPlansPerMinute": integer
}

boolean

Whether Query Insights feature is enabled.

boolean

Whether Query Insights will record client address when enabled.

boolean

Whether Query Insights will record application tags from query when enabled.

integer

Maximum query length stored in bytes. Default value: 1024 bytes. Range: 256-4500 bytes. Query length more than this field value will be truncated to this value. When unset, query length will be the default value. Changing query length will restart the database.

integer

Number of query execution plans captured by Insights per minute for all queries combined. Default is 5.

Database instance local user password validation policy

{
  "minLength": integer,
  "complexity": enum (Complexity),
  "reuseInterval": integer,
  "disallowUsernameSubstring": boolean,
  "passwordChangeInterval": string,
  "enablePasswordPolicy": boolean
}

integer

Minimum number of characters allowed.

enum (Complexity)

The complexity of the password.

integer

Number of previous passwords that cannot be reused.

boolean

Disallow username as a part of the password.

string (Duration format)

Minimum interval after which the password can be changed. This flag is only supported for PostgreSQL.

A duration in seconds with up to nine fractional digits, ending with 's'. Example: "3.5s".

boolean

Whether the password policy is enabled or not.

The complexity choices of the password.

SQL Server specific audit configuration.

{
  "kind": string,
  "bucket": string,
  "retentionInterval": string,
  "uploadInterval": string
}

string

This is always sql#sqlServerAuditConfig

string

The name of the destination bucket (e.g., gs://mybucket).

string (Duration format)

How long to keep generated audit files.

A duration in seconds with up to nine fractional digits, ending with 's'. Example: "3.5s".

string (Duration format)

How often to upload generated audit files.

A duration in seconds with up to nine fractional digits, ending with 's'. Example: "3.5s".

The edition of the instance, can be ENTERPRISE or ENTERPRISE_PLUS.

The options for enforcing Cloud SQL connectors in the instance.

The managed connection pooling configuration.

{
  "flags": [
    {
      object (ConnectionPoolFlags)
    }
  ],
  "connectionPoolingEnabled": boolean
}

object (ConnectionPoolFlags)

Optional. instances.list of connection pool configuration flags

boolean

Whether managed connection pooling is enabled.

Connection pool flags for Cloud SQL instances managed connection pool configuration.

{
  "name": string,
  "value": string
}

string

Required. The name of the flag.

string

Required. The value of the flag. Boolean flags are set to on for true and off for false. This field must be omitted if the flag doesn't take a value.

Database instance IP mapping

{
  "type": enum (SqlIpAddressType),
  "ipAddress": string,
  "timeToRetire": string
}

enum (SqlIpAddressType)

The type of this IP address. A PRIMARY address is a public address that can accept incoming connections. A PRIVATE address is a private address that can accept incoming connections. An OUTGOING address is the source address of connections originating from the instance, if supported.

string

The IP address assigned.

string (Timestamp format)

The due time for this IP to be retired in RFC 3339 format, for example 2012-11-15T16:19:00.094Z. This field is only available when the IP is scheduled to be retired.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

On-premises instance configuration.

{
  "hostPort": string,
  "kind": string,
  "username": string,
  "password": string,
  "caCertificate": string,
  "clientCertificate": string,
  "clientKey": string,
  "dumpFilePath": string,
  "sourceInstance": {
    object (InstanceReference)
  }
}

string

The host and port of the on-premises instance in host:port format

string

This is always sql#onPremisesConfiguration.

string

The username for connecting to on-premises instance.

string

The password for connecting to on-premises instance.

string

PEM representation of the trusted CA's x509 certificate.

string

PEM representation of the replica's x509 certificate.

string

PEM representation of the replica's private key. The corresponsing public key is encoded in the client's certificate.

string

The dump file to create the Cloud SQL replica.

object (InstanceReference)

The reference to Cloud SQL instance if the source is Cloud SQL.

object (SelectedObjects)

Optional. A list of objects that the user selects for replication from an external source instance.

Reference to another Cloud SQL instance.

{
  "name": string,
  "region": string,
  "project": string
}

string

The name of the Cloud SQL instance being referenced. This does not include the project ID.

string

The region of the Cloud SQL instance being referenced.

string

The project ID of the Cloud SQL instance being referenced. The default is the same project ID as the instance references it.

A list of objects that the user selects for replication from an external source instance.

{
  "database": string
}

string

Required. The name of the database to migrate.

Read-replica configuration for connecting to the primary instance.

{
  "kind": string,
  "mysqlReplicaConfiguration": {
    object (MySqlReplicaConfiguration)
  },
  "failoverTarget": boolean
}

string

This is always sql#replicaConfiguration.

object (MySqlReplicaConfiguration)

MySQL specific configuration when replicating from a MySQL on-premises primary instance. Replication configuration information such as the username, password, certificates, and keys are not stored in the instance metadata. The configuration information is used only to set up the replication connection and is stored by MySQL in a file named master.info in the data directory.

boolean

Specifies if the replica is the failover target. If the field is set to true, the replica will be designated as a failover replica. In case the primary instance fails, the replica instance will be promoted as the new primary instance. Only one replica can be specified as failover target, and the replica has to be in different zone with the primary instance.

Read-replica configuration specific to MySQL databases.

{
  "dumpFilePath": string,
  "username": string,
  "password": string,
  "connectRetryInterval": integer,
  "masterHeartbeatPeriod": string,
  "caCertificate": string,
  "clientCertificate": string,
  "clientKey": string,
  "sslCipher": string,
  "verifyServerCertificate": boolean,
  "kind": string
}

string

Path to a SQL dump file in Google Cloud Storage from which the replica instance is to be created. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported. Dumps have the binlog co-ordinates from which replication begins. This can be accomplished by setting --master-data to 1 when using mysqldump.

string

The username for the replication connection.

string

The password for the replication connection.

integer

Seconds to wait between connect retries. MySQL's default is 60 seconds.

string (Int64Value format)

Interval in milliseconds between replication heartbeats.

string

PEM representation of the trusted CA's x509 certificate.

string

PEM representation of the replica's x509 certificate.

string

PEM representation of the replica's private key. The corresponsing public key is encoded in the client's certificate.

string

A list of permissible ciphers to use for SSL encryption.

boolean

Whether or not to check the primary instance's Common Name value in the certificate that it sends during the SSL handshake.

string

This is always sql#mysqlReplicaConfiguration.

V1 speckle instance.

This item is deprecated!

The suspension reason of the database instance if the state is SUSPENDED.

Any scheduled maintenance for this instance.

{
  "startTime": string,
  "canDefer": boolean,
  "canReschedule": boolean,
  "scheduleDeadlineTime": string
}

string (Timestamp format)

The start time of any upcoming scheduled maintenance for this instance.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

boolean

This item is deprecated!

boolean

If the scheduled maintenance can be rescheduled.

string (Timestamp format)

Maintenance cannot be rescheduled to start beyond this deadline.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

This message wraps up the information written by out-of-disk detection job.

{
  "sqlOutOfDiskState": enum (SqlOutOfDiskState),
  "sqlMinRecommendedIncreaseSizeGb": integer
}

enum (SqlOutOfDiskState)

This field represents the state generated by the proactive database wellness job for OutOfDisk issues. * Writers: * the proactive database wellness job for OOD. * Readers: * the proactive database wellness job

integer

The minimum recommended increase size in GigaBytes This field is consumed by the frontend * Writers: * the proactive database wellness job for OOD. * Readers:

This enum lists all possible states regarding out-of-disk issues.

An available database version. It can be a major or a minor version.

{
  "majorVersion": string,
  "name": string,
  "displayName": string
}

string

The version's major version name.

string

The database version name. For MySQL 8.0, this string provides the database major and minor version.

string

The database version's display name.

The SQL network architecture for the instance.

A primary instance and disaster recovery (DR) replica pair. A DR replica is a cross-region replica that you designate for failover in the event that the primary instance experiences regional failure. Applicable to MySQL and PostgreSQL.

{
  "psaWriteEndpoint": string,
  "failoverDrReplicaName": string,
  "drReplica": boolean
}

string

Output only. If set, this field indicates this instance has a private service access (PSA) DNS endpoint that is pointing to the primary instance of the cluster. If this instance is the primary, then the DNS endpoint points to this instance. After a instances.switchover or replica failover operation, this DNS endpoint points to the promoted instance. This is a read-only field, returned to the user as information. This field can exist even if a standalone instance doesn't have a replica yet or the DR replica is deleted.

string

Optional. If the instance is a primary instance, then this field identifies the disaster recovery (DR) replica. A DR replica is an optional configuration for Enterprise Plus edition instances. If the instance is a read replica, then the field is not set. Set this field to a replica name to designate a DR replica for a primary instance. Remove the replica name to remove the DR replica designation.

boolean

Output only. Read-only field that indicates whether the replica is a DR replica. This field is not set if the instance is a primary instance.

Gemini instance configuration.

{
  "entitled": boolean,
  "googleVacuumMgmtEnabled": boolean,
  "oomSessionCancelEnabled": boolean,
  "activeQueryEnabled": boolean,
  "indexAdvisorEnabled": boolean,
}

boolean

Output only. Whether Gemini is enabled.

boolean

Output only. Whether the vacuum management is enabled.

boolean

Output only. Whether canceling the out-of-memory (OOM) session is enabled.

boolean

Output only. Whether the active query is enabled.

boolean

Output only. Whether the index advisor is enabled.

DNS metadata.

string

The DNS name.

enum (ConnectionType)

Output only. The connection type of the DNS name.

enum (DnsScope)

Output only. The scope that the DNS name applies to.

The connection type of the DNS name.

The scope that the DNS name applies to.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4