Questions tagged [google-cloud-sql]

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that operate from Google's Cloud Platform.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that operate from Google's Cloud Platform.

133 questions
0
votes
2 answers

connect to GCP from my laptop using SSH certificate

I am setting up a GCP Cloud SQL instance with postgreSQL and want to connect to it from my laptop using Python and a software called QGIS. I travel a lot and my IP changes all the time so using IP whitelisting is a pain. Is there a way to have…
0
votes
1 answer

Cloud SQL private IP changed suddenly

We've been using Cloud SQL for months without problems. Today we started to get a lot of HTTP 500 errors on our application logs. Upon debugging, we found out that the cause was that the private IP of our Cloud SQL PostgreSQL instance changed from…
martintama
  • 181
  • 3
0
votes
0 answers

Terraform create Cloud SQL replica alway get unkown provider error

Here is my tf files: https://gist.github.com/Rukeith/bd194e808adb3ecfe982a7bdda9952a4 Terraform Version: Terraform v0.12.6 + provider.google-beta v2.12.0 + provider.random v2.2.0 Terraform got an error, while cloud SQL read replica finish creation…
Rukeith
  • 123
  • 7
0
votes
3 answers

gcloud app deploy error --> ERROR: (gcloud.app.deploy) Error Response: [13] An internal error occurred

I am new on gcloud apps, need help on deployment web apps. I created an App Engine and a Cloud SQL for MYSQL, it is in a different project. Let's call App Engine as web1 and sql as mysql1. When I deployed web1 using "gcloud app deploy app.yaml", the…
0
votes
1 answer

failed to delete a cloud sql instance

I failed to delete a cloud sql instance. gcloud sql instances delete $SQL_INSTANCE --quiet --project=$GCP_PROJECT ERROR: (gcloud.sql.instances.delete) HTTPError 409: Operation failed because another operation was already in progress. Even I…
0
votes
0 answers

Constantly Restarting of SQL Instances in GCP

I have 4 instances of SQL in GCP, all of this are restarting constantly. This is the log from one of this: From today this problem is happening, and they go 5 times on this day, I can not find more information. Please, any ideas of what I have to…
0
votes
1 answer

SQL CSV Import Issue

I have a few SQL instances on the Cloud platform where we house a large amount of marketing analytics data. We have been manually importing CSV files daily into our instances in order to update daily figures, but as of yesterday, this import has no…
0
votes
1 answer

Possible to avoid cost increase in move to GCP MySQL Second Generation?

I was using pay-per-use with MySQL first generation. It was a website with all I was using pay-per-use with MySQL first generation. It's for a website with all pages cached in memcached and only evicted from cache when I update content. Writes to…
Daniel
  • 109
  • 1
0
votes
2 answers

Export data to Google Cloud Storage. Cloud SQL Export. Do not work at all

I want to export from Google Cloud SQL with function Export, in a cloud bucket. But do not work at all. Nothing happen. There is a bug. It's not first time when I made exports, but right now the export function do not work. Any ideas? Explained…
Alexcsandru
  • 29
  • 1
  • 3
0
votes
1 answer

Fast Google Cloud SQL

I have always set up machines to have a typical LAMP set up and recently I've been testing an external database set up with Google Cloud SQL. The performance hits I'm taking from it seem a bit unreasonable though. The average load speed of my…
0
votes
1 answer

Looking for a way to pause or quiesce a database on google cloud platform

Is there a way to pause or quiesce a database on google cloud platform to reduce costs yet maintain the data? If not, do any of the cloud database providers offer such a feature?
opike
  • 133
  • 1
  • 9
0
votes
1 answer

Do the MySQL time_zone* tables get updated automatically on Google Cloud Platform?

We use a MySQL 2nd Gen 5.7 instance on Google Cloud Platform. I've seen the mysql.time_zone* tables already contain timezone information. Will this information be updated automatically when timezones change? On our baremetal systems we're used to…
dkellner
  • 3
  • 2
0
votes
1 answer

Refresh Google Cloud SQL MySQL server SSL certificate without downtime?

If I connect using SSL to a Google Cloud SQL 2nd gen MySQL server, the certificate is self-signed and it appears that the certificate only lasts 1 year. Before the year is up, I can refresh the certificate using gcloud sql instances reset-ssl-config…
yonran
  • 797
  • 2
  • 11
  • 22
0
votes
1 answer

What are the default innodb google cloud mysql settings?

I am specifically needing information on the innodb_log_file_size and innodb_buffer_pool_size. The link below is the only info I could find but it doesn't mention the settings I'm looking for. I don't require the ability to edit the setting (though…
Jeff
  • 309
  • 3
  • 13
0
votes
1 answer

Google Cloud SQL using more storage than needed

I've recently moved some MySQL hosting from a virtual server at Digital Ocean to Google's Cloud SQL hosting. It took several goes to import the database and I didn't notice until afterwards that each time I deleted a database in the Google console…
Caedmon
  • 123
  • 6
1 2 3
8 9