google-cloud-sql Questions
1
I have these users:
postgres | Create role, Create DB | {cloudsqlsuperuser}
proxyuser | Create role, Create DB | {cloudsqlsuperuser}
qa|Create role, Create DB | {cloudsqlsuperuser}
And these tab...
Whitewash asked 10/11, 2017 at 2:9
1
I'm trying to connect to Google Cloud MYSQL server using SSL certificates and the python module PyMySQL with the following line:
connection = pymysql.connect(host=os.environ['SQL_HOST_IP'], user=o...
Rep asked 4/3, 2017 at 12:37
1
Solved
I'm trying to access my Cloud SQL instance from my App Engine flexible environment NodeJS application but kept getting timeout issues.
When I add the IP of the compute engine running the App engin...
Continuous asked 16/8, 2017 at 9:3
2
I followed the example on how to set up Node.JS to work with Cloud SQL, and generally got it to work, but with some workarounds on how to connect to the SQL server. I am unable to connect in the pr...
Sliest asked 28/2, 2017 at 12:18
1
Solved
I want to use the gcloud sql instance export command to export a database, to be imported to another database on the same server.
The problem is that using:
gcloud sql instances export instance...
Angola asked 13/6, 2017 at 12:41
1
I've started to use Google Cloud SQL and I need to improve my IOPS and network speed. I've seen that this it's only possible improving the type of machine and/or improving the size of disk. And thi...
Jimerson asked 23/5, 2017 at 17:50
2
Solved
I'm using google compute engine and have an auto scaling instance group that spins up new VMs as needed all sitting behind a load balancer. I'm also using google's cloud SQL in the same project. Th...
Salutatory asked 26/9, 2016 at 18:35
1
I want to run an elixir application in google app engine flexible environment.
I also have a postgresql server running on google cloud SQL.
I am able to deploy the application inside the docker c...
Neat asked 13/5, 2017 at 22:21
1
I have been trying the past 2 days to connect to the cloudsql from the appengine, I am able to connect from a linux webserver via the IP, however cannot from the app engine with the same setup.
My...
Penal asked 14/5, 2017 at 14:21
2
Solved
I was trying out postgres google-cloud-sql and loaded a simple school schema
CREATE TABLE school (
id SERIAL NOT NULL PRIMARY KEY,
name TEXT NOT NULL
);
CREATE TABLE class (
id SERIAL NOT ...
Indehiscent asked 1/5, 2017 at 11:28
2
We have Setup Cloud SQL in google cloud with configuration of Tier db-n1-standard-4 with storage of 100GB SSD. My actual database size is having only 160MB Max but in Cloud Cloud SQL instances it s...
Redden asked 19/4, 2017 at 4:49
3
Solved
I am trying to populate a 2nd gen cloud sql instance (v5.7) with a database dump currently running on 1st gen cloud SQL. It has some triggers:
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`%`*/ /*!5...
Pascual asked 30/8, 2016 at 7:24
3
Solved
Summary: PHP gives an error when using self-signed certificates as provided by Google Cloud SQL.
Details: I am trying to connect to Google Cloud SQL's mysql instance using PHP's mysqli library.
...
Herculie asked 27/12, 2015 at 6:49
5
Solved
I have created a java web servlet using app engine, the servlet makes requests to a database. I have tested the servlet locally using a local database and it worked perfectly, i then proceeded to t...
Denouement asked 3/1, 2014 at 3:51
1
I'm attempting to access a Google Cloud SQL instance stored on one Cloud Platform project from an App Engine application on another project, and it's not working.
Connections to the SQL instance f...
Improvisator asked 16/3, 2017 at 6:14
3
Solved
My Google app engine application fails to connect to Google cloud sql instance with this error:
'PDOException' with message 'SQLSTATE[HY000] [2002] No connection could be made because the target m...
Ochre asked 16/12, 2013 at 16:12
2
I'm trying my best to learn Google's Cloud Platform. They have a CloudSQL offering, which I'm learning via this NodeJS tutorial. Everything worked great until I deployed to their appspot server, at...
Forensics asked 12/1, 2017 at 0:8
5
Solved
My team has a requirement that we be able to retrieve a backup of our database (hosted on Google Cloud SQL) and restore that database to a locally hosted instance of MySQL.
I know that Google Clo...
Manion asked 2/1, 2013 at 18:55
2
I have an issue using MySQL on PHP 5.6, and after three days of debugging PHP, OpenSSL, MySQLnd Drivers on PHP and trying out the mysql_client on an Ubuntu 14.04 machine, I have come to a conclusio...
Bdellium asked 25/3, 2015 at 15:53
2
Solved
JSON datatype is supported in mysql from 5.7.8 onwards.
Google cloud sql faq - says second generation instances are on 5.6 and 5.7. Minor version updates are deployed as they are released, with no...
Spitler asked 10/10, 2016 at 10:25
3
Solved
I am trying to create an Autoscaling web application network over HTTP Load Balancing. The Web Server Instances are going to be connected to load balancer. Further the web instances have to be conn...
Mot asked 13/4, 2015 at 19:15
1
If I have a pool of Compute Engine instances (behind a load-balancer with a static IP), and I want to connect from Java apps on these instances to a Cloud Sql database in the same project, what's t...
Gardant asked 21/9, 2016 at 18:48
1
We need to change our Google cloud SQL instance from db-g1-small to db-n1-standard-1. Can I change it with zero downtime?
Edit 1
I think I found the answer. It seems that it will take a few secon...
Pontifical asked 29/8, 2016 at 7:5
2
Solved
I have a database hosted on Google Cloud SQL, and a python script to query it.
I am trying to call a Stored Procedure that has an Out Parameter. The SP is called successfully, but the value of the ...
Jempty asked 10/6, 2014 at 11:29
1
Solved
Looking around for a connection pool solution on App Engine, with Cloud SQL, multiple entries show up with the suggestion that HikariCP should work because it allows for an external ThreadFactory c...
Linguistician asked 15/7, 2016 at 13:27
© 2022 - 2024 — McMap. All rights reserved.