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.
141
questions
9
votes
5
answers
6k
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 ...
7
votes
3
answers
5k
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
270
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
4k
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
3
answers
8k
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-...
4
votes
1
answer
5k
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
4k
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 ...
- 827
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
1k
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
54k
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
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
302
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
745
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
243
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
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 ...
- 21
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
4k
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
1k
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,273
1
vote
1
answer
370
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
535
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
929
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
357
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
2k
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
55
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
2
answers
136
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
253
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
585
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
112
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
59
views
In GCP, how to connect to CloudSQL from another project?
I have three projects in Google Cloud Platform (GCP) under one organization: Project A, Project B, and Project C (central). Project C is using a GCP Cloud SQL component (MySQL), which is connected via ...
1
vote
1
answer
2k
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
1
answer
125
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
639
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-...
Related Tags
mysql × 28
postgresql × 19
google-app-engine × 18
database × 6
vpc-peering × 6
gcloud × 5
php × 4
ssl × 4
sql-server × 4
python × 4
gcp × 4
kubernetes × 3
sql × 3
replication × 3
google-cloud-vpn × 3
logging × 2
django × 2
node.js × 2
cloud × 2
networking × 1
more related tags
Hot Network Questions
- Have children's car seats not been proven to be more effective than seat belts alone for kids older than 24 months?
- In By His Bootstraps (Heinlein) why is Hitler's name Schickelgruber?
- Why was the animal "Wolf" used in the title "The Wolf of Wall Street (2013)"?
- How to make D&D easier for kids?
- How are "pursed" and "rounded" synonymous?
- Find all sequence that satisfy the system of equation
- What is the relationship between gravitation, centripetal and centrifugal force on the Earth?
- Is it consistent with ZFC that the real line is approachable by sets with no accumulation points?
- What is the original source of this Sigurimi logo?
- An alternative way to solve a classic problem of combinatorics
- How to Draw Gabriel's Horn
- Can a planet have a warm, tropical climate both at the poles and at the equator?
- Integration of the product of two exponential functions
- Different Bekenstein bound equations – what’s the difference?
- Could a transparent frequency-altering material be possible?
- How do guitarists remember what note each string represents when fretting?
- Visit USA via land border for French citizen
- Weird behavior by car insurance - is this legit?
- Were there engineers in blimp nacelles, and why were they there?
- Are there paintings with Adam and Eve in paradise with the snake with legs?
- What actual purpose do accent characters in ISO-8859-1 and Windows 1252 serve?
- Reconstructing Euro results
- Did James Madison say or write that the 10 Commandments are critical to the US nation?
- Huygens' principle and the laws of reflection/refraction