1
votes

My Bootstrapping effort for creating Cloud SQL 2nd gen instances went smoothly apart from one thing.

it refused to accept the parameter for MYSQL_5_7.

 C:\Program Files (x86)\Google\Cloud SDK>gcloud sql instances create ops-sql-2 --activation-policy=ALWAYS --backup --tier=db-n1-standard-2 --region=europe-west1 --gce-zone=europe-west1-b --database-version=mysql_5_7 --require-ssl  --assign-ip --backup-start-time=02:00
usage: gcloud sql instances create  INSTANCE [optional flags]
ERROR: (gcloud.sql.instances.create) argument --database-version: Invalid choice: 'mysql_5_7'.

Valid choices are [MYSQL_5_5, MYSQL_5_6, MYSQL_5_7, POSTGRES_9_5].

C:\Program Files (x86)\Google\Cloud SDK>gcloud sql instances create ops-sql- 2 --activation-policy=ALWAYS --backup --tier=db-n1-standard-2 --region=europe-west1 --gce-zone=europe-west1-b --database-version MYSQL_5_7 --require-ssl  --assign-ip --backup-start-time=02:00
ERROR: (gcloud.sql.instances.create) Invalid value for: MYSQL_5_7 is not a valid value: 

is this a bug or am I missing something weird ? If it is a bug is there a method to get these sorted ASAP as I dont want to install MYSQL_5_6 which works fine in this script

1

1 Answers

2
votes

Can you try "gcloud beta sql instances" instead of "gcloud sql instances"?

gcloud beta usually has the newest features/options: https://cloud.google.com/sdk/gcloud/reference/beta/