2022 Developer Survey is open! Take survey.

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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
25 views

Google Cloud SQL failover with unknown error

We are using Google cloudsql MySQL 8.0 as our production database , HA is enable in our cloudsql instance and we export backup every 3 hours on cloud storage , I have noticed sometimes while exporting ...
user avatar
1 vote
1 answer
344 views

GCP log Explorer and slow SQL query log with Cloud SQL

Is there a way to analyze SQL Slow query logs easily on log explorer or on some other GCP tool? Now log explorer writes log entries to multiple lines (textPayload divided) and it's hard to find out ...
user avatar
  • 11
0 votes
0 answers
52 views

app engine using react.js and node.js. Our database is on Cloud SQL, when a call is made from the app, it returns with 502 error nginx

When a user clicks on the button to create a new record in the database these errors are returned: (anonymous) @ xhr.js:210 e.exports @ xhr.js:15 e.exports @ dispatchRequest.js:56 u.request @ Axios.js:...
user avatar
0 votes
2 answers
38 views

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 ...
user avatar
0 votes
1 answer
17 views

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 ...
user avatar
-1 votes
1 answer
150 views

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 ...
user avatar
1 vote
2 answers
130 views

Google Cloud - Hipaa Compliance - PgAudit vs IAM Audit Logs

Our infrastructure is hosted on Google Cloud and uses postgresql instances via Cloud SQL I need to configure logging for HIPAA compliance. I have read 2 articles from Google's documentation: https://...
user avatar
0 votes
1 answer
102 views

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 ...
user avatar
  • 362
0 votes
1 answer
179 views

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.
user avatar
0 votes
1 answer
128 views

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 ...
user avatar
0 votes
0 answers
25 views

Server updates out of maintenance window

Lately our SQL server had an update out of the maintenance time window. I want to understand a few things: Do we need to anticipate more updates to our servers which are out of the maintenance time ...
user avatar
1 vote
1 answer
550 views

Keycloak install with helm on GKE with Cloud SQL (external) database

I'm trying to install keycloak on GKE cluster in GCP with external database, i.e. CloudSQL postrges db. I want to use helm to install it, so: helm repo add bitnami https://charts.bitnami.com/bitnami ...
user avatar
0 votes
2 answers
194 views

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 ...
user avatar
0 votes
1 answer
29 views

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 ...
user avatar
  • 1
0 votes
1 answer
155 views

Google Cloud SQL Server data to BigQuery

I need to export the data that I have in a Google Cloud SQL Server database to BigQuery in order to make some data analysis and reporting. I found that the recommended way to do that is using BigQuery ...
user avatar
0 votes
0 answers
56 views

How to Avoid Network Internet Egress from Singapore to Americas from Cloud SQL on GCP

I'm looking to my billing and I realized that there is Network Internet Egress from Singapore to Americas charge on my billing which is large number. I would like to know how to set cloud SQL to avoid ...
user avatar
0 votes
1 answer
204 views

How to get Cloud SQL events?

I would like to be able to trigger a HTTP request to my server whenever my Cloud SQL instance reaches 90% CPU utilization or 80% memory utilization. Can I setup a cloud event that triggers an HTTP ...
user avatar
  • 117
-1 votes
1 answer
113 views

How can I simulate “serverless” on demand Cloud SQL?

Problem: Cloud SQL instances run indefinitely and are monetarily expensive to host. Goal: Save money while not compromising on database availability. It has been almost four years and Google Cloud has ...
user avatar
  • 117
1 vote
1 answer
28 views

Google Cloud SQL connectivity from External network

We have a requirement to directly load Cloud SQL postgres tables from On-premise server ETL solutions. What would be the recommended and secure way of doing this without migrating the ETL solution to ...
user avatar
-2 votes
1 answer
397 views

How do I enable only a single Cloud SQL DB for a GCP service account?

I have a service account that should only have access to a single instance of Cloud SQL. In GCP, I've been trying to create a role with conditional access to the instance. The instance name of the DB ...
user avatar
-1 votes
1 answer
622 views

Python app IAM service account authentication via Cloud SQL Proxy

Bug Description Hi! I'd like to authenticate as a service account to Google Cloud SQL locally using the CloudSQL Proxy. This is done via a Kubernetes sidecar container pattern with the serviceaccount ...
user avatar
1 vote
0 answers
58 views

How to connect two service producer networks in GCP?

I am using two google managed services i.e Google Cloud SQL and Google Cloud Data Fusion. The cloud data fusion private IP instance is deployed inside a google managed VPC(Let's call it A) which is ...
user avatar
0 votes
1 answer
111 views

how do I see when a cloudsql instance was created

I have a cloudsql instance Im not sure who created or when. How can I see when a cloudsql instance was created so I can know how old it is? I see nothing in the UI with created date or anything like ...
user avatar
  • 3,969
0 votes
1 answer
127 views

Cannot connect from Compute Engine instance to Cloud SQL via Private IP

In this configuration I have a Compute Engine instance in GCP running Windows Server 2019. I have two network adapters; one that is connected to the public network, and one that is connected to an ...
user avatar
  • 319
1 vote
2 answers
636 views

How to setup multiple Google Cloud SQL-instances behind one set of firewall rules?

Currently we are running multiple MySQL servers in an off-site datacenter, these servers receive connections from multiple webservers, as well as connections from 20 to 30 users from their homes, with ...
user avatar
  • 11
0 votes
1 answer
187 views

Is there a way to undelete deleted permissions in cloud IAM Admin on the google cloud platform?

I have accidentally locked myself out of my own project. It is still running with cloud SQL instances and a Kubernetes cluster, but I cannot view anything about it or stop it. I was removing ...
user avatar
0 votes
1 answer
80 views

Is the HA option for Cloud SQL also a matter of data redundancy?

I'm looking at the GCE "Cloud SQL" product, and specifically the MySQL flavour. I'm a bit confused about how this product operations in non-HA mode. I understand that in HA mode, you have a ...
user avatar
  • 1,434
1 vote
0 answers
364 views

Unable to connect to CloudSQL from GKE without CloudSQL Proxy - SQLSTATE[HY000] [2002] Operation timed out

I have GKE cluster created with following command: gcloud container clusters create stage1 \ --enable-ip-alias \ --release-channel stable \ --zone us-central1 \ --node-locations us-central1-a,us-...
user avatar
0 votes
1 answer
360 views

GCP BigQuery fedarated query to cloudsql gives connection not found error

I need to populate a BigQuery table by executing a cloud sql "federated query" ( see https://cloud.google.com/bigquery/docs/cloud-sql-federated-queries#overview to read about federated ...
user avatar
-1 votes
1 answer
490 views

Google Cloud SQL proxy randomly crashes

I am using Cloud SQL proxy on one of my compute engine instances for secure connection to MySQL. I have configured a Service account with a generated JSON file and also I have started up cloud SQL ...
user avatar
0 votes
1 answer
972 views

Setting password for MySQL root user in CLoudSQL with private IP address

How to change the password for MySQL root user in GCP CloudSQL DB instance with private IP address . I am able to change the password using the below command from Cloud Shell with Public IP gcloud ...
user avatar
  • 421
0 votes
1 answer
233 views

Private IP connection Cloud SQL Google Cloud

In the google cloud docs it is clearly stated that connectivity to Cloud SQL using private IP can be established across regions, however it's not what I see at the moment. private access was enabled, ...
user avatar
0 votes
1 answer
172 views

App Engine connection to PostgreSQL Database suddenly lost

App Engine connection to PostgreSQL Database suddenly lost My App Engine connection to its CloudSQL Database doesn't work anymore. Till yesterday (26/08/2020) I was able to use my App Engine website ...
user avatar
0 votes
1 answer
176 views

How do I permanently upgrade psql client version in Google Cloud Shell?

From this answer I need to upgrade the psql in the Google Cloud Shell. But any upgrade I do there it shows a warning like this: Note that your Cloud Shell machine is ephemeral and no system-wide ...
user avatar
  • 101
0 votes
1 answer
112 views

MySQL 8.0 in Google Cloud SQL

Currently, I see MySQL 8.0 while creating database instance in gcloud console, but I can't find documentation (and any information about support MySQL 8 in CloudSQL). May be anyone has information ...
user avatar
0 votes
1 answer
387 views

Adding a Google Cloud SQL cloudsqlproxy user

A good while ago I setup access to my Google Cloud SQL Instance on a Windows Server using the cloudsqlproxy method/mechanism. At one point I set things up adding a cloudsqlproxy user, with a username ...
user avatar
  • 35
0 votes
1 answer
477 views

Connecting to VPC internal services from Google Cloud Shell

Is it possible to access services (like CloudSQL or some custom applications) that are running on internal IPs only (VPC) from cloud shell? The idea behind it, I want to keep Cloud SQL on private IPs ...
user avatar
0 votes
0 answers
232 views

Can't run migrations in Google Cloud SQL

I'm using Laravel 5.3, and following this tutorial to get myself set up with Google Cloud: https://cloud.google.com/community/tutorials/run-laravel-on-appengine-standard I'm at the part where I'm ...
user avatar
0 votes
1 answer
227 views

Connect CloudSQL instance using Private IP via Cloud VPN Tunneling

I have two projects 1 and 2 and two vpc networks vpc1 and vpc2 in the respective projects. I need to connect to sql instance in vpc2 (project2) from vm in vpc1 project1 using private IP. After trying ...
user avatar
  • 1
0 votes
1 answer
53 views

Service account with fine grained permissions for managing PostgreSQL databases

I need to create a service account for managing (create, update, delete) PostgreSQl database instances in Cloud SQL. I was thinking to use "roles/cloudsql.editor" role, but it does not have ...
user avatar
0 votes
1 answer
130 views

How to call pg_dump from app engine

How do I call pg_dump from my .NET app engine instance? I use Google Cloud SQL. I need pg_dump to specify specific flags when exporting my database.
user avatar
  • 111
0 votes
1 answer
97 views

GCP Cloud SQL HA mySQL, which public IP to connect?

Taken from this link: https://cloud.google.com/sql/docs/mysql/high-availability#normal After setup a 2nd generation mySQL failover instance in Cloud SQL, found that actually two IP addresses were ...
user avatar
  • 103
0 votes
2 answers
205 views

Google Cloud SQL failback after manually triggering failover

I haven't been able to find any documentation on how to revert a manually triggered failover in the Google Cloud SQL service. I'm using a second generation MySQL 5.7 server. After manually triggering ...
user avatar
1 vote
2 answers
1k views

Permission issues in cloudSQL SQL Server (GCP)

I see permission error when i tried to shrink files/db in CloudSQL sql server. I know its a managed service and do not have sa user and super privileges. But is there any similar user like sa (or) ...
user avatar
0 votes
1 answer
676 views

Create tablespace in gcloud sql instances

I had created one PostgreSQL instance under gcloud database. Using default user (postgres) i want to create a tablespace but its not allowing me to create, says permission doesn't exist Can we ...
user avatar
0 votes
1 answer
335 views

How to connect to Postgres Cloud Sql without public IP from Cloud Run

There is a documentation on the Cloud SQL for Cloud Run connection(https://cloud.google.com/sql/docs/postgres/connect-run), but it contains the following line: Note: These instructions require your ...
user avatar
  • 103
1 vote
1 answer
252 views

What's the maximum number of read replicas you can create with the Cloud SQL service on Google Cloud?

I can't find this anywhere in the docs and I don't want to incur costs to figure it out. How many read replica's can you create with the Cloud SQL service on Google Cloud?
user avatar
  • 1,107
0 votes
1 answer
57 views

Opensource Cloudsqlproxy server or similar?

We've got one of our projects using a Google CloudSQL Postgres DB. We really like the cloudsqlproxy and how it keeps access to the DB locked behind our google accounts (which have 2FA). We've got ...
user avatar
  • 285
0 votes
1 answer
632 views

Cloud SQL Server get sa password

I have created an SQL Server instance in Google Cloud SQL, I have the sqlserver user but it doesn't have sysadmin permission, so I want to know if it's possible to get or reset the password of the sa ...
user avatar
  • 3
0 votes
1 answer
106 views

Get the latest PostgreSQL version available in a region

Is there any gcloud cli command or api call that I can use to see the latest/newest available PostgreSQL versions in region? I found db-versions page, but I need to check which is the latest/newest ...
user avatar