Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

-2
votes
1answer
33 views

Google Cloud SQL database increase [on hold]

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
103 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 ...
0
votes
0answers
19 views

checkDatabaseConnection() : error from compute engine to cloud sql

Since monday (december 10) , we can not connect to cloud sql from our compute engine vm, we have this kind of error messages: 0|api-serv | 2018-12-12 12:52:54 > ManagerService > ...
0
votes
0answers
47 views

How to remove unused temp files from Google Cloud SQL managed Postgres?

We've moved to Google Cloud SQL, created couple of databases and imported lots of data. Alongside it was a pretty large amount of queries which were interrupted here and there which have left some ...
0
votes
1answer
430 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
51 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
376 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 { ...
0
votes
0answers
26 views

How do I track what's stopping a Google Mysql instance from restarting?

I have a 1st Gen MySQL 5.5 instance running in europe-west1-c which seem to have some sort of issue at midday today. I requested a restart of the instance about an hour ago in the hope that this would ...
1
vote
1answer
63 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
401 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 ...
0
votes
0answers
65 views

Activating Cloud SQL as external source for App Maker on org/domain account

I work at a higher education institution and we are a G Suite for Education customer. We recently enabled App Maker on our Google Cloud domain/organization. One of the key things faculty and students ...
1
vote
1answer
153 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
57 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
509 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 ...
0
votes
2answers
163 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
71 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 ...
0
votes
2answers
573 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 ...
3
votes
0answers
91 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. ...
2
votes
0answers
319 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 ...
0
votes
0answers
28 views

Mysql remote access failed where mysql running in google compute engine ubuntu 14.04 [duplicate]

I would like to connect mysql server from local. for that i did following. /etc/mysql/my.cnf --> bind-address = 0.0.0.0 GRANT ALL PRIVILEGES ON . TO ''@'' IDENTIFIED BY '' WITH GRANT OPTION;...
1
vote
1answer
28 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
1answer
221 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 ...
0
votes
1answer
176 views

Refresh Google Cloud SQL MySQL server SSL certificate without downtime?

If I connect using SSL to a Google Cloud SQL 2nd gen MySQL server, the certificate is self-signed and it appears that the certificate only lasts 1 year. Before the year is up, I can refresh the ...
0
votes
1answer
134 views

What are the default innodb google cloud mysql settings?

I am specifically needing information on the innodb_log_file_size and innodb_buffer_pool_size. The link below is the only info I could find but it doesn't mention the settings I'm looking for. I don't ...
0
votes
1answer
392 views

Google Cloud SQL using more storage than needed

I've recently moved some MySQL hosting from a virtual server at Digital Ocean to Google's Cloud SQL hosting. It took several goes to import the database and I didn't notice until afterwards that each ...
1
vote
1answer
176 views

Restore (PITR) of CloudSQL (MySQL) fails with Got a packet bigger than 'max_allowed_packet' bytes

When doing a PITR-Restore of a second generation Google CloudSQL instance, the restore fails with "Failed to Create" error. I cannot manipulate the instance clone, except reading logs and deleting it. ...
0
votes
2answers
242 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:...
3
votes
1answer
790 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'; ...
2
votes
1answer
301 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 ...
1
vote
0answers
605 views

Getting Google's Cloud SQL Proxy to Work

I'm following this example of how to get wordpress running on GKE connected to Google Cloud SQL via the Google Cloud SQL Proxy. But either the documentation, or the proxy itself, is deficient, or I ...
0
votes
1answer
254 views

Accessing a Google Cloud Replica of an external on-prem master

I just set up a MySQL replication on Google Cloud Platform using my external on-prem server as replication master. I just follow this guide https://cloud.google.com/sql/docs/mysql/replication/...
1
vote
1answer
145 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, ...
0
votes
0answers
62 views

MySQL was frozen for an hour, and all transaction get processed after that. How come?

In our environment, we have 2 MySQL (Master & Replica) Today, we have really strange case. The data in master sql get frozen for an hour! By frozen, i mean, there is no new record to, AT LEAST, ...
0
votes
1answer
567 views

Hibernate on Google Cloud SQL: First generation -> Second generation

I am running a Java + Hibernate application on Google App Engine for a while now. The MySQL database is a Google Cloud SQL (First generation) instance. Now I want to upgrade this to a "Second ...
0
votes
0answers
153 views

Cannot connect to any Compute Engine linux instance

I tried to connect Cloud SQL proxy using the following command on Ubuntu 16.04 LTS. ./cloud_sql_proxy -instances=***.**.**.***=tcp:3306 -credential_file=/var/www/auth-keys/kinre-cloudsql.json using ...
0
votes
2answers
660 views

SSL connection error: unknown error number

Yesterday I was able to connect to my cloud SQL just fine. Today something changed, I keep getting an error saying failed to connect, SSL connection error: unknown error number. I am trying to ...
1
vote
2answers
298 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 ...
0
votes
0answers
69 views

Configuring external master GCP errors

I'm following the GCP tutorial to configure an external master. The external master is a mysql 5.6 db hosted on a Google Compute Engine running ubuntu 14.04. The API is enable, the dump has been ...
1
vote
2answers
263 views

GCP configure an external master issue

I'm following GCP tutorial to create a replica instance from an external master. The Cloud SQL API is enabled and I am using google shell from the console to run the commands. I have also tried from a ...
0
votes
0answers
87 views

Google Cloud SQL Unavailable

I have a Google Cloud SQL 2nd Gen instance that last reported statistics (ie- Storage Usage, CPU Usage, etc...) at 10:09 this morning (~5.5 hours ago) In the 'Operations' tab I can see: Date/Time | ...
1
vote
1answer
627 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
votes
1answer
672 views

it is possible to turn gtid_mode off on Cloud SQL?

Is it possible to turn GTID mode off on 2nd generation Cloud SQL instances? I tried a dynamic change and got the "Super" error message: mysql> SET @@GLOBAL.GTID_MODE = OFF; ERROR 1227 (42000): ...
4
votes
2answers
684 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 ...
0
votes
1answer
380 views

google cloud sdk cloudsql proxy error after deploy

I am having issues after deploying my app. I can connect properly via local setup using cloudsql proxy and here is the recent connection log : 2016/10/31 12:15:49 Listening on cloudsql/santex-1101:...
4
votes
3answers
2k 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 ...
0
votes
1answer
38 views

Are GCE instances connected to Google Cloud SQL via trusted network?

I want to connect Cloud SQL from PHP application on GCE instances. The PHP application cannot connect to Cloud SQL via SSL connection due to old library version. I'm considering to connect from GCE ...
0
votes
1answer
134 views

Transactional Splitting - Read Request To Slave - Google Cloud SQL

I have created db instance in google cloud sql. After it was created, With the ip address assigned to it, my java servers are able to communicate with it in both read and write. Now i created a ...
-1
votes
1answer
127 views

Google Cloud SQL - Stopping / Deleting A Backup [closed]

How would I stop a running backup on Google Cloud SQL or delete one of the other backups? The backup has been running for over 12 hours and the instance is not accessible at all due to this. $ gcloud ...
-1
votes
1answer
500 views

Google Cloud SQL Not Responding [closed]

My Google Cloud SQL instance stopped responding. I changed the size from a micro instance to standard instance and then the memory just shot to the ceiling and stayed there. The restart button is ...
0
votes
1answer
464 views

Can not connect to Cloud SQL using local IPv6 address

I want to connect to a Google cloud SQL instance using its free IPv6 address instead of buying an IPv4 address. For that I looked up my IPv6 address and allowed it. I also looked up my routers IPv6 ...