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>"aUser=<string>&upload_protocol=<string>&uploadType=<string>
Updates settings of a Cloud SQL instance. This method supports patch semantics.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
$.xgafv | string | V1 error format. | |
access_token | string | OAuth access token. | |
alt | string | Data format for response. | |
callback | string | JSONP | |
fields | string | Selector specifying which fields to include in a partial response. | |
key | string | API 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_token | string | OAuth 2.0 token for the current user. | |
prettyPrint | string | Returns response with indentations and line breaks. | |
quotaUser | string | Available 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_protocol | string | Upload protocol for media (e.g. "raw", "multipart"). | |
uploadType | string | Legacy 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
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string |
RESPONSES
status: OK
{"endTime":"velit adipisicing Ut","error":{"errors":[{"code":"dolore culpa deserunt","kind":"labore ut et magna qui","message":"Duis sed velit do"},{"code":"aliqua minim adipisicing aliquip","kind":"laboris sed consequat","message":"consectetur sit Lorem id irure"}],"kind":"quis minim"},"exportContext":{"csvExportOptions":{"selectQuery":"do Excepteur eu voluptate"},"databases":["in Excepteur","Ut sunt"],"fileType":"BAK","kind":"ea","offload":false,"sqlExportOptions":{"mysqlExportOptions":{"masterData":45123378},"schemaOnly":false,"tables":["laborum","et cupidatat reprehenderit"]},"uri":"in proident"},"importContext":{"bakImportOptions":{"encryptionOptions":{"certPath":"enim elit officia veniam dolor","pvkPassword":"laborum proident","pvkPath":"elit ipsum"}},"csvImportOptions":{"columns":["ullamco in cupidatat incididunt elit","ad irure id aliquip"],"table":"in ullamco"},"database":"aliquip sed Lorem","fileType":"BAK","importUser":"incididunt sint ea sit","kind":"Duis sed magna Ut","uri":"commodo eiusmod quis consequat"},"insertTime":"dolore exercitation id eiusmod","kind":"enim","name":"dolor fugiat","operationType":"MAINTENANCE","selfLink":"cupidatat minim Excepteur","startTime":"est Ut fugiat esse","status":"DONE","targetId":"enim consectetur tempor sit","targetLink":"amet in culpa veniam","targetProject":"aliquip","user":"mollit do in cillum"}