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
-1
votes
1answer
16 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 ...
-1
votes
1answer
43 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 ...
1
vote
1answer
22 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 ...
0
votes
0answers
21 views

Requests from docker container in Google Cloud Run Service to Google Cloud SQL takes up to 2 minutes

Im using the Google Cloud Run service to host my Spring application in a docker container. The database is running in the Google SQL service. My problem is that the requests from the application to ...
-1
votes
1answer
377 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 ...
0
votes
1answer
30 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 ...
1
vote
0answers
24 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 ...
0
votes
1answer
46 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 ...
0
votes
1answer
57 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 ...
1
vote
1answer
85 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 ...
0
votes
1answer
99 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 ...
0
votes
1answer
48 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 ...
1
vote
0answers
123 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-...
0
votes
1answer
98 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 ...
-1
votes
1answer
155 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 ...
0
votes
1answer
518 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 ...
0
votes
1answer
108 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, ...
0
votes
1answer
61 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 ...
0
votes
1answer
109 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 ...
0
votes
1answer
92 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 ...
0
votes
1answer
176 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 ...
0
votes
1answer
47 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 ...
0
votes
0answers
184 views

WordPress on Kubernetes cluster with CloudSQL: “Error establishing a database connection”

I'm new to Kubernetes. I'm following this tutorial to install a K8s cluster with WordPress connected to a CloudSQL instance: https://cloud.google.com/kubernetes-engine/docs/tutorials/persistent-disk ...
0
votes
0answers
155 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 ...
0
votes
1answer
115 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 ...
0
votes
1answer
41 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 ...
0
votes
1answer
45 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.
0
votes
1answer
53 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 ...
0
votes
2answers
121 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 ...
1
vote
2answers
629 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) ...
0
votes
1answer
343 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 ...
0
votes
1answer
182 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 ...
1
vote
1answer
150 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?
0
votes
1answer
35 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 ...
0
votes
1answer
268 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 ...
0
votes
1answer
100 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 ...
5
votes
4answers
3k views

Cannot connect to Cloud SQL Postgres from GKE via Private IP

I am having trouble accessing a Cloud SQL instance running Postgres from a GKE cluster using the database's private IP. All the documentation I've found suggests using a VPC-enabled cluster to ...
0
votes
1answer
349 views

ETL to bigquery using airflow without have permission cloud storage/ cloud sql

i have done ETL from MySql to bigQuery with python, but because i haven't permission to connect google cloud storage/ cloud sql, i must dump data and partition that by last date, this way easy but ...
0
votes
1answer
284 views

How to replicate Cloud SQL for PostgreSQL data to an external on-premise PostgreSQL DB

I've gotten a case that I need to replicate data from Cloud SQL for PostgreSQL to an external on-premise PostgreSQL DB. I've read the document and found that Cloud SQL for PostgreSQL does not support ...
0
votes
2answers
356 views

connect to GCP from my laptop using SSH certificate

I am setting up a GCP Cloud SQL instance with postgreSQL and want to connect to it from my laptop using Python and a software called QGIS. I travel a lot and my IP changes all the time so using IP ...
0
votes
1answer
129 views

Cloud SQL private IP changed suddenly

We've been using Cloud SQL for months without problems. Today we started to get a lot of HTTP 500 errors on our application logs. Upon debugging, we found out that the cause was that the private IP of ...
0
votes
0answers
92 views

Terraform create Cloud SQL replica alway get unkown provider error

Here is my tf files: https://gist.github.com/Rukeith/bd194e808adb3ecfe982a7bdda9952a4 Terraform Version: Terraform v0.12.6 + provider.google-beta v2.12.0 + provider.random v2.2.0 Terraform got an ...
1
vote
1answer
832 views

Save more then 7 days backup for Google Cloud SQL

In the following link https://cloud.google.com/sql/faq it says: MySQL Second Generation instances: The most recent 7 automated backups, and all on-demand backups, are retained. They are charged at the ...
1
vote
2answers
2k views

How to call pg_dump from Google Cloud SQL

I am looking for a solution to backup my Cloud SQL schemas (and Cloud Storage files). At first I tried using Cloud Scheduler to call the googleapis (https://cloud.google.com/sql/docs/postgres/import-...
2
votes
2answers
2k views

Can't Connect from GCP AppEngine to GCP Cloud SQL

I have a simple Java servlet app, deployed to the GCP AppEngine. Under the same GCP, I have created a MySQL instance of GCP Cloud SQL. I would like to save the value on MySQL server when someone ...
0
votes
1answer
943 views

What could be causing the Google Cloud SQL MySQL replica instances to be stuck on a “System lock” state, causing huge replication delays?

Let me explain the problem in detail, We have a Google cloud SQL setup(1 master, 1 failover replica and a read replica). From the last two days, we are facing replication delays on both the replica ...
1
vote
2answers
115 views

Cannot Upgrade Google Cloud SQL to Second Generation

I cannot upgrade the First generation Google Cloud Instance to Second generation instance using MySQL Second Generation upgrade wizard in console. During the check configuration screen, I get Tables ...
0
votes
1answer
320 views

failed to delete a cloud sql instance

I failed to delete a cloud sql instance. gcloud sql instances delete $SQL_INSTANCE --quiet --project=$GCP_PROJECT ERROR: (gcloud.sql.instances.delete) HTTPError 409: Operation failed because ...
0
votes
0answers
139 views

Constantly Restarting of SQL Instances in GCP

I have 4 instances of SQL in GCP, all of this are restarting constantly. This is the log from one of this: From today this problem is happening, and they go 5 times on this day, I can not find more ...
2
votes
1answer
838 views

How to configure Cloud SQL Postgres to require SSL but not client certificates?

Is there a way to create a Cloud SQL Postgres instance that Enforces SSL/TLS, but that does not require the use of client certificates? In pg_hba.conf, this would be a line containing hostssl but not ...