Method: instances.demote

SQL Server, private server access, HDD, data cache, legacy HA, serverless exports, multi-region backups, cross-region replicas are not supported.
Demotes an existing standalone instance to be a Cloud SQL read replica for an external database server.

HTTP request

POST https://sqladmin.s3nsapis.fr/v1/projects/{project}/instances/{instance}/demote

The URL uses gRPC Transcoding syntax.

Path parameters

Parameters
project

string

Required. ID of the project that contains the instance.
instance

string

Required. Cloud SQL instance name.

Request body

The request body contains an instance of InstancesDemoteRequest.

Response body

If successful, the response body contains an instance of Operation.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/sqlservice.admin
  • https://www.googleapis.com/auth/cloud-platform

For more information, see the Authentication Overview.

InstancesDemoteRequest

This request is used to demote an existing standalone instance to be a Cloud SQL read replica for an external database server.

JSON representation 
{
  "demoteContext": {
    object (DemoteContext)
  }
}
Fields
demoteContext

object (DemoteContext)

Required. Contains details about the demote operation.

DemoteContext

This context is used to demote an existing standalone instance to be a Cloud SQL read replica for an external database server.

JSON representation 
{
  "kind": string,
  "sourceRepresentativeInstanceName": string
}
Fields
kind

string

This is always sql#demoteContext.
sourceRepresentativeInstanceName

string

Required. The name of the instance which acts as the on-premises primary instance in the replication setup.