Stack Overflow
Stack Overflow

Questions tagged [google-cloud-sql]

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

Intro and features

Developer documentation

FAQ

3725 questions
42
votes
7 answers

How to connect Google Cloud SQL from Cloud Functions?

I am trying to use Cloud Functions for Firebase to build an API that talks with a Google Cloud SQL (PostgreSQL) instance. I am using HTTP(S) trigger. When I white-list my desktop's IP address, I can connect to the Cloud SQL with the function's…
Quang Van
  • 11,475
  • 12
  • 57
  • 61
41
votes
3 answers

How to increase the connection limit for the Google Cloud SQL Postgres database?

The number of connections for Google Cloud SQL PostgreSQL databases is relatively low. Depending on the plan this is somewhere between 25 and 500, while the limit for MySQL in Google Cloud SQL is between 250 and 4000, reaching 4000 very quickly. We…
Florian Merz
  • 415
  • 1
  • 4
  • 4
39
votes
4 answers

What's the difference between Google Cloud Spanner and Cloud SQL?

I am novice in GCP stack so I am so confused about amount GCP technologies for storing data: https://cloud.google.com/products/storage Although google cloud spanner is not mentioned in the article above I know that it is exist and iti is used for…
gstackoverflow
  • 36,709
  • 117
  • 359
  • 710
37
votes
2 answers

Specifying the DB to connect with gcloud sql

When connecting to a Google Cloud SQL instance, is there a way to specify the database I want to connect to? This is the command I execute and the error I get: $ gcloud beta sql connect MY_INSTANCE --user=MY_USER Whitelisting your IP for incoming…
Daniel
  • 21,933
  • 14
  • 72
  • 101
36
votes
8 answers

Kubernetes: stop CloudSQL-proxy sidecar container in multi container Pod/Job

I have a Kubernetes JOB that does database migrations on a CloudSQL database. One way to access the CloudSQL database from GKE is to use the CloudSQL-proxy container and then connect via localhost. Great - that's working so far. But because I'm…
Philipp Kyeck
  • 18,402
  • 15
  • 86
  • 123
35
votes
5 answers

Can SQLAlchemy be used with Google Cloud SQL?

I've looked over Google Cloud SQL's documentation and various searches, but I can't find out whether it is possible to use SQLAlchemy with Google Cloud SQL, and if so, what the connection URI should be. I'm looking to use the Flask-SQLAlchemy…
Sean Lynch
  • 6,267
  • 2
  • 43
  • 45
32
votes
1 answer

Local MySQLdb connection fails with AttributeError for paramstyle when running GAE development server

I'm building a GAE Flask application with Flask-Alchemy, against Cloud SQL, and running dev_appserver to test the application as I build it. However, if I set the SQLALCHEMY_DATABASE_URI to a mysql+gaerdbms:///appname?instance=instanceid URL, I get…
Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
31
votes
2 answers

Google Cloud SQL increasing size until full disk with no reason

I don't know how to explain this well, but I will try. I use Google Cloud SQL second edition with 20 GB disk size. I have several wp. databases with 166.5 MB Total size. And right now my Storage usage is 9.52 GB! (With 166.5 MB SQL data...) and…
Alexcsandru
  • 387
  • 3
  • 9
31
votes
5 answers

Google Cloud SQL is slow

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 instance of MySQL 5.5, it takes only 1 ms. My dev machine…
andriys
  • 2,202
  • 2
  • 19
  • 24
27
votes
4 answers

Is there a way to access google cloud SQL via proxy inside docker container

I have multiple docker machines(dev,staging) running on Google Compute Engine which hosts Django servers(this needs access to Google Cloud SQL access). I have multiple Google Cloud SQL instances running, and each instance is used by respective…
rrmerugu
  • 1,826
  • 2
  • 20
  • 26
27
votes
4 answers

Google Cloud SQL proxy couldn't find default credentials

I'm trying to run Google Cloud SQL proxy locally like this: $ ./cloud_sql_proxy -instances project-name:region-name:instance-id tcp:3306 But it's returning google: could not find default credentials. See…
starleaf1
  • 2,701
  • 6
  • 37
  • 66
25
votes
2 answers

unrecognized configuration parameter "default table access method" google cloud

I try to import some files to a PostgreSQL database but I get this error: Falha Importar: SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET Import error: exit status 3 ERROR: unrecognized configuration parameter…
Mauricio Crispim
  • 459
  • 1
  • 4
  • 12
25
votes
3 answers

How to securely connect to Cloud SQL from Cloud Run?

How do I connect to the database on Cloud SQL without having to add my credentials file inside the container?
gabidavila
  • 992
  • 1
  • 9
  • 17
25
votes
2 answers

Generating DDL statements of database from Google Cloud Sql using eclipse cause issue in script?

I connected to a Google Cloud SQL database from eclipse using Data Source explorer. But when I generate DDL of that database using its option Generate DDL, I can't get the AUTO_INCREMENT in my script but get the corresponding primary key. How would…
Master Mind
  • 2,386
  • 3
  • 31
  • 48
24
votes
1 answer

Connect to a database over a unix socket using SQLAlchemy

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?unix_socket=/cloudsql/$DB_INSTANCE Which gives me the…
Martinffx
  • 2,426
  • 4
  • 33
  • 60
1
2 3
…
99 100