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.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that operate from Google's Cloud Platform.

133 questions
0
votes
1 answer

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/configure-external-master and everything worked as…
0
votes
0 answers

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, 1 table (as far as we know) But it still accessible by…
chaintng
  • 519
  • 4
  • 8
0
votes
1 answer

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 generation" instance. If I do so, the EntityManager can…
0
votes
0 answers

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 credential file for authentication;…
raghu
  • 1
  • 1
0
votes
2 answers

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 connect using MySQL workbench. I tried to create a new…
ADL
  • 181
  • 2
  • 8
0
votes
0 answers

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 created according to google tutorial. The internal…
0
votes
0 answers

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 | Type | Status 6 Feb 2017, 10:11:03 | Update |…
Aeisor
  • 351
  • 2
  • 3
  • 7
0
votes
1 answer

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): Access denied; you need (at least one of) the SUPER…
jaychris
  • 11
  • 1
0
votes
1 answer

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:asia-east1:santexdb for…
0
votes
1 answer

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 instance to Cloud SQL instance without SSL. In that…
Jumpei Ogawa
  • 137
  • 3
0
votes
1 answer

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 failover replica and read replica of the db instance.…
Rohit Sharma
  • 105
  • 1
  • 6
0
votes
1 answer

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 prefix and allowed that (afaik that should allow…
usbpc102
  • 121
  • 4
0
votes
3 answers

Is it necessary to perform backup data and stored them in non Google server

I'm developer and have 0 sys admin knowledge. Currently, I had built several apps on the top of Google App Engine. I'm pretty happy with it, as it requires 0 sys admin effort, to achieve such scale. In term of storage, I'm using High Replication…
0
votes
2 answers

Python Pip Install fails - Could not build the egg. Also cannot use 1.2.5 because of google cloud sql

I need mysql-python. I get error of could not build egg while installing 1.2.4 Everywhere it says install 1.2.5, which works for me too. But googleAppEngine's app.yaml supports only 1.2.4 libraries: - name: MySQLdb version: "1.2.4" So if I use…
0
votes
1 answer

Google Cloud SQL - Lost connection and Timeout errors

I keep getting the following errors when attempting a simple connection to a Google Cloud SQL database instance from a PHP script. Lost connection to MySQL server at 'reading initial communication packet', system error: 0(2013) and Warning:…
TokTok123
  • 101
  • 1
  • 2
1 2 3
8 9