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.

130 questions
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
  • 133
  • 4
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
  • 3
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,147
  • 4
  • 13
  • 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
2 answers

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-export/exporting) in order to make an export of…
Jasper
  • 111
  • 1
  • 2
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
  • 2
1
vote
1 answer

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 here If I use MySQL client to determine the size of…
Michel Zúñiga
  • 21
  • 1
  • 3
1
vote
2 answers

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 { $db = new PDO($dsn, $user, $password); …
parth
  • 111
  • 1
  • 2
  • 3
1
2
3
…
8 9