Server Fault Stack Exchange
Server Fault Stack Exchange

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
1 answer

How do I configure SSL/TLS to connect to a Cloud SQL instance?

As far as I can see connection over SSL/TLS is always available with Cloud SQL. If I enforce it, it becomes required. But the maximum level of protection I was able reach is verify-ca from the perspective of both the client and the server. That…
x-yuri
  • 2,141
  • 2
  • 24
  • 29
0
votes
1 answer

Is password needed when connecting via Cloud SQL Auth Proxy?

It seems like it's needed, because it asks me for the password. But if so, then what's the point in having 2 credentials (a credentials file + password)? If not, then what am I missing? The docs is not too revealing about this: If prompted, enter…
x-yuri
  • 2,141
  • 2
  • 24
  • 29
0
votes
1 answer

How to connect to a GCP Cloud SQL Postgres server using client certs?

I'm attempting to authenticate with a cloud SQL instance using a client cert: psql -h "$IP" "sslmode=verify-ca sslkey=certs/tls.key sslcert=certs/tls.crt sslrootcert=certs/ca.crt dbname=postgres" Password for user root: The server's cert is in…
Thanatos
  • 356
  • 3
  • 12
0
votes
1 answer

CloudSQL Programming Language Support

I was told by a third-party vendor that Python, JavaScript, and potentially other programming languages cannot be installed on CloudSQL. I am trying to verify if this is true, and if so, why is this the case?
Eileen Kovach
  • 1
0
votes
1 answer

Connect to Cloud SQL from Google Cloud Functions

I have a few already deployed and running functions that use a custom VPC connector (projects/dc-****/locations/us-east1/connectors/serverless-vpc-dev-use), then I created a Cloud SQL from scratch with only the public IP. I've been able to connect…
juliano.net
  • 101
0
votes
0 answers

My GCP MySQL 8 CloudSQL Database, Randomly Restarts without a clue

I using a mysql instance on cloud sql. However this instances began to restart the mysqld (mysql deamon) several times per day. It was not due a change or anything, but just increasing like this. every time the instance is restarted we lost near 1…
Daniel Santos
  • 168
  • 1
  • 9
0
votes
1 answer

GCP - what are mysql-access instances?

I have my application deployed to AppEngine Standard and connects to Cloud SQL via public IP. I was looking at VM instances dashboard and found a set of instances with the following naming pattern and these are alerting for high cpu…
Chaitanya
  • 101
  • 1
0
votes
2 answers

Why do I have 5/4 active MySQL connections at all times?

Ive created a MySQL 5.7 instance on google SQL and from the very first day, for no apparent reason, I've had 4/5 active connections at all time. Those connections are definitely not me and, from what I understand, I am having to pay for that usage…
user3402600
  • 1
  • 1
0
votes
1 answer

In DataPrep, How to create connection with instance of sql without public ip on google cloud platform?

In Dataprep, when creating the connection there is the 'Test Connection' button, after filling in all the connection data, with the private ip, port, username and password, I click on the test button and I get the error [Unable to connect to host]…
Rafael Galle
  • 1
0
votes
1 answer

Google Cloud SQL - Database instance storage size increased dramatically everyday

I have a database instance (MySQL 8) on Google Cloud and since 20 days ago, the instance's storage usage just keeps increasing (approx 2Gb every single day!). But I couldn't find out why. What I have done: Take a look at Point-in-time recovery…
Thien Nguyen
  • 11
  • 1
0
votes
1 answer

How to sync GCP Cloud Storage Bucket metadata to a database?

I have a large number of objects, currently around 1 million, stored in a GCP Cloud Storage Bucket. Objects are added at a rate of 1-2 thousand per day. I would like to efficiently run queries to look up objects in the bucket based on the metadata…
sffc
  • 382
  • 1
  • 3
  • 11
0
votes
1 answer

Google cloud sql read replica consistency

Does Google Cloud SQL read replicas guarantees consistency? And how long does it take to replicate from primary to read replicas typically? I can't find information on the above two questions.
william007
  • 117
  • 6
0
votes
1 answer

1 million concurrent database connections

In https://cloud.google.com/sql/docs/quotas, it mentioned that "Cloud Run services are limited to 100 connections to a Cloud SQL database.". Assume I deploy my service as Cloud Run, what's the right way to handle 1 million concurrent connections?…
william007
  • 117
  • 6
0
votes
2 answers

Is it possible to specify an existing CloudSQL instance as the destination for the database migration service in GCP?

According the GCP guides, setting up a database migration involves creating a migration job in the console using the wizard [1]. The wizard creates a new CloudSQL instance, but I would like to specify an existing instance such that we can manage the…
buildwithjz
  • 1
  • 1
0
votes
2 answers

Connecting to Google Cloud MySql DB with a changing IP address

I connect to a Google Cloud MySql db from my laptop, however my IP address not only changes at home, but also when I travel. I have to specify the allowed public ip address in Google Cloud, but every time I reconnect I have to log in & update google…
Jaco
  • 1
1 2 3
…
8 9