Update docs for 1.4.1 release
diff --git a/docs/dyn/sqladmin_v1beta4.instances.html b/docs/dyn/sqladmin_v1beta4.instances.html
index a493aae..734af62 100644
--- a/docs/dyn/sqladmin_v1beta4.instances.html
+++ b/docs/dyn/sqladmin_v1beta4.instances.html
@@ -165,7 +165,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -188,10 +188,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -233,7 +234,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -256,10 +257,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -325,7 +327,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -348,10 +350,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -378,10 +381,34 @@
An object of the form:
{ # A Cloud SQL instance resource.
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "kind": "sql#onPremisesConfiguration", # This is always sql#onPremisesConfiguration.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ },
"kind": "sql#instance", # This is always sql#instance.
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"ipv6Address": "A String", # The IPv6 address assigned to the instance.
+ "replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to read-replicas replicating from on-premises masters.
+ "kind": "sql#replicaConfiguration", # This is always sql#replicaConfiguration.
+ "mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises master. 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.
+ "username": "A String", # The username for the replication connection.
+ "kind": "sql#mysqlReplicaConfiguration", # This is always sql#mysqlReplicaConfiguration.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key is encoded in the client's certificate.
+ "sslCipher": "A String", # A list of permissible ciphers to use for SSL encryption.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "verifyServerCertificate": True or False, # Whether or not to check the master's Common Name value in the certificate that it sends during the SSL handshake.
+ "dumpFilePath": "A String", # Path to a SQL dump file in Google Cloud Storage from which the slave instance is to be created. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported. Dumps should have the binlog co-ordinates from which replication should begin. This can be accomplished by setting --master-data to 1 when using mysqldump.
+ "password": "A String", # The password for the replication connection.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ },
+ },
+ "replicaNames": [ # The replicas of the instance.
+ "A String",
+ ],
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
"serverCaCert": { # SslCerts Resource # SSL configuration.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"kind": "sql#sslCert", # This is always sql#sslCert.
@@ -391,17 +418,31 @@
"cert": "A String", # PEM representation.
"expirationTime": "A String", # The time when the certificate expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"createTime": "A String", # The time when the certificate was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z
- "selfLink": "A String",
+ "selfLink": "A String", # The URI of this resource.
},
- "replicaNames": [ # The replicas of the instance.
- "A String",
+ "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
+ "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
+ # RUNNABLE: The instance is running, or is ready to run when accessed.
+ # SUSPENDED: The instance is not available, for example due to problems with billing.
+ # PENDING_CREATE: The instance is being created.
+ # MAINTENANCE: The instance is down for maintenance.
+ # FAILED: The instance creation failed.
+ # UNKNOWN_STATE: The state of the instance is unknown.
+ "etag": "A String", # HTTP 1.1 Entity tag for the resource.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
+ "ipAddresses": [ # The assigned IP addresses for the instance.
+ { # Database instance IP Mapping.
+ "timeToRetire": "A String", # 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.
+ "ipAddress": "A String", # The IP address assigned.
+ },
],
- "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
+ "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"settings": { # Database instance settings. # The user settings.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # MySQL flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. Refer to the official MySQL documentation on server options and system variables for descriptions of what these flags do. Acceptable values are: character_set_server utf8 or utf8mb4 event_scheduler on or off (Note: The event scheduler will only work reliably if the instance activationPolicy is set to ALWAYS) general_log on or off group_concat_max_len 4..17179869184 innodb_flush_log_at_trx_commit 0..2 innodb_lock_wait_timeout 1..1073741824 log_bin_trust_function_creators on or off log_output Can be either TABLE or NONE, FILE is not supported log_queries_not_using_indexes on or off long_query_time 0..30000000 lower_case_table_names 0..2 max_allowed_packet 16384..1073741824 read_only on or off skip_show_database on or off slow_query_log on or off. If set to on, you must also set the log_output flag to TABLE to receive logs. wait_timeout 1..31536000
- "value": "A String", # The value of the flag. Booleans should be set using 1 for true, and 0 for false. This field must be omitted if the flag doesn't take a value.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. For more information, see Configuring MySQL Flags in the Google Cloud SQL documentation, as well as the official MySQL documentation for server options and system variables.
+ "value": "A String", # The value of the flag. Booleans should be set to on for true and off for false. This field must be omitted if the flag doesn't take a value.
},
],
"kind": "sql#settings", # This is always sql#settings.
@@ -430,9 +471,10 @@
},
],
},
+ "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
"databaseReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether replication is enabled or not.
"replicationType": "A String", # The type of replication this instance uses. This can be either ASYNCHRONOUS or SYNCHRONOUS.
- "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
+ "crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether database flags for crash-safe replication are enabled.
"pricingPlan": "A String", # The pricing plan for this instance. This can be either PER_USE or PACKAGE.
"settingsVersion": "A String", # 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.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should preferably be located, either in a specific Compute Engine zone, or co-located with an App Engine application. 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. # The location preference settings. This allows the instance to be located as near as possible to either an App Engine app or GCE zone for better performance.
@@ -441,25 +483,9 @@
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the Cloud SQL instance.
},
},
- "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
- "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
- # RUNNABLE: The instance is running, or is ready to run when accessed.
- # SUSPENDED: The instance is not available, for example due to problems with billing.
- # PENDING_CREATE: The instance is being created.
- # MAINTENANCE: The instance is down for maintenance.
- # UNKNOWN_STATE: The state of the instance is unknown.
- "etag": "A String", # HTTP 1.1 Entity tag for the resource.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
- "ipAddresses": [ # The assigned IP addresses for the instance.
- { # Database instance IP Mapping.
- "timeToRetire": "A String", # 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.
- "ipAddress": "A String", # The IP address assigned.
- },
- ],
- "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"instanceType": "A String", # The instance type. This can be one of the following.
# CLOUD_SQL_INSTANCE: A Cloud SQL instance that is not replicating from a master.
+ # ON_PREMISES_INSTANCE: An instance running on the customer's premises.
# READ_REPLICA_INSTANCE: A Cloud SQL instance configured as a read-replica.
"selfLink": "A String", # The URI of this resource.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -513,7 +539,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -536,10 +562,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -564,10 +591,34 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "kind": "sql#onPremisesConfiguration", # This is always sql#onPremisesConfiguration.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ },
"kind": "sql#instance", # This is always sql#instance.
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"ipv6Address": "A String", # The IPv6 address assigned to the instance.
+ "replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to read-replicas replicating from on-premises masters.
+ "kind": "sql#replicaConfiguration", # This is always sql#replicaConfiguration.
+ "mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises master. 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.
+ "username": "A String", # The username for the replication connection.
+ "kind": "sql#mysqlReplicaConfiguration", # This is always sql#mysqlReplicaConfiguration.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key is encoded in the client's certificate.
+ "sslCipher": "A String", # A list of permissible ciphers to use for SSL encryption.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "verifyServerCertificate": True or False, # Whether or not to check the master's Common Name value in the certificate that it sends during the SSL handshake.
+ "dumpFilePath": "A String", # Path to a SQL dump file in Google Cloud Storage from which the slave instance is to be created. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported. Dumps should have the binlog co-ordinates from which replication should begin. This can be accomplished by setting --master-data to 1 when using mysqldump.
+ "password": "A String", # The password for the replication connection.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ },
+ },
+ "replicaNames": [ # The replicas of the instance.
+ "A String",
+ ],
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
"serverCaCert": { # SslCerts Resource # SSL configuration.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"kind": "sql#sslCert", # This is always sql#sslCert.
@@ -577,17 +628,31 @@
"cert": "A String", # PEM representation.
"expirationTime": "A String", # The time when the certificate expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"createTime": "A String", # The time when the certificate was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z
- "selfLink": "A String",
+ "selfLink": "A String", # The URI of this resource.
},
- "replicaNames": [ # The replicas of the instance.
- "A String",
+ "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
+ "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
+ # RUNNABLE: The instance is running, or is ready to run when accessed.
+ # SUSPENDED: The instance is not available, for example due to problems with billing.
+ # PENDING_CREATE: The instance is being created.
+ # MAINTENANCE: The instance is down for maintenance.
+ # FAILED: The instance creation failed.
+ # UNKNOWN_STATE: The state of the instance is unknown.
+ "etag": "A String", # HTTP 1.1 Entity tag for the resource.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
+ "ipAddresses": [ # The assigned IP addresses for the instance.
+ { # Database instance IP Mapping.
+ "timeToRetire": "A String", # 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.
+ "ipAddress": "A String", # The IP address assigned.
+ },
],
- "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
+ "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"settings": { # Database instance settings. # The user settings.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # MySQL flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. Refer to the official MySQL documentation on server options and system variables for descriptions of what these flags do. Acceptable values are: character_set_server utf8 or utf8mb4 event_scheduler on or off (Note: The event scheduler will only work reliably if the instance activationPolicy is set to ALWAYS) general_log on or off group_concat_max_len 4..17179869184 innodb_flush_log_at_trx_commit 0..2 innodb_lock_wait_timeout 1..1073741824 log_bin_trust_function_creators on or off log_output Can be either TABLE or NONE, FILE is not supported log_queries_not_using_indexes on or off long_query_time 0..30000000 lower_case_table_names 0..2 max_allowed_packet 16384..1073741824 read_only on or off skip_show_database on or off slow_query_log on or off. If set to on, you must also set the log_output flag to TABLE to receive logs. wait_timeout 1..31536000
- "value": "A String", # The value of the flag. Booleans should be set using 1 for true, and 0 for false. This field must be omitted if the flag doesn't take a value.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. For more information, see Configuring MySQL Flags in the Google Cloud SQL documentation, as well as the official MySQL documentation for server options and system variables.
+ "value": "A String", # The value of the flag. Booleans should be set to on for true and off for false. This field must be omitted if the flag doesn't take a value.
},
],
"kind": "sql#settings", # This is always sql#settings.
@@ -616,9 +681,10 @@
},
],
},
+ "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
"databaseReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether replication is enabled or not.
"replicationType": "A String", # The type of replication this instance uses. This can be either ASYNCHRONOUS or SYNCHRONOUS.
- "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
+ "crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether database flags for crash-safe replication are enabled.
"pricingPlan": "A String", # The pricing plan for this instance. This can be either PER_USE or PACKAGE.
"settingsVersion": "A String", # 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.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should preferably be located, either in a specific Compute Engine zone, or co-located with an App Engine application. 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. # The location preference settings. This allows the instance to be located as near as possible to either an App Engine app or GCE zone for better performance.
@@ -627,25 +693,9 @@
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the Cloud SQL instance.
},
},
- "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
- "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
- # RUNNABLE: The instance is running, or is ready to run when accessed.
- # SUSPENDED: The instance is not available, for example due to problems with billing.
- # PENDING_CREATE: The instance is being created.
- # MAINTENANCE: The instance is down for maintenance.
- # UNKNOWN_STATE: The state of the instance is unknown.
- "etag": "A String", # HTTP 1.1 Entity tag for the resource.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
- "ipAddresses": [ # The assigned IP addresses for the instance.
- { # Database instance IP Mapping.
- "timeToRetire": "A String", # 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.
- "ipAddress": "A String", # The IP address assigned.
- },
- ],
- "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"instanceType": "A String", # The instance type. This can be one of the following.
# CLOUD_SQL_INSTANCE: A Cloud SQL instance that is not replicating from a master.
+ # ON_PREMISES_INSTANCE: An instance running on the customer's premises.
# READ_REPLICA_INSTANCE: A Cloud SQL instance configured as a read-replica.
"selfLink": "A String", # The URI of this resource.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -671,7 +721,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -694,10 +744,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -728,10 +779,34 @@
"nextPageToken": "A String", # The continuation token, used to page through large result sets. Provide this value in a subsequent request to return the next page of results.
"items": [ # List of database instance resources.
{ # A Cloud SQL instance resource.
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "kind": "sql#onPremisesConfiguration", # This is always sql#onPremisesConfiguration.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ },
"kind": "sql#instance", # This is always sql#instance.
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"ipv6Address": "A String", # The IPv6 address assigned to the instance.
+ "replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to read-replicas replicating from on-premises masters.
+ "kind": "sql#replicaConfiguration", # This is always sql#replicaConfiguration.
+ "mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises master. 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.
+ "username": "A String", # The username for the replication connection.
+ "kind": "sql#mysqlReplicaConfiguration", # This is always sql#mysqlReplicaConfiguration.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key is encoded in the client's certificate.
+ "sslCipher": "A String", # A list of permissible ciphers to use for SSL encryption.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "verifyServerCertificate": True or False, # Whether or not to check the master's Common Name value in the certificate that it sends during the SSL handshake.
+ "dumpFilePath": "A String", # Path to a SQL dump file in Google Cloud Storage from which the slave instance is to be created. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported. Dumps should have the binlog co-ordinates from which replication should begin. This can be accomplished by setting --master-data to 1 when using mysqldump.
+ "password": "A String", # The password for the replication connection.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ },
+ },
+ "replicaNames": [ # The replicas of the instance.
+ "A String",
+ ],
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
"serverCaCert": { # SslCerts Resource # SSL configuration.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"kind": "sql#sslCert", # This is always sql#sslCert.
@@ -741,17 +816,31 @@
"cert": "A String", # PEM representation.
"expirationTime": "A String", # The time when the certificate expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"createTime": "A String", # The time when the certificate was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z
- "selfLink": "A String",
+ "selfLink": "A String", # The URI of this resource.
},
- "replicaNames": [ # The replicas of the instance.
- "A String",
+ "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
+ "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
+ # RUNNABLE: The instance is running, or is ready to run when accessed.
+ # SUSPENDED: The instance is not available, for example due to problems with billing.
+ # PENDING_CREATE: The instance is being created.
+ # MAINTENANCE: The instance is down for maintenance.
+ # FAILED: The instance creation failed.
+ # UNKNOWN_STATE: The state of the instance is unknown.
+ "etag": "A String", # HTTP 1.1 Entity tag for the resource.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
+ "ipAddresses": [ # The assigned IP addresses for the instance.
+ { # Database instance IP Mapping.
+ "timeToRetire": "A String", # 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.
+ "ipAddress": "A String", # The IP address assigned.
+ },
],
- "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
+ "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"settings": { # Database instance settings. # The user settings.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # MySQL flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. Refer to the official MySQL documentation on server options and system variables for descriptions of what these flags do. Acceptable values are: character_set_server utf8 or utf8mb4 event_scheduler on or off (Note: The event scheduler will only work reliably if the instance activationPolicy is set to ALWAYS) general_log on or off group_concat_max_len 4..17179869184 innodb_flush_log_at_trx_commit 0..2 innodb_lock_wait_timeout 1..1073741824 log_bin_trust_function_creators on or off log_output Can be either TABLE or NONE, FILE is not supported log_queries_not_using_indexes on or off long_query_time 0..30000000 lower_case_table_names 0..2 max_allowed_packet 16384..1073741824 read_only on or off skip_show_database on or off slow_query_log on or off. If set to on, you must also set the log_output flag to TABLE to receive logs. wait_timeout 1..31536000
- "value": "A String", # The value of the flag. Booleans should be set using 1 for true, and 0 for false. This field must be omitted if the flag doesn't take a value.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. For more information, see Configuring MySQL Flags in the Google Cloud SQL documentation, as well as the official MySQL documentation for server options and system variables.
+ "value": "A String", # The value of the flag. Booleans should be set to on for true and off for false. This field must be omitted if the flag doesn't take a value.
},
],
"kind": "sql#settings", # This is always sql#settings.
@@ -780,9 +869,10 @@
},
],
},
+ "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
"databaseReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether replication is enabled or not.
"replicationType": "A String", # The type of replication this instance uses. This can be either ASYNCHRONOUS or SYNCHRONOUS.
- "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
+ "crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether database flags for crash-safe replication are enabled.
"pricingPlan": "A String", # The pricing plan for this instance. This can be either PER_USE or PACKAGE.
"settingsVersion": "A String", # 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.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should preferably be located, either in a specific Compute Engine zone, or co-located with an App Engine application. 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. # The location preference settings. This allows the instance to be located as near as possible to either an App Engine app or GCE zone for better performance.
@@ -791,25 +881,9 @@
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the Cloud SQL instance.
},
},
- "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
- "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
- # RUNNABLE: The instance is running, or is ready to run when accessed.
- # SUSPENDED: The instance is not available, for example due to problems with billing.
- # PENDING_CREATE: The instance is being created.
- # MAINTENANCE: The instance is down for maintenance.
- # UNKNOWN_STATE: The state of the instance is unknown.
- "etag": "A String", # HTTP 1.1 Entity tag for the resource.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
- "ipAddresses": [ # The assigned IP addresses for the instance.
- { # Database instance IP Mapping.
- "timeToRetire": "A String", # 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.
- "ipAddress": "A String", # The IP address assigned.
- },
- ],
- "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"instanceType": "A String", # The instance type. This can be one of the following.
# CLOUD_SQL_INSTANCE: A Cloud SQL instance that is not replicating from a master.
+ # ON_PREMISES_INSTANCE: An instance running on the customer's premises.
# READ_REPLICA_INSTANCE: A Cloud SQL instance configured as a read-replica.
"selfLink": "A String", # The URI of this resource.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -844,10 +918,34 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "kind": "sql#onPremisesConfiguration", # This is always sql#onPremisesConfiguration.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ },
"kind": "sql#instance", # This is always sql#instance.
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"ipv6Address": "A String", # The IPv6 address assigned to the instance.
+ "replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to read-replicas replicating from on-premises masters.
+ "kind": "sql#replicaConfiguration", # This is always sql#replicaConfiguration.
+ "mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises master. 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.
+ "username": "A String", # The username for the replication connection.
+ "kind": "sql#mysqlReplicaConfiguration", # This is always sql#mysqlReplicaConfiguration.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key is encoded in the client's certificate.
+ "sslCipher": "A String", # A list of permissible ciphers to use for SSL encryption.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "verifyServerCertificate": True or False, # Whether or not to check the master's Common Name value in the certificate that it sends during the SSL handshake.
+ "dumpFilePath": "A String", # Path to a SQL dump file in Google Cloud Storage from which the slave instance is to be created. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported. Dumps should have the binlog co-ordinates from which replication should begin. This can be accomplished by setting --master-data to 1 when using mysqldump.
+ "password": "A String", # The password for the replication connection.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ },
+ },
+ "replicaNames": [ # The replicas of the instance.
+ "A String",
+ ],
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
"serverCaCert": { # SslCerts Resource # SSL configuration.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"kind": "sql#sslCert", # This is always sql#sslCert.
@@ -857,17 +955,31 @@
"cert": "A String", # PEM representation.
"expirationTime": "A String", # The time when the certificate expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"createTime": "A String", # The time when the certificate was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z
- "selfLink": "A String",
+ "selfLink": "A String", # The URI of this resource.
},
- "replicaNames": [ # The replicas of the instance.
- "A String",
+ "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
+ "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
+ # RUNNABLE: The instance is running, or is ready to run when accessed.
+ # SUSPENDED: The instance is not available, for example due to problems with billing.
+ # PENDING_CREATE: The instance is being created.
+ # MAINTENANCE: The instance is down for maintenance.
+ # FAILED: The instance creation failed.
+ # UNKNOWN_STATE: The state of the instance is unknown.
+ "etag": "A String", # HTTP 1.1 Entity tag for the resource.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
+ "ipAddresses": [ # The assigned IP addresses for the instance.
+ { # Database instance IP Mapping.
+ "timeToRetire": "A String", # 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.
+ "ipAddress": "A String", # The IP address assigned.
+ },
],
- "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
+ "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"settings": { # Database instance settings. # The user settings.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # MySQL flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. Refer to the official MySQL documentation on server options and system variables for descriptions of what these flags do. Acceptable values are: character_set_server utf8 or utf8mb4 event_scheduler on or off (Note: The event scheduler will only work reliably if the instance activationPolicy is set to ALWAYS) general_log on or off group_concat_max_len 4..17179869184 innodb_flush_log_at_trx_commit 0..2 innodb_lock_wait_timeout 1..1073741824 log_bin_trust_function_creators on or off log_output Can be either TABLE or NONE, FILE is not supported log_queries_not_using_indexes on or off long_query_time 0..30000000 lower_case_table_names 0..2 max_allowed_packet 16384..1073741824 read_only on or off skip_show_database on or off slow_query_log on or off. If set to on, you must also set the log_output flag to TABLE to receive logs. wait_timeout 1..31536000
- "value": "A String", # The value of the flag. Booleans should be set using 1 for true, and 0 for false. This field must be omitted if the flag doesn't take a value.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. For more information, see Configuring MySQL Flags in the Google Cloud SQL documentation, as well as the official MySQL documentation for server options and system variables.
+ "value": "A String", # The value of the flag. Booleans should be set to on for true and off for false. This field must be omitted if the flag doesn't take a value.
},
],
"kind": "sql#settings", # This is always sql#settings.
@@ -896,9 +1008,10 @@
},
],
},
+ "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
"databaseReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether replication is enabled or not.
"replicationType": "A String", # The type of replication this instance uses. This can be either ASYNCHRONOUS or SYNCHRONOUS.
- "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
+ "crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether database flags for crash-safe replication are enabled.
"pricingPlan": "A String", # The pricing plan for this instance. This can be either PER_USE or PACKAGE.
"settingsVersion": "A String", # 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.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should preferably be located, either in a specific Compute Engine zone, or co-located with an App Engine application. 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. # The location preference settings. This allows the instance to be located as near as possible to either an App Engine app or GCE zone for better performance.
@@ -907,25 +1020,9 @@
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the Cloud SQL instance.
},
},
- "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
- "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
- # RUNNABLE: The instance is running, or is ready to run when accessed.
- # SUSPENDED: The instance is not available, for example due to problems with billing.
- # PENDING_CREATE: The instance is being created.
- # MAINTENANCE: The instance is down for maintenance.
- # UNKNOWN_STATE: The state of the instance is unknown.
- "etag": "A String", # HTTP 1.1 Entity tag for the resource.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
- "ipAddresses": [ # The assigned IP addresses for the instance.
- { # Database instance IP Mapping.
- "timeToRetire": "A String", # 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.
- "ipAddress": "A String", # The IP address assigned.
- },
- ],
- "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"instanceType": "A String", # The instance type. This can be one of the following.
# CLOUD_SQL_INSTANCE: A Cloud SQL instance that is not replicating from a master.
+ # ON_PREMISES_INSTANCE: An instance running on the customer's premises.
# READ_REPLICA_INSTANCE: A Cloud SQL instance configured as a read-replica.
"selfLink": "A String", # The URI of this resource.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -951,7 +1048,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -974,10 +1071,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -1019,7 +1117,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -1042,10 +1140,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -1087,7 +1186,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -1110,10 +1209,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -1155,7 +1255,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -1178,10 +1278,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -1208,6 +1309,7 @@
{ # Database instance restore backup request.
"restoreBackupContext": { # Database instance restore from backup context. # Parameters required to perform the restore backup operation.
+ "instanceId": "A String", # The ID of the instance that the backup was taken from.
"kind": "sql#restoreBackupContext", # This is always sql#restoreBackupContext.
"backupRunId": "A String", # The ID of the backup run to restore from.
},
@@ -1233,7 +1335,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -1256,10 +1358,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -1301,7 +1404,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -1324,10 +1427,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -1369,7 +1473,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -1392,10 +1496,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.
@@ -1421,10 +1526,34 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "kind": "sql#onPremisesConfiguration", # This is always sql#onPremisesConfiguration.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ },
"kind": "sql#instance", # This is always sql#instance.
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"ipv6Address": "A String", # The IPv6 address assigned to the instance.
+ "replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to read-replicas replicating from on-premises masters.
+ "kind": "sql#replicaConfiguration", # This is always sql#replicaConfiguration.
+ "mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises master. 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.
+ "username": "A String", # The username for the replication connection.
+ "kind": "sql#mysqlReplicaConfiguration", # This is always sql#mysqlReplicaConfiguration.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key is encoded in the client's certificate.
+ "sslCipher": "A String", # A list of permissible ciphers to use for SSL encryption.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "verifyServerCertificate": True or False, # Whether or not to check the master's Common Name value in the certificate that it sends during the SSL handshake.
+ "dumpFilePath": "A String", # Path to a SQL dump file in Google Cloud Storage from which the slave instance is to be created. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported. Dumps should have the binlog co-ordinates from which replication should begin. This can be accomplished by setting --master-data to 1 when using mysqldump.
+ "password": "A String", # The password for the replication connection.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ },
+ },
+ "replicaNames": [ # The replicas of the instance.
+ "A String",
+ ],
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.
+ "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
"serverCaCert": { # SslCerts Resource # SSL configuration.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"kind": "sql#sslCert", # This is always sql#sslCert.
@@ -1434,17 +1563,31 @@
"cert": "A String", # PEM representation.
"expirationTime": "A String", # The time when the certificate expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"createTime": "A String", # The time when the certificate was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z
- "selfLink": "A String",
+ "selfLink": "A String", # The URI of this resource.
},
- "replicaNames": [ # The replicas of the instance.
- "A String",
+ "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
+ "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
+ # RUNNABLE: The instance is running, or is ready to run when accessed.
+ # SUSPENDED: The instance is not available, for example due to problems with billing.
+ # PENDING_CREATE: The instance is being created.
+ # MAINTENANCE: The instance is down for maintenance.
+ # FAILED: The instance creation failed.
+ # UNKNOWN_STATE: The state of the instance is unknown.
+ "etag": "A String", # HTTP 1.1 Entity tag for the resource.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
+ "ipAddresses": [ # The assigned IP addresses for the instance.
+ { # Database instance IP Mapping.
+ "timeToRetire": "A String", # 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.
+ "ipAddress": "A String", # The IP address assigned.
+ },
],
- "region": "A String", # The geographical region. Can be us-central, asia-east1 or europe-west1. Defaults to us-central. The region can not be changed after instance creation.
+ "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"settings": { # Database instance settings. # The user settings.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # MySQL flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. Refer to the official MySQL documentation on server options and system variables for descriptions of what these flags do. Acceptable values are: character_set_server utf8 or utf8mb4 event_scheduler on or off (Note: The event scheduler will only work reliably if the instance activationPolicy is set to ALWAYS) general_log on or off group_concat_max_len 4..17179869184 innodb_flush_log_at_trx_commit 0..2 innodb_lock_wait_timeout 1..1073741824 log_bin_trust_function_creators on or off log_output Can be either TABLE or NONE, FILE is not supported log_queries_not_using_indexes on or off long_query_time 0..30000000 lower_case_table_names 0..2 max_allowed_packet 16384..1073741824 read_only on or off skip_show_database on or off slow_query_log on or off. If set to on, you must also set the log_output flag to TABLE to receive logs. wait_timeout 1..31536000
- "value": "A String", # The value of the flag. Booleans should be set using 1 for true, and 0 for false. This field must be omitted if the flag doesn't take a value.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so include both MySQL server options and MySQL system variables. Flags should be specified with underscores, not hyphens. For more information, see Configuring MySQL Flags in the Google Cloud SQL documentation, as well as the official MySQL documentation for server options and system variables.
+ "value": "A String", # The value of the flag. Booleans should be set to on for true and off for false. This field must be omitted if the flag doesn't take a value.
},
],
"kind": "sql#settings", # This is always sql#settings.
@@ -1473,9 +1616,10 @@
},
],
},
+ "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
"databaseReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether replication is enabled or not.
"replicationType": "A String", # The type of replication this instance uses. This can be either ASYNCHRONOUS or SYNCHRONOUS.
- "tier": "A String", # The tier of service for this instance, for example D1, D2. For more information, see pricing.
+ "crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether database flags for crash-safe replication are enabled.
"pricingPlan": "A String", # The pricing plan for this instance. This can be either PER_USE or PACKAGE.
"settingsVersion": "A String", # 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.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should preferably be located, either in a specific Compute Engine zone, or co-located with an App Engine application. 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. # The location preference settings. This allows the instance to be located as near as possible to either an App Engine app or GCE zone for better performance.
@@ -1484,25 +1628,9 @@
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the Cloud SQL instance.
},
},
- "masterInstanceName": "A String", # The name of the instance which will act as master in the replication setup.
- "currentDiskSize": "A String", # The current disk usage of the instance in bytes.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the following.
- # RUNNABLE: The instance is running, or is ready to run when accessed.
- # SUSPENDED: The instance is not available, for example due to problems with billing.
- # PENDING_CREATE: The instance is being created.
- # MAINTENANCE: The instance is down for maintenance.
- # UNKNOWN_STATE: The state of the instance is unknown.
- "etag": "A String", # HTTP 1.1 Entity tag for the resource.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance.
- "ipAddresses": [ # The assigned IP addresses for the instance.
- { # Database instance IP Mapping.
- "timeToRetire": "A String", # 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.
- "ipAddress": "A String", # The IP address assigned.
- },
- ],
- "databaseVersion": "A String", # The database engine type and version. Can be MYSQL_5_5 or MYSQL_5_6. Defaults to MYSQL_5_5. The databaseVersion can not be changed after instance creation.
"instanceType": "A String", # The instance type. This can be one of the following.
# CLOUD_SQL_INSTANCE: A Cloud SQL instance that is not replicating from a master.
+ # ON_PREMISES_INSTANCE: An instance running on the customer's premises.
# READ_REPLICA_INSTANCE: A Cloud SQL instance configured as a read-replica.
"selfLink": "A String", # The URI of this resource.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -1528,7 +1656,7 @@
],
},
},
- "kind": "sql#operation", # This is always sql#instanceOperation.
+ "kind": "sql#operation", # This is always sql#operation.
"name": "A String", # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
"kind": "sql#exportContext", # This is always sql#exportContext.
@@ -1551,10 +1679,11 @@
"startTime": "A String", # The time this operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"targetId": "A String", # Name of the database instance related to this operation.
- "operationType": "A String", # TODO(b/18431310): update this list to reflect current values. The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME.
+ "operationType": "A String", # The type of the operation. Valid values are CREATE, DELETE, UPDATE, RESTART, IMPORT, EXPORT, BACKUP_VOLUME, RESTORE_VOLUME, CREATE_USER, DELETE_USER, CREATE_DATABASE, DELETE_DATABASE .
"targetLink": "A String", # The URI of the instance related to the operation.
"insertTime": "A String", # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
- "error": { # If errors occurred during processing of this operation, this field will be populated.
+ "error": { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
+ "kind": "sql#operationErrors", # This is always sql#operationErrors.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
"kind": "sql#operationError", # This is always sql#operationError.