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.

0
votes
0answers
6 views

MySql workbanch migration wizard does not retrieve schema

I am trying to migrate from azure SQL to Google Cloud MySql using MySql Workbench migration wizard. I am using the administrative user to connect to azure SQL. The 'Fetch Schema List' finishes ...
1
vote
1answer
37 views

Connecting to a Google Cloud MySQL database in AppEngine(Python)

I've had a lot of issues with this and found multiple different types of syntax to do this, and so far none of them seem to work. https://cloud.google.com/sql/docs/mysql/connect-app-engine based on ...
0
votes
1answer
43 views

cloud sql send pubsub message on update/insert

I am setting up a read only GraphQL instance using Java. GraphQL as I understand it needs to be told when to re-query its data sources. We are using GCP, and Cloud SQL for our primary data source. Our ...
1
vote
1answer
40 views

Google Cloud SQL - Deciphering Postgres log & viewing temporary log file

I have a Postgres instance running on Google Cloud SQL. I am having some trouble deciphering messages in the online "Logs Viewer". I'm getting lots of "info" level messages that look like this, ...
0
votes
2answers
37 views

GAE Python 3.7 Standard can't connect to Cloud SQL server

I'm following the tutorial for deploying a Django app on Google App Engine here. I'm able to run the app locally using cloud_sql_proxy, but when I deploy the app to GAE the app fails with the error: (...
0
votes
1answer
28 views

How to use a cloud SQL database using vb.net?

I create a sale inventory software using vb.net and I want to operate it in more than one computer. So I need an online or a cloud SQL database which is connected to all software which is running on ...
0
votes
0answers
49 views

How to skip slave replication errors on Google Cloud SQL 2nd Gen

I am in the process of migrating a database from an external server to cloud sql 2nd gen. Have been following the recommended steps and the 2TB mysqlsump process was complete and replication started. ...
0
votes
1answer
19 views

How to disable foreign key checks while migrating to google cloud sql due to circular references

I'm trying to migrate a production database to google cloud sql using the replication method described here. However, when importing the mysql dump file google cloud sql returns the error ''Cannot Add ...
0
votes
1answer
18 views

Getting “Unhandled rejection SequelizeConnectionError: connect ENOENT” when connecting to SQL Cloud

I'm setting up a NodeJS backend in Google App Engine, and when I try to connect to the SQL Cloud (using sequelize + postgres) , I'm getting this error: Unhandled rejection SequelizeConnectionError: ...
0
votes
1answer
27 views

MySqlException: Unable to connect to any of the specified MySQL hosts. Asp.netCore application on Google Cloud Platform

I have developed an application in asp.net core EF, with MySql DB. Application is deployed on Google Cloud App Engine. I am trying Connecting Google Cloud App Engine application to Cloud MySql under ...
0
votes
1answer
28 views

Cloud Functions with Cloud SQL - Property 'socketPath' does not exist on type

I'm trying to access my Google Cloud SQL database on my Firebase Functions. I followed the Google documentation but it's not very good and leaves out a lot of information. I added the code from the ...
1
vote
1answer
50 views

Is there an option to set up autoscaling for PostgreSQL on Google Cloud?

We need to manage high load for our application on PostgreSQL database. According to our research autoscaling is supported only for Cloud Spanner database. In case we missed something, does anyone ...
0
votes
0answers
85 views

Write data available in GCS file into cloud sql using dataflow JdbcIO api

How to write data available in GCS file i.e "gs://***/sampleBigtable.csv" to RDBMS DB. Could you please share some example. pipeline .apply(TextIO.read().from("gs://***/sampleBigtable.csv")) ...
0
votes
2answers
40 views

How to pass dynamic SQL statement to the JDBCIO connector in apache beam?

Apache beam provides the JDBCIO connector to connect to CloudSql postgreSQL. My job reads an event from pub/sub. The event body is as below: tableName, list<value> I need to write to the table ...
0
votes
0answers
46 views

How to re-execute the query script of an App Maker Datasource

Goal Use App Maker to collect User Birthdays and display only the Birthdays this Month. Issue I have a data model, persons. In that model are two Datasources, the default persons and a second ...
0
votes
3answers
70 views

Change innodb_io_capacity on Google Cloud SQL

Our service uses db-n1-standard-32 instance. The IOPS limit is read 40,000, write 30,000. But our service seems to be limited at about 5000. See the screenshot. I think it occurs from MySQL's ...
0
votes
2answers
54 views

grant all in Google Cloud SQL

I found that I cannot use GRANT ALL in Cloud SQL PostgreSQL But when I tried to execute a DDL script, I got error ERROR: permission denied for language c. I found out that in this post, I need ...
-1
votes
0answers
42 views

I want to connect to google cloud Mysql database using python. Please tell me should be the hostname ot database URL?

I want making an web application which will connect to google cloud sql database. For this i am thinking to use MySQLdb python package but it need hostname. So, anyone please tell me how to find the ...
1
vote
1answer
70 views

Create SQL Instance fails with “An unknown error occurred.”

I'm trying to create a Cloud SQL instance but am unable to do so. I have tried many variations: DB: Postgres 9.6 / 11.1, Mysql 5.9 Tier: micro, 1 vcpu / 3.75MiB Public network (non selected) Via ...
1
vote
1answer
66 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' on Google App Engine

I'm trying to connect to Google Cloud MySQL from Google App engine but getting OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") I've ...
0
votes
1answer
53 views

How to connect MySQLdb code to google cloud SQL?

I have a flask server which I want to deploy on Google Cloud Platform. The code uses MySQLdb library to connect with local MySQL instance in the following manner: @app.route('/show_table', methods=['...
0
votes
1answer
28 views

Using GCP Cloud SQL SocketFactory with Hibernate Configuration

I am trying to connect to a Cloud SQL Postgres Database instance from GCP App Engine (GAE) Standard. Using the database instance connection name (my-project-id:europe-west1:db-instance-name) with the ...
0
votes
1answer
64 views

Cloud run failed to start because of invalid SQL Cloud configuration

I followed the documentation to enable SQL Cloud from a Cloud run. But according to the documentation: Your container instances are now able to connect to Cloud SQL via the Cloud SQL proxy that is ...
1
vote
2answers
73 views

Why does the App engine (python3 - standard environment) generate aborted connections when connecting to a cloud sql -2nd Gen Mysql instance?

I'm currently developing a project with python 3.7, Django 2.1, Mysql as database. I'm deploying it in google cloud app engine standard environment and for the database I'm using a cloud SQL - MySql ...
0
votes
1answer
34 views

Connect to Google Cloud postgres SQl from Google App Engine Custom flex environment

I have a Java application for which the database configuration is read through the following file: db.properties dataSourceClassName = org.postgresql.ds.PGSimpleDataSource dataSource.serverName = ...
0
votes
1answer
56 views

How to Store multilingual data in an RDBMS on cloud

I have to create an RDBMS table on Google cloud that supports multilingual data. Do we have a service on google cloud for that? CloudSQL or CloudSpanner? This is for storing movie titles data from ...
1
vote
1answer
34 views

In Apache Airflow, how can I get the results of a “SELECT” statement on a Google Cloud SQL Database?

I need to retrieve data from a Google Cloud SQL database in one of my Dags. I tried using the CloudSqlQueryOperator (https://airflow.readthedocs.io/en/latest/howto/connection/gcp_sql.html) but my ...
0
votes
0answers
48 views

proper implementation of Jdbc.getCloudSqlConnection

Broadly I'm having issues integrating a Google Apps Script app with my Cloud SQL instance. Specifically, my console caught an error with Jdbc.getCloudSqlConnection because Jbdc wasn't initialized. ...
0
votes
2answers
58 views

Spring boot - Configure second datasource along with gloud gcp postgresql primary datasource

Setting up our Spring Boot project we have a database hosted on Google Cloud Gcp. We use Spring Data JPA to manipulate our database objects and it works great. application.yaml spring: jpa: ...
1
vote
1answer
91 views

Unable to open JDBC Connection for DDL execution\n\tat after deploying my spring boot app on google cloud / app engine

After deploying my spring boot on google cloud platform app engine 'standard', and then try to visit the website I get Error: Server Error in browser. Then I visit the log on google cloud I get error: ...
0
votes
1answer
28 views

Trouble at starting PostgreSQL instance

The POSTGRE SQL database associated with our AppEngine project does not start giving "An unknown error occurred". The first error of this kind is reported this morning, 22.05.2019 at 7:31 Spain time, ...
0
votes
1answer
39 views

How to create a connection with google cloud instance with python code?

I'm completely working on python and need to connect my instance of cloud SQL to my python project(sort of Software). Now what I need is that without using cloud_sql_proxy I need to make the ...
0
votes
1answer
32 views

MicroDb not restarting. Stuck at 'Instance being restarted' for several hours

MySQL microDB instance of Cloud SQL is stuck in restarting for several hours. It is showing 'Instance is being restarted' for a long time. I am not able to connect, take backup, restore or clone it. ...
0
votes
0answers
37 views

Cloud SQL Stuck on restart

Cloud SQL stuck after resizing and subsequent restart and nothing I do gets it unstuck I've tried Google Shell to stop, restart or then start via cli and no luck How do I get support from Google for ...
0
votes
1answer
48 views

Error creating read replica on Google Cloud SQL

I'm trying to create a read replica for Google Cloud SQL MysQL Second generation. When I click 'Create', I'm getting two notifications. The first one is Instance is being created, and immediately ...
0
votes
1answer
43 views

Connecting node.js running on Kubernetes to Cloud Sql

I'm trying to connect my node.js backend to a Cloud SQL on the same project, following many tutorials and documentation, but without success. Here my service and endpoint config: kind: Service ...
1
vote
2answers
41 views

Connect to Cloud SQL using SSL

I am trying to connect to a CloudSQL instance using the certificates provided by google namely "client-cert.pem", "client-key.pem" and "server-ca.pem". Can someone suggest what to keep in keystore ...
0
votes
1answer
58 views

Google cloud SQL - CPU at 100%

Earlier we noticed that our Master DB CPU started spiking: There wasn't any unusual traffic volume/load. Also, if you look at the earlier spikes they coincide with the Google backups, but it looks ...
0
votes
1answer
31 views

Migrated from standard to flex App Engine environment, now Cloud SQL won't connect

I have a Google App Engine app written in Node.js which connects to a Cloud SQL Postgres instance under the same GCP project. Previously I was using the standard environment and it worked fine, but ...
1
vote
1answer
53 views

Cannot connect to the Google Cloud SQL through GAS

I can not connect to the Google Cloud SQL through GAS (Google Apps Script). Scenario: User A (other person) in Domain:A User B (me) in Domain:A First, User A was working with me. We have another ...
0
votes
2answers
39 views

Cannot connect to postgres cloudsql from app engine

I am making my first app engine project using Go. I have a cloud sql instance and app engine in the same project inside cloud console. I have the following inside my app.yaml file: service: ...
0
votes
1answer
35 views

Import/Export data from Cloud SQL from/to CSV files

On Cloud SQL, with MySQL engine, how can I replace the functionality LOAD DATA INFILE ... REPLACE? We are migrating our web platform to Google Cloud using App Engine and Cloud SQL. We use LOAD DATA ...
0
votes
1answer
39 views

Does Google Cloud SQL has an RPO, RTO and ERT guide online?

Azure SQL has provided their DR's capabilities https://docs.microsoft.com/en-us/azure/sql-database/sql-database-business-continuity in term of RPO and RTO benchmark. I am looking for the same on ...
3
votes
1answer
45 views

No Cloud SQL instances to proxy when connecting dataproc cluster to Cloud SQL instance

I have a problem with the dataproc initialization action for cloud-sql-proxy installation. I used this initialization action: https://github.com/GoogleCloudPlatform/dataproc-initialization-actions/...
0
votes
1answer
27 views

Restoring Deleted Databases on CloudSQL

I know GCP's CloudSQL supports instance backups of some kind. Also noted that they make it really easy to create and delete databases from the CloudSQL instance details -> Databases tab. I am ...
0
votes
1answer
26 views

Can Cloud SQL be exported synchronously? Or how can failures be caught and retried if asynchronous?

Short Summary Cloud SQL exports can sometimes fail. Can I make the export requests behave synchronously so the failures are easy to retry? Or is there a good way to retry exports in an asynchronous ...
0
votes
1answer
54 views

Replicate only some table (replicate-do-table) on Cloud SQL (MySQL)

So I have created a Cloud SQL (MySQL) DB somedb and its read replica somedb-replica, how can I replicate only some of its table (like replicate-do-table)? I want to do replicate-do-table=somedb....
0
votes
0answers
26 views

Connecting to CloudSQL through SSL using Sequelize

I need to connect a node js app sitting on Lambda to a PSQL database in Google Cloud SQL. The node js app uses Sequelize and I'm having trouble with finding any guidance on how to present the SSL ...
0
votes
2answers
41 views

Cannot connect to cloud sql from cloud dataflow transform

I am unable to connect to cloud SQL from inside a custom DoFn while running in cloud dataflow. The errors that show up in the log are: Connecting to Cloud SQL instance [] via ssl socket. [...
0
votes
3answers
44 views

How to reach hosted postgres in GCP from Kubernetes cluster, directly to private IP

So, I created a postgreSQL instance in Google Cloud, and I have a Kubernetes Cluster with containers that I would like to connect to it. I know that the cloud sql proxy sidecar is one method, but the ...