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.

Filter by
Sorted by
Tagged with
0
votes
1answer
29 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
0answers
24 views

Google Cloud SQL instance failover failed

We attempted to failover a cloudsql instance and the operation failed with an unknown error. The instance state is now "status: failed" with
0
votes
2answers
37 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 ...
0
votes
2answers
119 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) ...
0
votes
1answer
93 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 ...
0
votes
1answer
75 views

How to connect to Postgres Cloud Sql without public IP from Cloud Run

There is a documentation on the Cloud SQL for Cloud Run connection(https://cloud.google.com/sql/docs/postgres/connect-run), but it contains the following line: Note: These instructions require your ...
1
vote
1answer
58 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?
0
votes
1answer
23 views

Opensource Cloudsqlproxy server or similar?

We've got one of our projects using a Google CloudSQL Postgres DB. We really like the cloudsqlproxy and how it keeps access to the DB locked behind our google accounts (which have 2FA). We've got ...
0
votes
1answer
88 views

Cloud SQL Server get sa password

I have created an SQL Server instance in Google Cloud SQL, I have the sqlserver user but it doesn't have sysadmin permission, so I want to know if it's possible to get or reset the password of the sa ...
0
votes
0answers
63 views

Certificate error when connecting to a google sql instance with the cloud sql proxy

I have a couple of Google Cloud SQL instances where I receive the following error message when I attempt to connect to them using the Cloud SQL proxy and a service account: '2019/12/20 13:08:57 ...
0
votes
0answers
84 views

Dynamic inventory of GCP CloudSql instances alongside VMs list

I can get and group my project's GCP compute (VM) instances in an Ansible dynamic inventory, but I'm also trying to dynamically fetch the details of SQL server instances. To do so, I'm using a JSON ...
0
votes
1answer
95 views

Get the latest PostgreSQL version available in a region

Is there any gcloud cli command or api call that I can use to see the latest/newest available PostgreSQL versions in region? I found db-versions page, but I need to check which is the latest/newest ...
3
votes
3answers
1k 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 ...
0
votes
1answer
156 views

ETL to bigquery using airflow without have permission cloud storage/ cloud sql

i have done ETL from MySql to bigQuery with python, but because i haven't permission to connect google cloud storage/ cloud sql, i must dump data and partition that by last date, this way easy but ...
0
votes
1answer
89 views

How to replicate Cloud SQL for PostgreSQL data to an external on-premise PostgreSQL DB

I've gotten a case that I need to replicate data from Cloud SQL for PostgreSQL to an external on-premise PostgreSQL DB. I've read the document and found that Cloud SQL for PostgreSQL does not support ...
0
votes
2answers
163 views

connect to GCP from my laptop using SSH certificate

I am setting up a GCP Cloud SQL instance with postgreSQL and want to connect to it from my laptop using Python and a software called QGIS. I travel a lot and my IP changes all the time so using IP ...
0
votes
0answers
273 views

Exception raised (sqlite3.OperationalError) no such table

I have successfully deployed my flask app code on google app engine & when i run migrations, new tables get created on mysql cloud instance too but whenever request comes to Queues, it prompts and ...
0
votes
1answer
94 views

Cloud SQL private IP changed suddenly

We've been using Cloud SQL for months without problems. Today we started to get a lot of HTTP 500 errors on our application logs. Upon debugging, we found out that the cause was that the private IP of ...
0
votes
0answers
80 views

Terraform create Cloud SQL replica alway get unkown provider error

Here is my tf files: https://gist.github.com/Rukeith/bd194e808adb3ecfe982a7bdda9952a4 Terraform Version: Terraform v0.12.6 + provider.google-beta v2.12.0 + provider.random v2.2.0 Terraform got an ...
0
votes
1answer
301 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 ...
1
vote
2answers
640 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-...
1
vote
2answers
670 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 ...
0
votes
1answer
562 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 ...
1
vote
2answers
90 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 ...
0
votes
1answer
196 views

failed to delete a cloud sql instance

I failed to delete a cloud sql instance. gcloud sql instances delete $SQL_INSTANCE --quiet --project=$GCP_PROJECT ERROR: (gcloud.sql.instances.delete) HTTPError 409: Operation failed because ...
0
votes
0answers
104 views

Constantly Restarting of SQL Instances in GCP

I have 4 instances of SQL in GCP, all of this are restarting constantly. This is the log from one of this: From today this problem is happening, and they go 5 times on this day, I can not find more ...
2
votes
1answer
357 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 ...
0
votes
0answers
82 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
2answers
11k 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....
0
votes
1answer
48 views

SQL CSV Import Issue

I have a few SQL instances on the Cloud platform where we house a large amount of marketing analytics data. We have been manually importing CSV files daily into our instances in order to update daily ...
0
votes
1answer
124 views

Possible to avoid cost increase in move to GCP MySQL Second Generation?

I was using pay-per-use with MySQL first generation. It was a website with all I was using pay-per-use with MySQL first generation. It's for a website with all pages cached in memcached and only ...
2
votes
1answer
612 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 ...
1
vote
0answers
124 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 ...
1
vote
1answer
52 views

Google Cloud SQL. Sorting in THAI in mysql

We have an application where we use Google Cloud SQL (mysql) as database server. The databases are in the collation: utf8mb4_unicode_520_ci A user of the application from Thailand reported that ...
2
votes
3answers
682 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 ...
-1
votes
2answers
867 views

Export data to Google Cloud Storage. Cloud SQL Export. Do not work at all [closed]

I want to export from Google Cloud SQL with function Export, in a cloud bucket. But do not work at all. Nothing happen. There is a bug. It's not first time when I made exports, but right now the ...
-2
votes
1answer
80 views

Google Cloud SQL database increase [closed]

My Google Cloud SQL automatic storage increased up to 31GB but still the database size is only 120Mb and all the above happens in 3 days?
1
vote
0answers
485 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 ...
4
votes
1answer
2k 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 ...
1
vote
1answer
75 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
2answers
2k 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
1answer
323 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 ...
0
votes
1answer
1k views

Fast Google Cloud SQL

I have always set up machines to have a typical LAMP set up and recently I've been testing an external database set up with Google Cloud SQL. The performance hits I'm taking from it seem a bit ...
1
vote
1answer
702 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 - ...
0
votes
1answer
69 views

Looking for a way to pause or quiesce a database on google cloud platform

Is there a way to pause or quiesce a database on google cloud platform to reduce costs yet maintain the data? If not, do any of the cloud database providers offer such a feature?
1
vote
1answer
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
2answers
349 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 ...
0
votes
1answer
249 views

Do the MySQL time_zone* tables get updated automatically on Google Cloud Platform?

We use a MySQL 2nd Gen 5.7 instance on Google Cloud Platform. I've seen the mysql.time_zone* tables already contain timezone information. Will this information be updated automatically when timezones ...
1
vote
2answers
2k 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 ...
5
votes
0answers
113 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. ...