google-cloud-sql Questions
2
Solved
I recently upgraded a Postgres 9.6 instance to 11.1 on Google Cloud SQL. Since then I've begun to notice a large number of the following error across multiple queries:
org.postgresql.util.PSQLEx...
Odiliaodille asked 23/4, 2019 at 1:17
1
I use the following Terraform configuration to try to create a subnet and a Cloud SQL MySQL 5.6 instance on Google Cloud Platform.
resource "google_compute_network" "default" {
name = "my-default...
Advantage asked 25/2, 2019 at 11:42
3
Solved
is it possible to access Google Cloud SQL from Google Compute Engine using the private network?
It appears that Google Cloud SQL sees the public network IP for the Google Compute Engine instance....
Hammerlock asked 6/4, 2014 at 8:33
4
Solved
The company I work for uses Google Cloud SQL to manage their SQL databases in production.
We're having performance issues and I thought it'd be a good idea (among other things) to see/monitor all ...
Shellyshelman asked 2/5, 2018 at 15:30
1
Trying to figure out what would be better:
Multiple instances, one per DB
or
Single large instance which will hold multiple DBs inside
The scenario is similar to Jira Cloud where each customer ...
Vudimir asked 3/4, 2019 at 5:56
3
I would like to connect my Kubernetes cluster to Google Cloud SQL.
I have at least 10 different deployed pods which presently connect to MySQL [docker image deployed to k8s] using a JDBC url + use...
Amparoampelopsis asked 15/12, 2016 at 21:4
1
Currently we are on Google Cloud and we have 5000 databases on their single Cloud SQL instance, and the server just stops every few hours, and it won't start for a few hours because of the number o...
Mascon asked 19/7, 2018 at 22:52
1
Solved
I am using Rails and am experiencing a connection pool error very randomly and it does not target any single endpoint specifically. I can hit endpoints about 70% of the time without getting this er...
Submarine asked 30/8, 2018 at 22:55
3
I have a question similar to this github issue.
But instead of using a service, can I use a daemon set instead of service? The idea is to share the same socket with all the pods on the same node. ...
Pricecutting asked 11/4, 2017 at 7:59
1
I'm trying to connect to my Cloud SQL DB using SQLAlchemy from my cloud function but I can't seem to work out the correct connection string.
DATABASE_URL=postgres://$DB_USER:$_DB_PWD@/$DB_NAME?uni...
Businesswoman asked 3/3, 2019 at 10:2
1
Solved
Our Postgres DB (hosted on Google Cloud SQL with 1 CPU, 3.7 GB of RAM, see below) consists mostly of one big ~90GB table with about ~60 million rows. The usage pattern consists almost exclusively o...
Hardtack asked 22/2, 2019 at 16:22
2
Solved
I'm trying to connect Django to the Google cloud SQL, working with python 2.7 and django 1.5 under windows. I went through the instructions on this page: https://developers.google.com/appengine/doc...
Unfavorable asked 30/9, 2013 at 4:34
3
Solved
I am trying to use the 2nd gen cloud sql and would like to change the sql mode. In the UI, I can only set sql_mode to one value from a drop-down list, but not multiple of them (eg, "STRICT_MODE_TRA...
Systematics asked 22/8, 2016 at 13:53
3
Based on the documentation, the super privilege is not supported, which means that the following query:
SET GLOBAL query_cache_size = 1000000;
results in an error message
Access denied; you ...
Statuette asked 4/6, 2015 at 21:14
5
I have a D0 size Cloud SQL instance. When I run a simple
select * from table
which has around 500 rows, it takes on average 100 ms to execute (as reported by SQL Prompt). Whereas on my local ins...
Pentane asked 4/9, 2013 at 15:37
1
I connected as the postgres user to the database I'm using. E.g. app_production. Then I ran these commands, as described in Create a read-only user in PostgreSQL:
app_production=> GRANT USAGE O...
Nab asked 24/1, 2019 at 12:21
2
Solved
I need to somehow convert a v10 dump file into one which is 9.6 compatible
Google's Cloud SQL runs PostgreSQL version 9.6 and my database has been running on version 10 since its creation.
THE ...
Hui asked 29/3, 2018 at 3:35
1
Solved
Cloud SQL documentation about connecting with external apps didn't helped me much. Isn't there some library to handle data traffic like Firebase's Cloud Firestore and Realtime Database offer?
Fic asked 13/1, 2019 at 23:53
4
Spring Boot newbie trying to get my app hosted on GCP AppEngine Flexible with Cloud SQL (mysql), second generation.
Using the Spring Cloud GCP starters that I got from here:
https://github.com/sp...
Sonometer asked 7/7, 2018 at 15:47
1
Solved
We have a simple MySQL db with a few tables, managed by Google Cloud SQL. The database has a few hundred million rows, and fairly light reading/writing. We are nowhere near the limits for storage, ...
Flowering asked 13/12, 2018 at 0:40
1
I'm trying to create a TLS connection to a Cloud SQL database but I'm getting the following error when trying to prepare a statement:
x509: cannot validate certificate for <cloud sql instance i...
Leff asked 12/12, 2018 at 22:31
2
I have exported my google Cloud SQL instance to Google Cloud Storage. I have exported the file in the compressed format (.gz) to Cloud Storage bucket. Then after I downloaded to my system and extra...
Pascal asked 17/2, 2014 at 6:24
3
Solved
I'm trying to connect to Cloud SQL from a Python application (using PyMySQL 0.7.9) running on top of Google App Engine.
My connection string looks like this (credentials are fake of course):
pymy...
Rorie asked 27/11, 2016 at 13:33
2
Solved
I'm trying to populate a mysql db with a csv that i have in cloud storage
I'm using the API Explorer to execute the request with the following request body:
{
"importContext": {
"csvImportOpti...
Inness asked 19/7, 2018 at 19:52
1
Solved
I'm attempting to connect to a CloudSQL instance via a cloudsql-proxy container on my Kubernetes deployment. I have the cloudsql credentials mounted and the value of GOOGLE_APPLICATION_CREDENTIALS ...
Fig asked 9/10, 2018 at 3:24
© 2022 - 2024 — McMap. All rights reserved.