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.
135
questions
0
votes
1
answer
44
views
Issues connecting Data Fusion to CloudSQL Postgres instance - getting a 403 "The client is not authorized to make this request"
I've got DataFusion and Cloud SQL Postgres up and running in a single GCP project.
I can connect to my postgres instance successfully using pgAdmin (as long as I add my IP address to the allowed ...
0
votes
0
answers
99
views
Unable to setup pglogical replication between 2 GCP CloudSQL instances
I'm currently trying to setup pglogical replication between 2 GCP CloudSQL Postgres instances, in order to quickly migrate data between regions.
I've following the GCP docs[1] by creating a replicator ...
0
votes
1
answer
256
views
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 ...
- 2,195
0
votes
1
answer
749
views
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 ...
- 2,195
0
votes
1
answer
232
views
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=...
- 356
0
votes
1
answer
21
views
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 ...
0
votes
1
answer
272
views
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 ...
0
votes
0
answers
108
views
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.
...
0
votes
1
answer
52
views
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 ...
1
vote
1
answer
1k
views
Cloud SQL MySQL 8.0.26 Intermittent "Got timeout reading communication packets" error in App engine flex + Node.js app
We're running node.js servers on App engine flexible that are connecting to mysql using a shared private network. (app engine instances are deployed into the same vpc subnetwork that mysql lives in).
...
2
votes
2
answers
3k
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 ...
0
votes
2
answers
118
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 ...
0
votes
1
answer
125
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 ...
0
votes
1
answer
826
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 ...
1
vote
2
answers
322
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://...
0
votes
1
answer
465
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 ...
0
votes
1
answer
848
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.
0
votes
1
answer
348
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 ...
- 117
1
vote
1
answer
1k
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
...
0
votes
2
answers
977
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 ...
0
votes
2
answers
182
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 ...
0
votes
1
answer
230
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 ...
- 3
0
votes
0
answers
177
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 ...
0
votes
1
answer
433
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
1
answer
489
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
1
answer
53
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 ...
- 11
-2
votes
1
answer
845
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
1
answer
1k
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
0
answers
97
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
1
answer
689
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 ...
- 4,243
0
votes
1
answer
282
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
2
answers
1k
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
1
answer
389
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
1
answer
142
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
0
answers
597
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
1
answer
823
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 ...
0
votes
1
answer
951
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 ...
1
vote
1
answer
2k
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
1
answer
354
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
1
answer
279
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
1
answer
313
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 ...
- 101
0
votes
1
answer
155
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
1
answer
774
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 ...
1
vote
1
answer
2k
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 ...
- 11
0
votes
0
answers
306
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
1
answer
372
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
1
answer
148
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
1
answer
457
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
1
answer
201
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
2
answers
334
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 ...
Related Tags
mysql × 27
postgresql × 18
google-app-engine × 18
database × 6
vpc-peering × 5
gcloud × 4
php × 4
python × 4
sql-server × 4
ssl × 4
replication × 3
kubernetes × 3
google-cloud-vpn × 3
sql × 3
cloud × 2
django × 2
gcp × 2
google-iam × 1
psql × 1
proxy × 1
more related tags
Hot Network Questions
- Proper use of "-ing" + "to: in the begging of a sentence
- Transit through Thailand. Indian passport holder
- Frame size of Cannondale Synapse
- Does energy exist on its own?
- Can my boss sue me for handing in my notice
- What range of altitudes would not be fatal for an astronaut falling from height on the moon?
- What happens if one uses a credit card to enter the MRT in Singapore, and then uses another credit card under the same name to exit?
- Sum of sinusoids at the same frequency but with different amplitudes and phases
- Matrix Class Implementation
- Can Lord Shiva give positions of all Gods including the position of Vishnu and Brahma?
- How much entropy is lost due to collision?
- PSE Advent Calendar 2023 (Day 7): The Oracle Rambles On and On
- Was it legal according to Ukrainian law to kill Illya Kyva?
- Looking for title of story of aliens that bred earthlings to be warlike
- Is it possible to change red to blue on my display? Basically swap the colors
- Can the chefs go?
- Can NPC's be tricked into giving verbal consent to a spell that they would otherwise resist due to the wording of the spell?
- Urgent: can you get from Frankfurt Flughafen to Frankfurt City today (Dec 8 2023)?
- Does Archon of Coronation prevent life loss in two-headed giant if my teammate is the defending player?
- Difference between Backup and Snapshot
- How to transport armies across Faerûn?
- What is the meaning of the "Tall Trees" joke in Groundhog Day?
- Progress indicator when using a for loop to parse txt file
- UK crew working on cruise ship in Schengen area: does Seaman's Book stop passport being stamped at airport on arrival in the country before boarding?