About 2 weeks ago, I was trying to create external master replication following this instruction:
-- https://cloud.google.com/sql/docs/replication/configure-external-master
But even after creating replication db, replica instances are under pending status.
FYI this is what it looks like.
$ curl --header "Authorization: Bearer ${ACCESS_TOKEN}" \
> --header 'Content-Type: application/json' \
> -X GET \
> https://www.googleapis.com/sql/v1beta4/projects/mathpresso-1016/instances/qbase-primary-repl-read/
{
"kind": "sql#instance",
"selfLink": "https://www.googleapis.com/sql/v1beta4/projects/mathpresso-1016/instances/qbase-primary-repl-read",
"name": "qbase-primary-repl-read",
"connectionName": "mathpresso-1016:qbase-primary-repl-read",
"etag": some values,
"project": "mathpresso-1016",
"state": "PENDING_CREATE",
"backendType": "FIRST_GEN",
"databaseVersion": "MYSQL_5_6",
"region": "us-central",
"currentDiskSize": "281812187",
"maxDiskSize": "268435456000",
"settings": {
"kind": "sql#settings",
"settingsVersion": "1",
"authorizedGaeApplications": [],
"tier": "D4",
"backupConfiguration": {
"kind": "sql#backupConfiguration",
"startTime": "01:00",
"enabled": false,
"binaryLogEnabled": false
},
"pricingPlan": "PER_USE",
"replicationType": "ASYNCHRONOUS",
"activationPolicy": "ALWAYS",
"ipConfiguration": {
"ipv4Enabled": false,
"authorizedNetworks": []
},
"databaseReplicationEnabled": true,
"crashSafeReplicationEnabled": true
},
"serverCaCert": {
"kind": "sql#sslCert",
"instance": "qbase-primary-repl-read",
...
...
"createTime": "2016-12-02T17:45:20.934Z",
"expirationTime": "2018-12-02T17:46:20.934Z"
},
"instanceType": "READ_REPLICA_INSTANCE",
"masterInstanceName": "mathpresso-1016:qbase-primary-repl-internalmaster",
"ipv6Address": some values,
"replicaConfiguration": {
"kind": "sql#replicaConfiguration",
"failoverTarget": false
}
}
Now I want to delete them, and I don't know how to delete these instances (every time I try it shows error)
Could you please delete these instances?
qbase-primary-repl-internalmaster
qbase-primary-repl-read
qbase-primary-replica-internalmaster
qbase-primary-replica-read
qbase-primary-replica-readonly
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f6c19a0c-f5d7-487b-91f1-1584be7afbc0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment