Stack Overflow
Stack Overflow

Questions tagged [google-cloud-sql]

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

Intro and features

Developer documentation

FAQ

3725 questions
1
vote
1 answer

Detecting errors when importing CSV - Google Cloud SQL

I'm importing a CSV file using the Google Cloud SQL API. After the import, I want to check for errors to make sure the file was imported successfully. I'm following the documentation…
glv19
  • 474
  • 6
  • 16
1
vote
1 answer

Change Default MySQL or PostgreSQL Port Number While Starting Default SQL Proxy Connections

I need to connect several Postgres & MySQL Cloud SQL service from my ETL server. I am using SQL proxy to connect with this database services. But problem is google doesn't allow default port for both MySQL and PostgreSQL, I can only connect with one…
Md Sirajus Salayhin
  • 4,974
  • 5
  • 37
  • 46
1
vote
1 answer

Google Cloud SQL not connecting

I have a MySQL database on google cloud. I have allowed all IPs to be able to access it in the authorization settings. When I try to connect to it using MySQL workbench on my home internet(or any non-work place internet) it connects fine however…
machazthegamer
  • 593
  • 8
  • 18
1
vote
1 answer

Using Cloud SQL as database for Keycloak

We are using kubernetes to host an instance of keycloak 4.0.0.Final together with a postgres 9.6 database as storage. This works well, but now we want to move the database to a hosted Cloud SQL instance. The Cloud SQL instance is setup, running and…
bialad
  • 75
  • 7
1
vote
0 answers

ImportError: No module named psycopg2._psycopg with google appengine

I used this guide from Google to connect my postgres instance to my application. Google indicates that psycopg2 is supported. But here is my error: File "/Users/Personal-Project/app/lib/psycopg2/__init__.py", line 50, in from…
Dannick Montanede
  • 119
  • 2
  • 11
1
vote
1 answer

Can't connect to Cloud SQL via unix socket from an App Engine Flexible Environment hosted in a different GCP project

I have a GCP project running Cloud SQL and a Django App inside a Google App Engine Flexible Environment and it works fine. However, when I try to connect to the same Cloud SQL instance from another project it doesn't work since the socket is not…
eldermao
  • 633
  • 8
  • 18
1
vote
2 answers

How to use Service Account to authenticate with Google Cloud SQL Java

I am aware that there is Cloud SQL JDBC Socket Factory. However, that requires Application Default Credentials. What I am trying to do is to use a service Account(Which is the JSON secrets file) to authenticate with the Cloud SQL. Can someone please…
zzdhxu
  • 379
  • 6
  • 22
1
vote
0 answers

Cloud SQL: Instance update will not end

I have a problem with my Cloud SQL Second Generation instance. I used this instance for months without problems. Every evening I stop the instance and every morning I perform a restart via Java, using "patch" API: DatabaseInstance requestBody = new…
Andrea Zonzin
  • 1,124
  • 2
  • 11
  • 26
1
vote
1 answer

Does magento 2 works without SQL triggers?

Here is the situation. I am using magento 2.1.6 Enterprise edition. In magento documentation it has been said that "Magento uses MySQL database triggers to improve database access during reindexing". But my question is what will happen if I use…
vinoth
  • 51
  • 1
  • 5
1
vote
1 answer

PHP (PDO) Connection to Cloud SQL on Google App Engine Not Working

I am experiencing issues connecting to a Cloud SQL instance hosted in an App engine flexible environment which shares same project. I am using PHP Data Object (PDO) to create the connection. I Kept getting this error: SQLSTATE[HY000] [2002] No such…
Ohiri Vincent
  • 91
  • 1
  • 6
1
vote
2 answers

How to connect datalab with Google Cloud SQL?

Trying to connect from a datalab notebook with PostgreSQL database hosted on Google Cloud SQL. Try both direct IP and instance connection ways but both give us an exception. direct connection URI:…
darofar
  • 101
  • 1
  • 8
1
vote
2 answers

Laravel MySQL Google App Engine - ERROR: (gcloud.sql.instances.describe) There was no instance found

I deployed my Laravel 5.6 application using Google App Engine following these steps. The Laravel app is live at a URL but I am having trouble getting MySQL set up. I created a 2nd generation MySQL development database, then installed the Cloud SQL…
Connor Leech
  • 18,052
  • 30
  • 105
  • 150
1
vote
1 answer

CloudSQL DR Solution Backup/Restore

I’m a bit new to Cloud SQL and I was reading the docs but stuck into this MySQL Second Generation instances: Backup data is stored in two regions for redundancy. If there are two regions on a continent, the backup data remains on the same…
BlaBlaBla
  • 33
  • 5
1
vote
1 answer

Google Cloud SQL Export without disruption

I'm trying to export from a postgres database without causing any disruption to the main server and so far I can see a few ways I might achieve this. The database isn't under huge load (10 req/s), but I don't want to cause any significant…
gbartonowen
  • 25
  • 1
  • 5
1
vote
1 answer

Getting google.sqladmin not a function error

I am using GAE to deploy my project. I am trying to use this instances export function mysql-admin v1beta4 to take a backup of my Cloud SQL database to a GCS bucket. I am trying to use the code they have mentioned on their site. After doing npm…
Saptarshi Dey
  • 356
  • 1
  • 4
  • 13
1 2 3
…
99
100