sql.instances.patch

PATCH {{baseUrl}}/sql/v1beta4/projects/:project/instances/:instance?$.xgafv=<string>&access_token=<string>&alt=<string>&callback=<string>&fields=<string>&key=<string>&oauth_token=<string>&prettyPrint=<boolean>&quotaUser=<string>&upload_protocol=<string>&uploadType=<string>

Updates settings of a Cloud SQL instance. This method supports patch semantics.

Request Params

KeyDatatypeRequiredDescription
$.xgafvstringV1 error format.
access_tokenstringOAuth access token.
altstringData format for response.
callbackstringJSONP
fieldsstringSelector specifying which fields to include in a partial response.
keystringAPI key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.
oauth_tokenstringOAuth 2.0 token for the current user.
prettyPrintstringReturns response with indentations and line breaks.
quotaUserstringAvailable to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters.
upload_protocolstringUpload protocol for media (e.g. "raw", "multipart").
uploadTypestringLegacy upload protocol for media (e.g. "media", "multipart").

Request Body

{"backendType"=>"<string>", "connectionName"=>"<string>", "currentDiskSize"=>"<string>", "databaseVersion"=>"<string>", "diskEncryptionConfiguration"=>{"kind"=>"mollit eu ea", "kmsKeyName"=>"incididunt qui officia"}, "diskEncryptionStatus"=>{"kind"=>"laboris sunt aliquip", "kmsKeyVersionName"=>"minim Duis sunt"}, "etag"=>"<string>", "failoverReplica"=>{"available"=>"<boolean>", "name"=>"<string>"}, "gceZone"=>"<string>", "instanceType"=>"<string>", "ipAddresses"=>[{"ipAddress"=>"in ad do cupidatat", "timeToRetire"=>"anim nostrud E", "type"=>"PRIVATE"}, {"ipAddress"=>"commodo dolore", "timeToRetire"=>"laborum velit", "type"=>"PRIMARY"}], "ipv6Address"=>"<string>", "kind"=>"<string>", "masterInstanceName"=>"<string>", "maxDiskSize"=>"<string>", "name"=>"<string>", "onPremisesConfiguration"=>{"caCertificate"=>"cupidatat", "clientCertificate"=>"Excepteur nostrud Ut", "clientKey"=>"id irure qui magna", "dumpFilePath"=>"dolor laborum", "hostPort"=>"aliquip reprehenderit mollit", "kind"=>"esse ea", "password"=>"dolor in", "username"=>"consectetur anim voluptate qui"}, "project"=>"<string>", "region"=>"<string>", "replicaConfiguration"=>{"failoverTarget"=>true, "kind"=>"proident velit pariatur", "mysqlReplicaConfiguration"=>{"caCertificate"=>"nostrud occaecat do cupidatat qui", "clientCertificate"=>"", "clientKey"=>"deserunt", "connectRetryInterval"=>98464088, "dumpFilePath"=>"eiusmod tempor ex", "kind"=>"consectetur Ut sint exercitation", "masterHeartbeatPeriod"=>"ipsum fugiat", "password"=>"consectetur non", "sslCipher"=>"ad elit magna", "username"=>"ullamco nisi ", "verifyServerCertificate"=>false}}, "replicaNames"=>["<string>", "<string>"], "rootPassword"=>"<string>", "scheduledMaintenance"=>{"canDefer"=>true, "canReschedule"=>true, "startTime"=>"magna labore dolore esse"}, "selfLink"=>"<string>", "serverCaCert"=>{"cert"=>"aute proident", "certSerialNumber"=>"elit eu reprehenderit exercitatio", "commonName"=>"culpa Excepteur", "createTime"=>"dolor cupidatat mollit", "expirationTime"=>"dolor eu", "instance"=>"aliqua", "kind"=>"eiusmod occaecat la", "selfLink"=>"quis", "sha1Fingerprint"=>"irure exercitation"}, "serviceAccountEmailAddress"=>"<string>", "settings"=>{"activationPolicy"=>"ALWAYS", "activeDirectoryConfig"=>{"domain"=>"voluptate commodo", "kind"=>"nostrud ad et veniam"}, "authorizedGaeApplications"=>["occaecat ad ea", "nisi quis ex est velit"], "availabilityType"=>"REGIONAL", "backupConfiguration"=>{"binaryLogEnabled"=>true, "enabled"=>false, "kind"=>"labore sit ut mollit do", "location"=>"magna reprehenderit elit adipisicing", "pointInTimeRecoveryEnabled"=>true, "replicationLogArchivingEnabled"=>true, "startTime"=>"veniam pariatur esse aute"}, "collation"=>"officia labore velit eu", "crashSafeReplicationEnabled"=>false, "dataDiskSizeGb"=>"tempor incididunt nisi lab", "dataDiskType"=>"OBSOLETE_LOCAL_SSD", "databaseFlags"=>[{"name"=>"aliqua in", "value"=>"amet velit aute"}, {"name"=>"irure Ut fugiat reprehenderit veniam", "value"=>"ea quis eiusmod ex"}], "databaseReplicationEnabled"=>false, "denyMaintenancePeriods"=>[{"endDate"=>"esse anim", "startDate"=>"quis in aliqua", "time"=>"fugiat esse incididunt"}, {"endDate"=>"commodo dolor q", "startDate"=>"id Lorem culpa ea eu", "time"=>"magna quis dolore"}], "ipConfiguration"=>{"authorizedNetworks"=>[{"value"=>"<Error: Too many levels of nesting to fake this schema>"}, {"value"=>"<Error: Too many levels of nesting to fake this schema>"}], "ipv4Enabled"=>true, "privateNetwork"=>"mollit Ut nulla", "requireSsl"=>false}, "kind"=>"laboris dolore proident est", "locationPreference"=>{"followGaeApplication"=>"sed ea ad dolore", "kind"=>"exercitation aliqua", "zone"=>"eiusmod qui ad"}, "maintenanceWindow"=>{"day"=>-19620954, "hour"=>-99012575, "kind"=>"deserunt consectetur", "updateTrack"=>"stable"}, "pricingPlan"=>"PACKAGE", "replicationType"=>"SYNCHRONOUS", "settingsVersion"=>"nulla", "storageAutoResize"=>true, "storageAutoResizeLimit"=>"labore cillum", "tier"=>"esse eu fugiat ex"}, "state"=>"<string>", "suspensionReason"=>["<string>", "<string>"]}

HEADERS

KeyDatatypeRequiredDescription
Content-Typestring

RESPONSES

status: OK

{&quot;endTime&quot;:&quot;velit adipisicing Ut&quot;,&quot;error&quot;:{&quot;errors&quot;:[{&quot;code&quot;:&quot;dolore culpa deserunt&quot;,&quot;kind&quot;:&quot;labore ut et magna qui&quot;,&quot;message&quot;:&quot;Duis sed velit do&quot;},{&quot;code&quot;:&quot;aliqua minim adipisicing aliquip&quot;,&quot;kind&quot;:&quot;laboris sed consequat&quot;,&quot;message&quot;:&quot;consectetur sit Lorem id irure&quot;}],&quot;kind&quot;:&quot;quis minim&quot;},&quot;exportContext&quot;:{&quot;csvExportOptions&quot;:{&quot;selectQuery&quot;:&quot;do Excepteur eu voluptate&quot;},&quot;databases&quot;:[&quot;in Excepteur&quot;,&quot;Ut sunt&quot;],&quot;fileType&quot;:&quot;BAK&quot;,&quot;kind&quot;:&quot;ea&quot;,&quot;offload&quot;:false,&quot;sqlExportOptions&quot;:{&quot;mysqlExportOptions&quot;:{&quot;masterData&quot;:45123378},&quot;schemaOnly&quot;:false,&quot;tables&quot;:[&quot;laborum&quot;,&quot;et cupidatat reprehenderit&quot;]},&quot;uri&quot;:&quot;in proident&quot;},&quot;importContext&quot;:{&quot;bakImportOptions&quot;:{&quot;encryptionOptions&quot;:{&quot;certPath&quot;:&quot;enim elit officia veniam dolor&quot;,&quot;pvkPassword&quot;:&quot;laborum proident&quot;,&quot;pvkPath&quot;:&quot;elit ipsum&quot;}},&quot;csvImportOptions&quot;:{&quot;columns&quot;:[&quot;ullamco in cupidatat incididunt elit&quot;,&quot;ad irure id aliquip&quot;],&quot;table&quot;:&quot;in ullamco&quot;},&quot;database&quot;:&quot;aliquip sed Lorem&quot;,&quot;fileType&quot;:&quot;BAK&quot;,&quot;importUser&quot;:&quot;incididunt sint ea sit&quot;,&quot;kind&quot;:&quot;Duis sed magna Ut&quot;,&quot;uri&quot;:&quot;commodo eiusmod quis consequat&quot;},&quot;insertTime&quot;:&quot;dolore exercitation id eiusmod&quot;,&quot;kind&quot;:&quot;enim&quot;,&quot;name&quot;:&quot;dolor fugiat&quot;,&quot;operationType&quot;:&quot;MAINTENANCE&quot;,&quot;selfLink&quot;:&quot;cupidatat minim Excepteur&quot;,&quot;startTime&quot;:&quot;est Ut fugiat esse&quot;,&quot;status&quot;:&quot;DONE&quot;,&quot;targetId&quot;:&quot;enim consectetur tempor sit&quot;,&quot;targetLink&quot;:&quot;amet in culpa veniam&quot;,&quot;targetProject&quot;:&quot;aliquip&quot;,&quot;user&quot;:&quot;mollit do in cillum&quot;}