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
22
votes
5 answers

PHP MySQL over SSL. Peer certificate did not match

I'm trying to use Google Cloud SQL over SSL from GCE(Google Compute Engine) instance. My problem is that I cannot connect to Cloud SQL instance over SSL. mysql command works normally. I can connect to Cloud SQL instance with certification…
zono
  • 8,366
  • 21
  • 75
  • 113
21
votes
2 answers

Confusion Around Creating a VPC Access Connector

I am trying to set up Serverless VPC access Serverless VPC Access enables you to connect from your Cloud Functions directly to Compute Engine VM instances, Memorystore instances, Cloud SQL instances, Sounds great. But the documentation is not…
1252748
  • 14,597
  • 32
  • 109
  • 229
21
votes
5 answers

Permissions For Google Cloud SQL Import Using Service Accounts

I've exported MySQL Database following the MySQL Export Guide successfully. Now, I'm trying to import MySQL Database following the MySQL Import Guide. I've checked the permissions for the service_account_email I'm using, and I have allowed both…
Franz Noel
  • 1,820
  • 2
  • 23
  • 50
21
votes
3 answers

Verify/change application region at Google App Engine

I'm creating a GAE application. When I set my GAE PHP application as an authorized application to access my Cloud SQL instance, I get the following warning: App Engine regions must be the same as Cloud SQL instance regions! How can I verify or…
fbysaputri
  • 211
  • 1
  • 2
  • 4
20
votes
5 answers

Run node.js database migrations on Google Cloud SQL during Google Cloud Build

I would like to run database migrations written in node.js during the Cloud Build process. Currently, the database migration command is being executed but it seems that the Cloud Build process does not have access to connect to Cloud SQL via an IP…
Francis Malloch
  • 1,074
  • 9
  • 20
19
votes
5 answers

Java Google App Engine and Google Cloud SQL running on local dev server

I've been researching a solution to this all week and while there have been solutions to similar problems there are none that address and rectify this problem directly. I have created a web application project using Google App Engine and Google…
Ben B
  • 562
  • 1
  • 5
  • 14
19
votes
2 answers

BigQuery vs Cloud SQL for dashboards backend

I'm a bit confused about BQ vs Cloud SQL use cases. I've got few Gbs of row data in BQ and need to build web dashboards on that data (SQL with JOINs over several tables). Is there a big downside of querying data right from BQ (e.g. latency or…
syldman
  • 505
  • 1
  • 6
  • 18
19
votes
1 answer

Export from Google BigQuery into CloudSQL?

I want to dump data from BigQuery (i.e. reports) into a CloudSQL database, what is the best way to achieve this programatically? I realise I could do this manually by running a BigQuery query, downloading it as a CSV, then uploading it through the…
p_mcp
  • 2,643
  • 8
  • 36
  • 75
18
votes
1 answer

Downloading a Google Cloud SQL Backup

I'm running an instance of Google Cloud SQL. A CMS connects to this and updates it. Then there are several replications that run websites. Someone using the CMS deleted a page by accident. There's a backup from 12 hours ago, but I don't want to…
Kenzo
  • 3,513
  • 4
  • 17
  • 16
18
votes
1 answer

Dealing with Concurrent Requests & Connections in Cloud SQL

We have created an app on App Engine using Datastore. Now we have been led to using Cloud SQL as we wanted to use joins, nested queries and functions such as average, total etc. Data gets migrated from Datastore to Cloud SQL by daily Cron jobs. I…
Kartik Domadiya
  • 29,868
  • 19
  • 93
  • 104
17
votes
2 answers

Sequelize.authenticate() do not working (no success or error response) for google cloud sql connection inside Docker

I am building api server with typescript ,express and Sequelize. This is my database connection class. export class Database { private _sequelize: Sequelize; private config: DBConfigGroup = dbConfig; private env = process.env.NODE_ENV as…
Varis Darasirikul
  • 3,907
  • 9
  • 40
  • 75
17
votes
4 answers

Logging slow queries on Google Cloud SQL PostgreSQL instances

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 queries above a specific threshold (e.g. 250ms). By…
Francesco Casula
  • 26,184
  • 15
  • 132
  • 131
17
votes
2 answers

Google Cloud SQL Storage Usage High Issue

We have Setup Cloud SQL in google cloud with configuration of Tier db-n1-standard-4 with storage of 100GB SSD. My actual database size is having only 160MB Max but in Cloud Cloud SQL instances it showing up to 72GB used i don't know why? and its…
Rupesh kumar
  • 390
  • 2
  • 9
17
votes
2 answers

Connecting to multiple CloudSQL instances using Cloud sql proxy?

I'm attempting to use the cloud sql proxy to connect to 2 different cloud sql instances... In the docs I found a line about Use -instances parameter. For multiple instances, use a comma-separated list. but not sure how to make that look.…
glesage
  • 955
  • 2
  • 16
  • 31
17
votes
3 answers

Datastore vs Cloud SQL in Google App Engine

I want to build an application that will serve a lot of people (more than 2 million) so I think that I should use Google Cloud Datastore. However I also know that there is an option to use Google Cloud SQL and still serve a lot of people using mySQL…
user3376321
  • 849
  • 2
  • 9
  • 21
1
2
3
…
99 100