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
8
votes
5
answers
5k
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 ...
6
votes
3
answers
4k
views
Access Google Cloud SQL via VPN tunnel
We have a VPN tunnel from the office to the Google Cloud. It's working correctly, we are able to hit VMs and containers (kubernetes).
The problem is that the SQL instance can't be accessed using this ...
6
votes
2
answers
237
views
Am I doing Google Cloud deployment wrong?
I've previously used Heroku and AWS and am now setting up a service on the Google Cloud platform using App Engine and Cloud SQL (Postgres).
We've tried to build the app using 12 factor principles.
...
5
votes
1
answer
3k
views
Issue Connecting to Cloud SQL Postgres using Private IP from GKE
Steps I have followed:
1. Create VPC network
gcloud compute networks create stg-vpc \
--subnet-mode custom
2. Create IP range for VPC Peering for this network
gcloud beta compute addresses ...
4
votes
3
answers
3k
views
Google Cloud SQL authorize Auto Scale Instance Groups
I have an instance group set up with Auto Scaling and Load Balancing. I'm also using Google Cloud SQL for the MySQL server.
Whenever instance group scales up and adds another instance, the instance ...
4
votes
1
answer
4k
views
Google cloud SQL: error during import of Postgresql dump with extensions
I'm trying to import dump with extensions it it, excerpt from SQL:
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
...
- 171
4
votes
2
answers
719
views
"Could not complete the operation" when trying to add an authorized network to Cloud SQL instance
I'm trying to add an authorized network to our cloud sql instance, but each time I click Save I get told Could not complete the operation. That's it unfortunately, there's no explanation as to what ...
4
votes
1
answer
3k
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 ...
- 797
3
votes
1
answer
3k
views
Passwordless user for Google Cloud SQL (MySQL) using Cloud SQL Proxy?
The documentation About the Cloud SQL Proxy contains a line, “[B]ecause the proxy always connects from a hostname that cannot be accessed except by the proxy, you can create a user account that can be ...
3
votes
2
answers
978
views
Giving friendly names to authorised networks via gcloud command
I'm authorising instances access to PostgreSQL via the gcloud command:
gcloud sql instances patch blah-sql-dev --authorized-networks 10.1.1.2/32,10.1.1.3/32,.....
What I'm seeing under Cloud SQL's ...
2
votes
3
answers
52k
views
Centos7 systemctl start unit not found
I look everywhere and just for the life of me figure out why systemctl would not start my unit.
I am trying to start GCP's cloud-sql-proxy as a systemd service. This is what my cloud-sql-proxy....
- 143
2
votes
2
answers
2k
views
Google Cloud with SQL Server Express - add database permissions
I've recently setup a google cloud server for the first time and I installed the asp.net framework which is marketed as "Windows dev stack featuring IIS, SQL Express and ASP.NET". I'm familiar with ...
2
votes
2
answers
6k
views
GCP: Permission denied to execute cloud_sql_proxy within Compute VM
I've created my first Compute instance with container-optimized OS and following scopes:
Cloud SQL Enabled
Compute Engine Read Write
Service Control Enabled
Service Management ...
2
votes
3
answers
7k
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
3
answers
1k
views
GCP Private IP CloudSQL
I have configured private Service Access for CloudSql from my VPC. My VPC has 2 subnets in regions us-west1 and us-central1.
The issue is:
My app is NOT able to connect to the CloudSQL instance ...
2
votes
1
answer
1k
views
How to connect to Cloud SQL MySQL database from App Engine?
I am currently setting up an open-source marketing software called Mautic on App Engine Flexible Environment. However, I'm having trouble with connecting the App Engine to the Cloud SQL MySQL database ...
2
votes
1
answer
298
views
Is Google Cloud SQL fault tolerant when there is replica?
I'm running a Google Cloud SQL instance ("mysql-master") and it has one replica. ("mysql-replica")
Web apps on another servers read and write data on the Cloud SQL instance.
While mysql-master is ...
- 137
2
votes
2
answers
3k
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 ...
2
votes
1
answer
704
views
Google Cloud SQL / App Engine concurrency limits
I've been using Google App Engine to host my APIs and keep banging up against the limitation of concurrent database connections. The docs say that you can only have up to 12 concurrent connections per ...
2
votes
1
answer
239
views
CloudSQL ERROR 2013 from GCE instance
From a GCE instance, I am executing the following from command line
> mysql -udbase -p -DmyDb -hmyIp
>
> mysql> SELECT account, count(account)
> -> FROM `headers`
> ->...
2
votes
2
answers
1k
views
GCP Cloud SQL postgres in bad state after maintenance
There was what looks like a planned maintenance in our HA managed postgres cloud sql instance and it's in a bad state since.
Jan 7, 2018, 2:08:21 AM Update An unknown error occurred.
The ...
2
votes
2
answers
2k
views
Accessing Google Cloud SQL through a Google proxy
I'm looking for a way to expose my google cloud sql server (running mysql), to my api servers.
I might add/remove them in the future and adding them mysql access is an additional step 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 ...
1
vote
1
answer
355
views
Connect MySQL with Cloud Storage in GCP
I am designing a network infrastructure, I am really new to this, I already have the initial part of the infrastructure defined, but now I find a detail, I need to design a scheme for data storage, ...
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 ...
1
vote
1
answer
482
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?
1
vote
2
answers
2k
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 ...
- 177
1
vote
1
answer
927
views
Point in Time recovery for PostgreSQL running on google cloud
As titled, Google cloud supports point-in-time recovery for MySQL. GC also supports PostgreSQL. But does GC support Point in time recovery for PostgreSQL ? I can't see any documentation that it does - ...
1
vote
2
answers
2k
views
Can't restore Google Cloud SQL instance
I'm trying to restore my Google Cloud SQL instance to a backup from a previous date:
gcloud sql backups restore 1504554300110 --restore-instance=[MY-DB-INSTANCE]
Ultimately, it keeps giving an error:...
1
vote
2
answers
321
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://...
1
vote
3
answers
2k
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) ...
- 21
1
vote
1
answer
1k
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 ...
- 11
1
vote
1
answer
1k
views
Google cloud SQL instance is under "maintenance mode" for an exceedingly long time
I have encountered an issue on a managed/cloud SQL where an instance has unexpectedly (also, outside the maintenance window set) entered maintenance mode and has remained unavailable for more than 10 ...
1
vote
2
answers
3k
views
SQLSTATE[HY000] [2002] No such file or directory, google cloud app engine flexible
I am trying to connect cloud sql with google cloud app engine flexible.
My code is as bellow:
$dsn = getenv('MYSQL_DSN');
$user = getenv('MYSQL_USER');
$password = getenv('MYSQL_PASSWORD');
try {
...
1
vote
2
answers
2k
views
Not able to use mysql in google app engine - Error loading MySQLdb module: No module named _mysql. I am using cloudSQL
I am using googleAppEngineLauncher to try mysql connection.
It gives the log
File "/Users/kakshilshah/Desktop/hope/skeduleBackend/django/utils/importlib.py", line 40, in import_module
...
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).
...
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
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
1
vote
2
answers
135
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 ...
1
vote
1
answer
212
views
How do I find out what's taking up most of the space on my SQL CLOUD GCP?
I could not identify what is taking up most of my SQL Cloud Storage, in the last 24 hours something wrote almost 1 Gigabit on the storage, according to the GCP dashboards.
enter image description ...
1
vote
1
answer
569
views
Google Cloud SSL server CA rotate
The Google Cloud Console is prompting us of impending expiry of the certificate on a Google Cloud SQL instance.
We have multiple services which connect to this database instance:
Compute Engine (via ...
1
vote
1
answer
99
views
Start and Stop Cloud SQL via Java mysql admin-api
I'm not able to find a way to simply start and stop a Cloud SQL instance using java mysql admin-api.
I found this official google documentation that explain how to start and stop the Cloud SQL ...
1
vote
2
answers
2k
views
Should I enable SSL on my MySQL database with Cloud SQL?
I was wondering if I should enable SSL with my Cloud SQL (Google Cloud Platform) instance. I communicate with the database via a Laravel (PHP) application and specified that the IP address of my ...
- 113
1
vote
1
answer
1k
views
Google Cloud SQL with Google app engine in PHP
Having trouble connecting Laravel 5.2 on Google Cloud.
I created a new MySQL 5.6 second generation instance, and added the connection parameters in conf/database with the external ip of the instance, ...
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
...
1
vote
0
answers
96
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 ...
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 ...
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-...
1
vote
1
answer
2k
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 ...
- 13
1
vote
1
answer
828
views
Best Cloud SQL Proxy setup in Kubernetes Cluster
Based on its github page, it is recommended to be set up as a sidecar container as opposed to a cluster service. My question would be, is there any possible issues (e.g. performance, no. of ...
- 11
Related Tags
mysql × 27
postgresql × 18
google-app-engine × 18
database × 6
vpc-peering × 5
php × 4
ssl × 4
sql-server × 4
python × 4
gcloud × 4
kubernetes × 3
sql × 3
replication × 3
google-cloud-vpn × 3
django × 2
cloud × 2
gcp × 2
ssh × 1
apache-2.4 × 1
backup × 1
more related tags
Hot Network Questions
- Does distance exist in thermodynamic coordinates?
- Have there been any Spacewalks to free-flying satellites?
- In Princes of the Apocalypse, is this monster “supposed to” kill a player character?
- How do I reset file ownership at the command line when the files are owned by users from a dead domain?
- What was the role of Schmidt in derivation of the Gram-Schmidt process?
- Closed formula for number of ones in a proper factor tree
- Accepted postdoc offer retracted last minute
- Why "quod" and not "quo" is used here?
- Can a spaceship "hitchhike" on an explosion to escape a gravity well?
- Issue with the Hook Modifier in Curve Distortion
- What is the meaning of "life of the collar"?
- Why does the US still maintain so many military facilities in Western Europe?
- If Else Conditions in Bash
- Can we hit the spaceship
- What would happen if a small black hole fell into a star?
- How to let a recruiter know you're not seriously considering another job but you are exploring your options
- Chain drops when shifting up a gear at the front?
- How do I show employers that a long commute won't hinder my ability to perform my assigned duties?
- Deciding to not apply to a college that I have met with a faculty member, advice on what to do
- What is the minimal density of a set A such that A+A = N?
- How could medieval people get into space?
- Indonesia visa misprint by consulate
- What is the lowest CR creature that can defeat an Ancient Red Dragon in open combat, and how many of them does it take?
- bullet resistant space armor material?