- HTTP request
- Path parameters
- Query parameters
- Request body
- Response body
- Authorization Scopes
- SqlExternalSyncSettingError
- SqlExternalSyncSettingErrorType
- Examples
- Try it!
Verify External master external sync settings.
HTTP request
POST https://sqladmin.googleapis.com/sql/v1beta4/projects/{project}/instances/{instance}/verifyExternalSyncSettings
The URL uses gRPC Transcoding syntax.
Path parameters
Parameters | |
---|---|
project |
Project ID of the project that contains the instance. |
instance |
Cloud SQL instance ID. This does not include the project ID. |
Query parameters
Parameters | |
---|---|
verifyConnectionOnly |
Flag to enable verifying connection only |
syncMode |
External sync mode |
Request body
The request body must be empty.
Response body
If successful, the response body contains data with the following structure:
Instance verify external sync settings response.
JSON representation | |
---|---|
{
"kind": string,
"errors": [
{
object ( |
Fields | |
---|---|
kind |
This is always sql#migrationSettingErrorList. |
errors[] |
backupRuns.list of migration violations. |
Authorization Scopes
Requires one of the following OAuth scopes:
https://www.googleapis.com/auth/cloud-platform
https://www.googleapis.com/auth/sqlservice.admin
For more information, see the Authentication Overview.
SqlExternalSyncSettingError
External master migration setting error.
JSON representation | |
---|---|
{
"kind": string,
"type": enum ( |
Fields | |
---|---|
kind |
This is always sql#migrationSettingError. |
type |
Identifies the specific error that occurred. |
detail |
Additional information about the error encountered. |
SqlExternalSyncSettingErrorType
Enums | |
---|---|
SQL_EXTERNAL_SYNC_SETTING_ERROR_TYPE_UNSPECIFIED |
|
CONNECTION_FAILURE |
|
BINLOG_NOT_ENABLED |
|
INCOMPATIBLE_DATABASE_VERSION |
|
REPLICA_ALREADY_SETUP |
|
INSUFFICIENT_PRIVILEGE |
|
UNSUPPORTED_MIGRATION_TYPE |
Unsupported migration type. |
NO_PGLOGICAL_INSTALLED |
No pglogical extension installed on databases, applicable for postgres. |
PGLOGICAL_NODE_ALREADY_EXISTS |
pglogical node already exists on databases, applicable for postgres. |
INVALID_WAL_LEVEL |
The value of parameter wal_level is not set to logical. |
INVALID_SHARED_PRELOAD_LIBRARY |
The value of parameter shared_preload_libraries does not include pglogical. |
INSUFFICIENT_MAX_REPLICATION_SLOTS |
The value of parameter max_replication_slots is not sufficient. |
INSUFFICIENT_MAX_WAL_SENDERS |
The value of parameter max_wal_senders is not sufficient. |
INSUFFICIENT_MAX_WORKER_PROCESSES |
The value of parameter max_worker_processes is not sufficient. |
UNSUPPORTED_EXTENSIONS |
Extensions installed are either not supported or having unsupported versions |
INVALID_RDS_LOGICAL_REPLICATION |
The value of parameter rds.logical_replication is not set to 1. |