Server Fault Stack Exchange
Server Fault 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.

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
2
votes
2 answers

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 Read Only Stackdriver Logging API Write…
Leszek Gruchała
  • 123
  • 1
  • 5
2
votes
2 answers

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 failover instance did not work "by failing over", now…
snebel29
  • 21
  • 4
2
votes
1 answer

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 "app engine instance"…
Dan
  • 21
  • 1
2
votes
2 answers

Google Cloud with SQL Server Express - add database permissions

I've recently setup a google cloud server for the first time and I installed the asp.net framework which is marketed as "Windows dev stack featuring IIS, SQL Express and ASP.NET". I'm familiar with SQL Server, c# asp.net and would like my first…
John
  • 73
  • 8
2
votes
1 answer

Is Google Cloud SQL fault tolerant when there is replica?

I'm running a Google Cloud SQL instance ("mysql-master") and it has one replica. ("mysql-replica") Web apps on another servers read and write data on the Cloud SQL instance. While mysql-master is restarting, can app servers read and write data? I…
Jumpei Ogawa
  • 137
  • 3
2
votes
1 answer

CloudSQL ERROR 2013 from GCE instance

From a GCE instance, I am executing the following from command line > mysql -udbase -p -DmyDb -hmyIp > > mysql> SELECT account, count(account) > -> FROM `headers` > -> where labelIds='["SENT"]' > -> group by account order by 2 desc…
miturbe
  • 151
  • 5
2
votes
2 answers

Accessing Google Cloud SQL through a Google proxy

I'm looking for a way to expose my google cloud sql server (running mysql), to my api servers. I might add/remove them in the future and adding them mysql access is an additional step in configuration with already complex setup (for my app). And I…
Remember_me
  • 135
  • 5
2
votes
2 answers

GCP log Explorer and slow SQL query log with Cloud SQL

Is there a way to analyze SQL Slow query logs easily on log explorer or on some other GCP tool? Now log explorer writes log entries to multiple lines (textPayload divided) and it's hard to find out those slow performing queries. So far I managed to…
Tim
  • 31
  • 1
  • 4
1
vote
1 answer

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?
Hyperfocus
  • 1,177
  • 4
  • 14
  • 23
1
vote
2 answers

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 backup storage rate. Binary logs use storage…
Erez Ben Harush
  • 177
  • 1
  • 7
1
vote
1 answer

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 instances which is constantly increasing.(It's up…
techiewickie
  • 13
  • 3
1
vote
2 answers

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 that use the MEMORY storage engine found error due…
skyrideraj
  • 11
  • 2
1
vote
1 answer

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 connections) if I have a lot of pods that has cloud sql…
alexishacks
  • 11
  • 2
1
vote
1 answer

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 their content appears in wrong ordering and…
user1092289
  • 11
  • 2
1
vote
1 answer

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 hours. Some details follow: Second generation…
razzmatazz
  • 11
  • 3
1
2
3
…
8 9