docs: update docs (#916)
* fix: re-run script
* test: fix noxfile
diff --git a/docs/dyn/sqladmin_v1beta4.instances.html b/docs/dyn/sqladmin_v1beta4.instances.html
index 6464436..6d3ed1c 100644
--- a/docs/dyn/sqladmin_v1beta4.instances.html
+++ b/docs/dyn/sqladmin_v1beta4.instances.html
@@ -102,7 +102,7 @@
<code><a href="#insert">insert(project, body=None, x__xgafv=None)</a></code></p>
<p class="firstline">Creates a new Cloud SQL instance.</p>
<p class="toc_element">
- <code><a href="#list">list(project, filter=None, pageToken=None, maxResults=None, x__xgafv=None)</a></code></p>
+ <code><a href="#list">list(project, pageToken=None, maxResults=None, filter=None, x__xgafv=None)</a></code></p>
<p class="firstline">Lists instances under a given project.</p>
<p class="toc_element">
<code><a href="#listServerCas">listServerCas(project, instance, x__xgafv=None)</a></code></p>
@@ -163,18 +163,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -195,14 +183,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -211,13 +191,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -227,6 +207,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -235,6 +223,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -263,20 +263,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -294,17 +294,17 @@
{ # Database instance clone request.
"cloneContext": { # Database instance clone context. # Contains details about the clone operation.
- "kind": "A String", # This is always <code>sql#cloneContext</code>.
"pointInTime": "A String", # Reserved for future use.
"destinationInstanceName": "A String", # Name of the Cloud SQL instance to be created as a clone.
"pitrTimestampMs": "A String", # Reserved for future use.
"binLogCoordinates": { # Binary log coordinates. # Binary log coordinates, if specified, identify the position up to which the
# source instance should be cloned. If not specified, the source instance is
# cloned up to the most recent binary log coordinates.
- "kind": "A String", # This is always <code>sql#binLogCoordinates</code>.
"binLogFileName": "A String", # Name of the binary log file for a Cloud SQL instance.
"binLogPosition": "A String", # Position (offset) within the binary log file.
+ "kind": "A String", # This is always <code>sql#binLogCoordinates</code>.
},
+ "kind": "A String", # This is always <code>sql#cloneContext</code>.
},
}
@@ -319,18 +319,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -351,14 +339,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -367,13 +347,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -383,6 +363,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -391,6 +379,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -419,20 +419,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -454,18 +454,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -486,14 +474,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -502,13 +482,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -518,6 +498,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -526,6 +514,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -554,20 +554,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -586,7 +586,6 @@
"demoteMasterContext": { # Database instance demote master context. # Contains details about the demoteMaster operation.
"replicaConfiguration": { # Read-replica configuration for connecting to the on-premises master. # Configuration specific to read-replicas replicating from the on-premises
# master.
- "kind": "A String", # This is always <code>sql#demoteMasterConfiguration</code>.
"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.
@@ -602,6 +601,7 @@
"username": "A String", # The username for the replication connection.
"caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
},
+ "kind": "A String", # This is always <code>sql#demoteMasterConfiguration</code>.
},
"kind": "A String", # This is always <code>sql#demoteMasterContext</code>.
"masterInstanceName": "A String", # The name of the instance which will act as on-premises master in the
@@ -627,18 +627,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -659,14 +647,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -675,13 +655,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -691,6 +671,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -699,6 +687,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -727,20 +727,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -757,6 +757,18 @@
{ # Database instance export request.
"exportContext": { # Database instance export context. # Contains details about the export operation.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -785,18 +797,6 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
}
@@ -811,18 +811,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -843,14 +831,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -859,13 +839,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -875,6 +855,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -883,6 +871,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -911,20 +911,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -958,18 +958,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -990,14 +978,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1006,13 +986,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -1022,6 +1002,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -1030,6 +1018,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -1058,20 +1058,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -1091,69 +1091,31 @@
An object of the form:
{ # A Cloud SQL instance resource.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
+ "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
+ # field can not be changed after instance creation. MySQL Second Generation
+ # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
+ # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
+ # <code>POSTGRES_11 Beta</code> MySQL First Generation
+ # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
"suspensionReason": [ # If the instance state is SUSPENDED, the reason for the suspension.
"A String",
],
"settings": { # Database instance settings. # The user settings.
- "ipConfiguration": { # IP Management configuration. # 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.
- "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
- "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
- # using the IP. In <a
- # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
- # notation</a>, also known as 'slash' notation (e.g.
- # <code>192.168.100.0/24</code>).
- { # An entry for an Access Control list.
- "name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
- "value": "A String", # The whitelisted value for the access control list.
- "expirationTime": "A String", # The time when this access control entry expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- },
- ],
- },
- "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
- # <br><code>ZONAL</code>: The instance serves data from only one zone.
- # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
- # The instance can serve data from more than one zone in a region (it is
- # highly available). <br>For more information, see <a
- # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
- # of the High Availability Configuration</a>.
- "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.
- "databaseFlags": [ # The database flags passed to the instance at startup.
- { # Database flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so
- # include both server options and system variables for MySQL. Flags should be
- # specified with underscores, not hyphens. For more information, see <a
- # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
- # SQL documentation.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
- },
- ],
- "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
- # can be restarted for maintenance purposes. Not used for First Generation
- # instances.
- # preferably be restarted for system maintenance purposes.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
- "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
- # <code>stable</code> (Later). <br /><a
- # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
- # Learn more</a>.
- },
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
# Generation instances.
@@ -1182,8 +1144,6 @@
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
"backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
"replicationLogArchivingEnabled": True or False, # Reserved for future use.
"location": "A String", # Location of the backup
"pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
@@ -1191,11 +1151,17 @@
# hour format - <code>HH:MM</code>.
"kind": "A String", # This is always <code>sql#backupConfiguration</code>.
"enabled": True or False, # Whether this configuration is enabled.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
},
"userLabels": { # User-provided labels, represented as a dictionary where each label is a
# single key value pair.
"a_key": "A String",
},
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "kind": "A String", # This is always <code>sql#settings</code>.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # 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 is only applicable to First
@@ -1204,16 +1170,12 @@
# 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.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
"zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
# etc.).
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
# Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
},
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
"activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
# applicable only when the instance state is <code>RUNNABLE</code>. Valid
# values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
@@ -1224,6 +1186,65 @@
# Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
# inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
# 12 hours of inactivity.
+ "databaseFlags": [ # The database flags passed to the instance at startup.
+ { # Database flags for Cloud SQL instances.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so
+ # include both server options and system variables for MySQL. Flags should be
+ # specified with underscores, not hyphens. For more information, see <a
+ # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
+ # SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
+ },
+ ],
+ "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.
+ "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
+ # <br><code>ZONAL</code>: The instance serves data from only one zone.
+ # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
+ # The instance can serve data from more than one zone in a region (it is
+ # highly available). <br>For more information, see <a
+ # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
+ # of the High Availability Configuration</a>.
+ "ipConfiguration": { # IP Management configuration. # 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.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
+ "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
+ # using the IP. In <a
+ # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
+ # notation</a>, also known as 'slash' notation (e.g.
+ # <code>192.168.100.0/24</code>).
+ { # An entry for an Access Control list.
+ "value": "A String", # The whitelisted value for the access control list.
+ "expirationTime": "A String", # The time when this access control entry expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "name": "A String", # Optional. A label to identify this entry.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
+ },
+ ],
+ "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ },
+ "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
+ # can be restarted for maintenance purposes. Not used for First Generation
+ # instances.
+ # preferably be restarted for system maintenance purposes.
+ "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
+ # <code>stable</code> (Later). <br /><a
+ # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
+ # Learn more</a>.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
+ },
},
"replicaNames": [ # The replicas of the instance.
"A String",
@@ -1233,15 +1254,18 @@
"kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
},
+ "etag": "A String", # This field is deprecated and will be removed from a future version of the
+ # API. Use the <code>settings.settingsVersion</code> field instead.
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
- "etag": "A String", # This field is deprecated and will be removed from a future version of the
- # API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
+ "expirationTime": "A String", # The time when the certificate expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"sha1Fingerprint": "A String", # Sha1 Fingerprint.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"cert": "A String", # PEM representation.
@@ -1252,9 +1276,6 @@
# <code>2012-11-15T16:19:00.094Z</code>
"instance": "A String", # Name of the database instance.
"selfLink": "A String", # The URI of this resource.
- "expirationTime": "A String", # The time when the certificate expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
},
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -1275,6 +1296,31 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
+ "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 <code>master.info</code>
+ # in the data directory.
+ "password": "A String", # The password for the replication connection.
+ "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.
+ "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.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "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.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for the replication connection.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
+ },
"failoverTarget": True or False, # Specifies if the replica is the failover target. If the field is set to
# <code>true</code> the replica will be designated as a failover replica. In
# case the master instance fails, the replica instance will be promoted as
@@ -1282,31 +1328,6 @@
# target, and the replica has to be in different zone with the master
# instance.
"kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
- "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 <code>master.info</code>
- # in the data directory.
- "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.
- "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
- "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
- "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.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for the replication connection.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
- "password": "A String", # The password for the replication connection.
- "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.
- },
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
@@ -1363,27 +1384,6 @@
# managed by Google. <br>This property is read-only; use the
# <code>tier</code> property in the <code>settings</code> object to determine
# the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
- "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
- # field can not be changed after instance creation. MySQL Second Generation
- # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
- # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
- # <code>POSTGRES_11 Beta</code> MySQL First Generation
- # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
}</pre>
</div>
@@ -1400,14 +1400,6 @@
{ # Database instance import request.
"importContext": { # Database instance import context. # Contains details about the import operation.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1416,13 +1408,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -1432,6 +1424,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
}
@@ -1446,18 +1446,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -1478,14 +1466,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1494,13 +1474,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -1510,6 +1490,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -1518,6 +1506,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -1546,20 +1546,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -1574,69 +1574,31 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
+ "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
+ # field can not be changed after instance creation. MySQL Second Generation
+ # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
+ # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
+ # <code>POSTGRES_11 Beta</code> MySQL First Generation
+ # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
"suspensionReason": [ # If the instance state is SUSPENDED, the reason for the suspension.
"A String",
],
"settings": { # Database instance settings. # The user settings.
- "ipConfiguration": { # IP Management configuration. # 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.
- "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
- "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
- # using the IP. In <a
- # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
- # notation</a>, also known as 'slash' notation (e.g.
- # <code>192.168.100.0/24</code>).
- { # An entry for an Access Control list.
- "name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
- "value": "A String", # The whitelisted value for the access control list.
- "expirationTime": "A String", # The time when this access control entry expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- },
- ],
- },
- "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
- # <br><code>ZONAL</code>: The instance serves data from only one zone.
- # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
- # The instance can serve data from more than one zone in a region (it is
- # highly available). <br>For more information, see <a
- # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
- # of the High Availability Configuration</a>.
- "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.
- "databaseFlags": [ # The database flags passed to the instance at startup.
- { # Database flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so
- # include both server options and system variables for MySQL. Flags should be
- # specified with underscores, not hyphens. For more information, see <a
- # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
- # SQL documentation.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
- },
- ],
- "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
- # can be restarted for maintenance purposes. Not used for First Generation
- # instances.
- # preferably be restarted for system maintenance purposes.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
- "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
- # <code>stable</code> (Later). <br /><a
- # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
- # Learn more</a>.
- },
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
# Generation instances.
@@ -1665,8 +1627,6 @@
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
"backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
"replicationLogArchivingEnabled": True or False, # Reserved for future use.
"location": "A String", # Location of the backup
"pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
@@ -1674,11 +1634,17 @@
# hour format - <code>HH:MM</code>.
"kind": "A String", # This is always <code>sql#backupConfiguration</code>.
"enabled": True or False, # Whether this configuration is enabled.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
},
"userLabels": { # User-provided labels, represented as a dictionary where each label is a
# single key value pair.
"a_key": "A String",
},
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "kind": "A String", # This is always <code>sql#settings</code>.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # 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 is only applicable to First
@@ -1687,16 +1653,12 @@
# 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.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
"zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
# etc.).
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
# Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
},
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
"activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
# applicable only when the instance state is <code>RUNNABLE</code>. Valid
# values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
@@ -1707,6 +1669,65 @@
# Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
# inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
# 12 hours of inactivity.
+ "databaseFlags": [ # The database flags passed to the instance at startup.
+ { # Database flags for Cloud SQL instances.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so
+ # include both server options and system variables for MySQL. Flags should be
+ # specified with underscores, not hyphens. For more information, see <a
+ # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
+ # SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
+ },
+ ],
+ "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.
+ "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
+ # <br><code>ZONAL</code>: The instance serves data from only one zone.
+ # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
+ # The instance can serve data from more than one zone in a region (it is
+ # highly available). <br>For more information, see <a
+ # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
+ # of the High Availability Configuration</a>.
+ "ipConfiguration": { # IP Management configuration. # 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.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
+ "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
+ # using the IP. In <a
+ # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
+ # notation</a>, also known as 'slash' notation (e.g.
+ # <code>192.168.100.0/24</code>).
+ { # An entry for an Access Control list.
+ "value": "A String", # The whitelisted value for the access control list.
+ "expirationTime": "A String", # The time when this access control entry expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "name": "A String", # Optional. A label to identify this entry.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
+ },
+ ],
+ "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ },
+ "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
+ # can be restarted for maintenance purposes. Not used for First Generation
+ # instances.
+ # preferably be restarted for system maintenance purposes.
+ "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
+ # <code>stable</code> (Later). <br /><a
+ # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
+ # Learn more</a>.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
+ },
},
"replicaNames": [ # The replicas of the instance.
"A String",
@@ -1716,15 +1737,18 @@
"kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
},
+ "etag": "A String", # This field is deprecated and will be removed from a future version of the
+ # API. Use the <code>settings.settingsVersion</code> field instead.
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
- "etag": "A String", # This field is deprecated and will be removed from a future version of the
- # API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
+ "expirationTime": "A String", # The time when the certificate expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"sha1Fingerprint": "A String", # Sha1 Fingerprint.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"cert": "A String", # PEM representation.
@@ -1735,9 +1759,6 @@
# <code>2012-11-15T16:19:00.094Z</code>
"instance": "A String", # Name of the database instance.
"selfLink": "A String", # The URI of this resource.
- "expirationTime": "A String", # The time when the certificate expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
},
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -1758,6 +1779,31 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
+ "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 <code>master.info</code>
+ # in the data directory.
+ "password": "A String", # The password for the replication connection.
+ "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.
+ "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.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "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.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for the replication connection.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
+ },
"failoverTarget": True or False, # Specifies if the replica is the failover target. If the field is set to
# <code>true</code> the replica will be designated as a failover replica. In
# case the master instance fails, the replica instance will be promoted as
@@ -1765,31 +1811,6 @@
# target, and the replica has to be in different zone with the master
# instance.
"kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
- "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 <code>master.info</code>
- # in the data directory.
- "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.
- "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
- "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
- "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.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for the replication connection.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
- "password": "A String", # The password for the replication connection.
- "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.
- },
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
@@ -1846,27 +1867,6 @@
# managed by Google. <br>This property is read-only; use the
# <code>tier</code> property in the <code>settings</code> object to determine
# the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
- "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
- # field can not be changed after instance creation. MySQL Second Generation
- # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
- # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
- # <code>POSTGRES_11 Beta</code> MySQL First Generation
- # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
}
x__xgafv: string, V1 error format.
@@ -1880,18 +1880,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -1912,14 +1900,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1928,13 +1908,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -1944,6 +1924,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -1952,6 +1940,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -1980,29 +1980,32 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
<div class="method">
- <code class="details" id="list">list(project, filter=None, pageToken=None, maxResults=None, x__xgafv=None)</code>
+ <code class="details" id="list">list(project, pageToken=None, maxResults=None, filter=None, x__xgafv=None)</code>
<pre>Lists instances under a given project.
Args:
project: string, Project ID of the project for which to list Cloud SQL instances. (required)
+ pageToken: string, A previously-returned page token representing part of the larger set of
+results to view.
+ maxResults: integer, The maximum number of results to return per response.
filter: string, A filter expression that filters resources listed in the response.
The expression is in the form of field:value. For example,
'instanceType:CLOUD_SQL_INSTANCE'. Fields can be nested as needed as per
@@ -2012,9 +2015,6 @@
'state:RUNNABLE instanceType:CLOUD_SQL_INSTANCE'. By default, each
expression is an AND expression. However, you can include AND and OR
expressions explicitly.
- pageToken: string, A previously-returned page token representing part of the larger set of
-results to view.
- maxResults: integer, The maximum number of results to return per response.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
@@ -2027,69 +2027,31 @@
"kind": "A String", # This is always <code>sql#instancesList</code>.
"items": [ # List of database instance resources.
{ # A Cloud SQL instance resource.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
+ "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
+ # field can not be changed after instance creation. MySQL Second Generation
+ # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
+ # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
+ # <code>POSTGRES_11 Beta</code> MySQL First Generation
+ # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
"suspensionReason": [ # If the instance state is SUSPENDED, the reason for the suspension.
"A String",
],
"settings": { # Database instance settings. # The user settings.
- "ipConfiguration": { # IP Management configuration. # 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.
- "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
- "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
- # using the IP. In <a
- # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
- # notation</a>, also known as 'slash' notation (e.g.
- # <code>192.168.100.0/24</code>).
- { # An entry for an Access Control list.
- "name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
- "value": "A String", # The whitelisted value for the access control list.
- "expirationTime": "A String", # The time when this access control entry expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- },
- ],
- },
- "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
- # <br><code>ZONAL</code>: The instance serves data from only one zone.
- # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
- # The instance can serve data from more than one zone in a region (it is
- # highly available). <br>For more information, see <a
- # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
- # of the High Availability Configuration</a>.
- "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.
- "databaseFlags": [ # The database flags passed to the instance at startup.
- { # Database flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so
- # include both server options and system variables for MySQL. Flags should be
- # specified with underscores, not hyphens. For more information, see <a
- # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
- # SQL documentation.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
- },
- ],
- "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
- # can be restarted for maintenance purposes. Not used for First Generation
- # instances.
- # preferably be restarted for system maintenance purposes.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
- "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
- # <code>stable</code> (Later). <br /><a
- # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
- # Learn more</a>.
- },
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
# Generation instances.
@@ -2118,8 +2080,6 @@
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
"backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
"replicationLogArchivingEnabled": True or False, # Reserved for future use.
"location": "A String", # Location of the backup
"pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
@@ -2127,11 +2087,17 @@
# hour format - <code>HH:MM</code>.
"kind": "A String", # This is always <code>sql#backupConfiguration</code>.
"enabled": True or False, # Whether this configuration is enabled.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
},
"userLabels": { # User-provided labels, represented as a dictionary where each label is a
# single key value pair.
"a_key": "A String",
},
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "kind": "A String", # This is always <code>sql#settings</code>.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # 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 is only applicable to First
@@ -2140,16 +2106,12 @@
# 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.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
"zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
# etc.).
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
# Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
},
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
"activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
# applicable only when the instance state is <code>RUNNABLE</code>. Valid
# values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
@@ -2160,6 +2122,65 @@
# Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
# inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
# 12 hours of inactivity.
+ "databaseFlags": [ # The database flags passed to the instance at startup.
+ { # Database flags for Cloud SQL instances.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so
+ # include both server options and system variables for MySQL. Flags should be
+ # specified with underscores, not hyphens. For more information, see <a
+ # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
+ # SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
+ },
+ ],
+ "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.
+ "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
+ # <br><code>ZONAL</code>: The instance serves data from only one zone.
+ # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
+ # The instance can serve data from more than one zone in a region (it is
+ # highly available). <br>For more information, see <a
+ # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
+ # of the High Availability Configuration</a>.
+ "ipConfiguration": { # IP Management configuration. # 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.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
+ "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
+ # using the IP. In <a
+ # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
+ # notation</a>, also known as 'slash' notation (e.g.
+ # <code>192.168.100.0/24</code>).
+ { # An entry for an Access Control list.
+ "value": "A String", # The whitelisted value for the access control list.
+ "expirationTime": "A String", # The time when this access control entry expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "name": "A String", # Optional. A label to identify this entry.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
+ },
+ ],
+ "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ },
+ "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
+ # can be restarted for maintenance purposes. Not used for First Generation
+ # instances.
+ # preferably be restarted for system maintenance purposes.
+ "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
+ # <code>stable</code> (Later). <br /><a
+ # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
+ # Learn more</a>.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
+ },
},
"replicaNames": [ # The replicas of the instance.
"A String",
@@ -2169,15 +2190,18 @@
"kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
},
+ "etag": "A String", # This field is deprecated and will be removed from a future version of the
+ # API. Use the <code>settings.settingsVersion</code> field instead.
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
- "etag": "A String", # This field is deprecated and will be removed from a future version of the
- # API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
+ "expirationTime": "A String", # The time when the certificate expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"sha1Fingerprint": "A String", # Sha1 Fingerprint.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"cert": "A String", # PEM representation.
@@ -2188,9 +2212,6 @@
# <code>2012-11-15T16:19:00.094Z</code>
"instance": "A String", # Name of the database instance.
"selfLink": "A String", # The URI of this resource.
- "expirationTime": "A String", # The time when the certificate expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
},
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -2211,6 +2232,31 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
+ "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 <code>master.info</code>
+ # in the data directory.
+ "password": "A String", # The password for the replication connection.
+ "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.
+ "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.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "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.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for the replication connection.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
+ },
"failoverTarget": True or False, # Specifies if the replica is the failover target. If the field is set to
# <code>true</code> the replica will be designated as a failover replica. In
# case the master instance fails, the replica instance will be promoted as
@@ -2218,31 +2264,6 @@
# target, and the replica has to be in different zone with the master
# instance.
"kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
- "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 <code>master.info</code>
- # in the data directory.
- "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.
- "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
- "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
- "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.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for the replication connection.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
- "password": "A String", # The password for the replication connection.
- "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.
- },
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
@@ -2299,27 +2320,6 @@
# managed by Google. <br>This property is read-only; use the
# <code>tier</code> property in the <code>settings</code> object to determine
# the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
- "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
- # field can not be changed after instance creation. MySQL Second Generation
- # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
- # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
- # <code>POSTGRES_11 Beta</code> MySQL First Generation
- # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
},
],
"warnings": [ # List of warnings that occurred while handling the request.
@@ -2353,10 +2353,11 @@
An object of the form:
{ # Instances ListServerCas response.
- "activeVersion": "A String",
- "kind": "A String", # This is always <code>sql#instancesListServerCas</code>.
"certs": [ # List of server CA certificates for the instance.
{ # SslCerts Resource
+ "expirationTime": "A String", # The time when the certificate expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"sha1Fingerprint": "A String", # Sha1 Fingerprint.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"cert": "A String", # PEM representation.
@@ -2367,11 +2368,10 @@
# <code>2012-11-15T16:19:00.094Z</code>
"instance": "A String", # Name of the database instance.
"selfLink": "A String", # The URI of this resource.
- "expirationTime": "A String", # The time when the certificate expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
},
],
+ "activeVersion": "A String",
+ "kind": "A String", # This is always <code>sql#instancesListServerCas</code>.
}</pre>
</div>
@@ -2401,69 +2401,31 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
+ "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
+ # field can not be changed after instance creation. MySQL Second Generation
+ # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
+ # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
+ # <code>POSTGRES_11 Beta</code> MySQL First Generation
+ # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
"suspensionReason": [ # If the instance state is SUSPENDED, the reason for the suspension.
"A String",
],
"settings": { # Database instance settings. # The user settings.
- "ipConfiguration": { # IP Management configuration. # 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.
- "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
- "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
- # using the IP. In <a
- # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
- # notation</a>, also known as 'slash' notation (e.g.
- # <code>192.168.100.0/24</code>).
- { # An entry for an Access Control list.
- "name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
- "value": "A String", # The whitelisted value for the access control list.
- "expirationTime": "A String", # The time when this access control entry expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- },
- ],
- },
- "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
- # <br><code>ZONAL</code>: The instance serves data from only one zone.
- # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
- # The instance can serve data from more than one zone in a region (it is
- # highly available). <br>For more information, see <a
- # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
- # of the High Availability Configuration</a>.
- "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.
- "databaseFlags": [ # The database flags passed to the instance at startup.
- { # Database flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so
- # include both server options and system variables for MySQL. Flags should be
- # specified with underscores, not hyphens. For more information, see <a
- # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
- # SQL documentation.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
- },
- ],
- "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
- # can be restarted for maintenance purposes. Not used for First Generation
- # instances.
- # preferably be restarted for system maintenance purposes.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
- "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
- # <code>stable</code> (Later). <br /><a
- # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
- # Learn more</a>.
- },
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
# Generation instances.
@@ -2492,8 +2454,6 @@
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
"backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
"replicationLogArchivingEnabled": True or False, # Reserved for future use.
"location": "A String", # Location of the backup
"pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
@@ -2501,11 +2461,17 @@
# hour format - <code>HH:MM</code>.
"kind": "A String", # This is always <code>sql#backupConfiguration</code>.
"enabled": True or False, # Whether this configuration is enabled.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
},
"userLabels": { # User-provided labels, represented as a dictionary where each label is a
# single key value pair.
"a_key": "A String",
},
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "kind": "A String", # This is always <code>sql#settings</code>.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # 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 is only applicable to First
@@ -2514,16 +2480,12 @@
# 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.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
"zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
# etc.).
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
# Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
},
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
"activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
# applicable only when the instance state is <code>RUNNABLE</code>. Valid
# values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
@@ -2534,6 +2496,65 @@
# Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
# inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
# 12 hours of inactivity.
+ "databaseFlags": [ # The database flags passed to the instance at startup.
+ { # Database flags for Cloud SQL instances.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so
+ # include both server options and system variables for MySQL. Flags should be
+ # specified with underscores, not hyphens. For more information, see <a
+ # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
+ # SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
+ },
+ ],
+ "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.
+ "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
+ # <br><code>ZONAL</code>: The instance serves data from only one zone.
+ # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
+ # The instance can serve data from more than one zone in a region (it is
+ # highly available). <br>For more information, see <a
+ # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
+ # of the High Availability Configuration</a>.
+ "ipConfiguration": { # IP Management configuration. # 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.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
+ "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
+ # using the IP. In <a
+ # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
+ # notation</a>, also known as 'slash' notation (e.g.
+ # <code>192.168.100.0/24</code>).
+ { # An entry for an Access Control list.
+ "value": "A String", # The whitelisted value for the access control list.
+ "expirationTime": "A String", # The time when this access control entry expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "name": "A String", # Optional. A label to identify this entry.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
+ },
+ ],
+ "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ },
+ "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
+ # can be restarted for maintenance purposes. Not used for First Generation
+ # instances.
+ # preferably be restarted for system maintenance purposes.
+ "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
+ # <code>stable</code> (Later). <br /><a
+ # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
+ # Learn more</a>.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
+ },
},
"replicaNames": [ # The replicas of the instance.
"A String",
@@ -2543,15 +2564,18 @@
"kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
},
+ "etag": "A String", # This field is deprecated and will be removed from a future version of the
+ # API. Use the <code>settings.settingsVersion</code> field instead.
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
- "etag": "A String", # This field is deprecated and will be removed from a future version of the
- # API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
+ "expirationTime": "A String", # The time when the certificate expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"sha1Fingerprint": "A String", # Sha1 Fingerprint.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"cert": "A String", # PEM representation.
@@ -2562,9 +2586,6 @@
# <code>2012-11-15T16:19:00.094Z</code>
"instance": "A String", # Name of the database instance.
"selfLink": "A String", # The URI of this resource.
- "expirationTime": "A String", # The time when the certificate expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
},
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -2585,6 +2606,31 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
+ "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 <code>master.info</code>
+ # in the data directory.
+ "password": "A String", # The password for the replication connection.
+ "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.
+ "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.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "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.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for the replication connection.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
+ },
"failoverTarget": True or False, # Specifies if the replica is the failover target. If the field is set to
# <code>true</code> the replica will be designated as a failover replica. In
# case the master instance fails, the replica instance will be promoted as
@@ -2592,31 +2638,6 @@
# target, and the replica has to be in different zone with the master
# instance.
"kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
- "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 <code>master.info</code>
- # in the data directory.
- "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.
- "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
- "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
- "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.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for the replication connection.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
- "password": "A String", # The password for the replication connection.
- "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.
- },
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
@@ -2673,27 +2694,6 @@
# managed by Google. <br>This property is read-only; use the
# <code>tier</code> property in the <code>settings</code> object to determine
# the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
- "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
- # field can not be changed after instance creation. MySQL Second Generation
- # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
- # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
- # <code>POSTGRES_11 Beta</code> MySQL First Generation
- # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
}
x__xgafv: string, V1 error format.
@@ -2707,18 +2707,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -2739,14 +2727,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -2755,13 +2735,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -2771,6 +2751,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -2779,6 +2767,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -2807,20 +2807,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -2843,18 +2843,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -2875,14 +2863,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -2891,13 +2871,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -2907,6 +2887,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -2915,6 +2903,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -2943,20 +2943,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -2979,18 +2979,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -3011,14 +2999,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3027,13 +3007,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -3043,6 +3023,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -3051,6 +3039,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -3079,20 +3079,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -3114,18 +3114,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -3146,14 +3134,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3162,13 +3142,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -3178,6 +3158,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -3186,6 +3174,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -3214,20 +3214,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -3245,10 +3245,10 @@
{ # Database instance restore backup request.
"restoreBackupContext": { # Database instance restore from backup context. # Parameters required to perform the restore backup operation.
# Backup context contains source instance id and project id.
- "kind": "A String", # This is always <code>sql#restoreBackupContext</code>.
"project": "A String", # The full project ID of the source instance.
"backupRunId": "A String", # The ID of the backup run to restore from.
"instanceId": "A String", # The ID of the instance that the backup was taken from.
+ "kind": "A String", # This is always <code>sql#restoreBackupContext</code>.
},
}
@@ -3263,18 +3263,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -3295,14 +3283,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3311,13 +3291,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -3327,6 +3307,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -3335,6 +3323,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -3363,20 +3363,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -3410,18 +3410,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -3442,14 +3430,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3458,13 +3438,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -3474,6 +3454,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -3482,6 +3470,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -3510,20 +3510,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -3545,18 +3545,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -3577,14 +3565,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3593,13 +3573,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -3609,6 +3589,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -3617,6 +3605,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -3645,20 +3645,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -3680,18 +3680,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -3712,14 +3700,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3728,13 +3708,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -3744,6 +3724,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -3752,6 +3740,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -3780,20 +3780,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -3809,9 +3809,9 @@
{ # Instance truncate log request.
"truncateLogContext": { # Database Instance truncate log context. # Contains details about the truncate log operation.
+ "kind": "A String", # This is always <code>sql#truncateLogContext</code>.
"logType": "A String", # The type of log to truncate. Valid values are
# <code>MYSQL_GENERAL_TABLE</code> and <code>MYSQL_SLOW_TABLE</code>.
- "kind": "A String", # This is always <code>sql#truncateLogContext</code>.
},
}
@@ -3826,18 +3826,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -3858,14 +3846,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3874,13 +3854,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -3890,6 +3870,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -3898,6 +3886,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -3926,20 +3926,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>
@@ -3955,69 +3955,31 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
+ "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
+ # field can not be changed after instance creation. MySQL Second Generation
+ # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
+ # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
+ # <code>POSTGRES_11 Beta</code> MySQL First Generation
+ # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
"suspensionReason": [ # If the instance state is SUSPENDED, the reason for the suspension.
"A String",
],
"settings": { # Database instance settings. # The user settings.
- "ipConfiguration": { # IP Management configuration. # 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.
- "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
- "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
- # using the IP. In <a
- # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
- # notation</a>, also known as 'slash' notation (e.g.
- # <code>192.168.100.0/24</code>).
- { # An entry for an Access Control list.
- "name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
- "value": "A String", # The whitelisted value for the access control list.
- "expirationTime": "A String", # The time when this access control entry expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- },
- ],
- },
- "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
- # <br><code>ZONAL</code>: The instance serves data from only one zone.
- # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
- # The instance can serve data from more than one zone in a region (it is
- # highly available). <br>For more information, see <a
- # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
- # of the High Availability Configuration</a>.
- "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.
- "databaseFlags": [ # The database flags passed to the instance at startup.
- { # Database flags for Cloud SQL instances.
- "name": "A String", # The name of the flag. These flags are passed at instance startup, so
- # include both server options and system variables for MySQL. Flags should be
- # specified with underscores, not hyphens. For more information, see <a
- # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
- # SQL documentation.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
- },
- ],
- "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
- # can be restarted for maintenance purposes. Not used for First Generation
- # instances.
- # preferably be restarted for system maintenance purposes.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
- "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
- # <code>stable</code> (Later). <br /><a
- # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
- # Learn more</a>.
- },
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
# Generation instances.
@@ -4046,8 +4008,6 @@
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
"backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
"replicationLogArchivingEnabled": True or False, # Reserved for future use.
"location": "A String", # Location of the backup
"pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
@@ -4055,11 +4015,17 @@
# hour format - <code>HH:MM</code>.
"kind": "A String", # This is always <code>sql#backupConfiguration</code>.
"enabled": True or False, # Whether this configuration is enabled.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
},
"userLabels": { # User-provided labels, represented as a dictionary where each label is a
# single key value pair.
"a_key": "A String",
},
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "kind": "A String", # This is always <code>sql#settings</code>.
"locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # 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 is only applicable to First
@@ -4068,16 +4034,12 @@
# 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.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
"zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
# etc.).
"followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
# Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
},
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
"activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
# applicable only when the instance state is <code>RUNNABLE</code>. Valid
# values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
@@ -4088,6 +4050,65 @@
# Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
# inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
# 12 hours of inactivity.
+ "databaseFlags": [ # The database flags passed to the instance at startup.
+ { # Database flags for Cloud SQL instances.
+ "name": "A String", # The name of the flag. These flags are passed at instance startup, so
+ # include both server options and system variables for MySQL. Flags should be
+ # specified with underscores, not hyphens. For more information, see <a
+ # href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
+ # SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
+ },
+ ],
+ "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.
+ "availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
+ # <br><code>ZONAL</code>: The instance serves data from only one zone.
+ # Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
+ # The instance can serve data from more than one zone in a region (it is
+ # highly available). <br>For more information, see <a
+ # href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
+ # of the High Availability Configuration</a>.
+ "ipConfiguration": { # IP Management configuration. # 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.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
+ "authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
+ # using the IP. In <a
+ # href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
+ # notation</a>, also known as 'slash' notation (e.g.
+ # <code>192.168.100.0/24</code>).
+ { # An entry for an Access Control list.
+ "value": "A String", # The whitelisted value for the access control list.
+ "expirationTime": "A String", # The time when this access control entry expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "name": "A String", # Optional. A label to identify this entry.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
+ },
+ ],
+ "requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ },
+ "maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
+ # can be restarted for maintenance purposes. Not used for First Generation
+ # instances.
+ # preferably be restarted for system maintenance purposes.
+ "updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
+ # <code>stable</code> (Later). <br /><a
+ # href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
+ # Learn more</a>.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
+ },
},
"replicaNames": [ # The replicas of the instance.
"A String",
@@ -4097,15 +4118,18 @@
"kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
},
+ "etag": "A String", # This field is deprecated and will be removed from a future version of the
+ # API. Use the <code>settings.settingsVersion</code> field instead.
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
- "etag": "A String", # This field is deprecated and will be removed from a future version of the
- # API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
+ "expirationTime": "A String", # The time when the certificate expires in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"sha1Fingerprint": "A String", # Sha1 Fingerprint.
"certSerialNumber": "A String", # Serial number, as extracted from the certificate.
"cert": "A String", # PEM representation.
@@ -4116,9 +4140,6 @@
# <code>2012-11-15T16:19:00.094Z</code>
"instance": "A String", # Name of the database instance.
"selfLink": "A String", # The URI of this resource.
- "expirationTime": "A String", # The time when the certificate expires in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
},
"maxDiskSize": "A String", # The maximum disk size of the instance in bytes.
"name": "A String", # Name of the Cloud SQL instance. This does not include the project ID.
@@ -4139,6 +4160,31 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
+ "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 <code>master.info</code>
+ # in the data directory.
+ "password": "A String", # The password for the replication connection.
+ "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.
+ "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.
+ "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
+ "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.
+ "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for the replication connection.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
+ },
"failoverTarget": True or False, # Specifies if the replica is the failover target. If the field is set to
# <code>true</code> the replica will be designated as a failover replica. In
# case the master instance fails, the replica instance will be promoted as
@@ -4146,31 +4192,6 @@
# target, and the replica has to be in different zone with the master
# instance.
"kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
- "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 <code>master.info</code>
- # in the data directory.
- "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.
- "masterHeartbeatPeriod": "A String", # Interval in milliseconds between replication heartbeats.
- "connectRetryInterval": 42, # Seconds to wait between connect retries. MySQL's default is 60 seconds.
- "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.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for the replication connection.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#mysqlReplicaConfiguration</code>.
- "password": "A String", # The password for the replication connection.
- "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.
- },
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
@@ -4227,27 +4248,6 @@
# managed by Google. <br>This property is read-only; use the
# <code>tier</code> property in the <code>settings</code> object to determine
# the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
- "databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
- # field can not be changed after instance creation. MySQL Second Generation
- # instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
- # PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
- # <code>POSTGRES_11 Beta</code> MySQL First Generation
- # instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code>
}
x__xgafv: string, V1 error format.
@@ -4261,18 +4261,6 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "user": "A String", # The email address of the user who initiated this operation.
- "targetProject": "A String", # The project ID of the target instance related to this operation.
- "selfLink": "A String", # The URI of this resource.
"targetLink": "A String",
"operationType": "A String", # The type of the operation. Valid values are <code>CREATE</code>,
# <code>DELETE</code>, <code>UPDATE</code>, <code>RESTART</code>,
@@ -4293,14 +4281,6 @@
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
- "kind": "A String", # This is always <code>sql#importContext</code>.
- "csvImportOptions": { # Options for importing data as CSV.
- "table": "A String", # The table to which CSV data is imported.
- "columns": [ # The columns to which CSV data is imported. If not specified, all columns
- # of the database table are loaded with CSV data.
- "A String",
- ],
- },
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -4309,13 +4289,13 @@
"importUser": "A String", # The PostgreSQL user for this import operation. PostgreSQL instances only.
"bakImportOptions": { # Import parameters specific to SQL Server .BAK files
"encryptionOptions": {
+ "pvkPassword": "A String", # Password that encrypts the private key
"certPath": "A String", # Path to the Certificate (.cer) in Cloud Storage, in the form
# <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
"pvkPath": "A String", # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
# form <code>gs://bucketName/fileName</code>. The instance must have
# write permissions to the bucket and read access to the file.
- "pvkPassword": "A String", # Password that encrypts the private key
},
},
"uri": "A String", # Path to the import file in Cloud Storage, in the form
@@ -4325,6 +4305,14 @@
# // write permissions to the bucket and read access to the file.
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
+ "csvImportOptions": { # Options for importing data as CSV.
+ "table": "A String", # The table to which CSV data is imported.
+ "columns": [ # The columns to which CSV data is imported. If not specified, all columns
+ # of the database table are loaded with CSV data.
+ "A String",
+ ],
+ },
},
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
@@ -4333,6 +4321,18 @@
# identifier to retrieve the Operations resource that has information about
# the operation.
"exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -4361,20 +4361,20 @@
# All other values are ignored.
},
},
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
"targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "user": "A String", # The email address of the user who initiated this operation.
+ "targetProject": "A String", # The project ID of the target instance related to this operation.
+ "selfLink": "A String", # The URI of this resource.
}</pre>
</div>