FAQ Database Discussion Community


Choosing the correct google cloud data storage strategy for images [closed]

google-app-engine,google-cloud-storage,google-cloud-sql,google-cloud-platform,google-cloud-datastore
I'm writing my first google cloud backend for an image sharing mobile app and I'm having difficulties understanding which data storage option to go for. The clients will be mobile apps and probably also a web frontend. From what I've read so far the AppEngine seems to be a nice...

Cannot access google cloud SQL from google container engine

google-cloud-sql,google-container-engine
I'm still having problems accessing the cloud SQL instance from a GCE container. When I try to open up mysql, I get the following error: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 The connection works fine from my local machine, though...

How to connect to Google Cloud SQL from a GCE pod?

google-cloud-sql,google-container-engine
What's the best way to connect to a google cloud SQL DB from a google container engine pod? The doc implies I should request an IPV4 address for the DB and connect through that. I wonder whether there's a better way using the DB's name instead? Is there something similar...

Import CSV file from Google Cloud Storage to Google Cloud SQL

csv,import,google-cloud-storage,google-cloud-sql
I am trying to import a csv file directly into Google Cloud SQL using the command below. LOAD DATA LOCAL INFILE "gs:/zuds/stg/ems/product_offering_fact/000002_0" INTO TABLE buydoc CHARACTER SET "utf8" FIELDS TERMINATED BY "^"; For some reason, it is returning an error like below. I have confirmed that the file exists. However,...

optimizer_search_depth in Google Cloud SQL

mysql,google-cloud-sql
I have a problem in my Google Cloud SQL database. State of some queris stays "statistics" for long time. +-------+------+-----------+------+---------+------+------------+-------------- | Id | User | Host | db | Command | Time | State | Info +-------+------+-----------+------+---------+------+------------+-------------- | 18533 | root | localhost | mydb | Execute | 2485 |...

Connecting to Google cloud sql from Java stand alone application

google-api,google-cloud-sql
I want to write a java stand alone application to connect to Google cloud sql - Mysql database. I could find samples for app client but not for stand alone java application. When I tried to do this, I get the following error. Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:google:mysql://IP:Instance_name?user=user_name"); Statement st...

Intermittent issue in Google cloud sql via Google apps script and HTML

html,google-apps-script,google-cloud-sql
Our App is developed with the following requirements Front end: HTML and Google apps script Back end: Google Cloud SQL,MySQL VER 5.6.21, engine= InnoDB We are using Stored Procedures to access CLOUD SQL. This stored procedure will be called via Google Apps Script. Example Stored Procedure and the process of...

Changing Permissions of Google Container Engine Cluster

node.js,google-cloud-storage,google-cloud-sql,google-cloud-platform,google-container-engine
I have been able to successfully create a Google Container Cluster in the developers console and have deployed my app to it. This all starts up fine, however I find that I can't connect to Cloud SQL, I get; "Error: Handshake inactivity timeout" After a bit of digging, I hadn't...

Cannot log in to the MySQL server error when logging into phpmyadmin with Google Cloud SQL on Google App Engine

google-app-engine,phpmyadmin,google-cloud-sql
EDIT: Changed my question around as this is the real problem: I followed this Google guide to deploy phpmyadmin on Google Cloud SQL with Google App Engine. I followed the tutorial and deployed phpmyadmin successfully to my App Engine however, when I try to log in with user: "root" password:...

CLOUD SQL - Can’t save ‘add auth IP’ settings in Google Cloud console

google-cloud-sql,google-cloud-console
I want to authorize/add a IP under Cloud sql ‘Access Control’ in Cloud console, I can add new IP, but when I click the SAVE btn, it does not seem to function or nothing happens when I click the SAVE btn, not even an err message is thrown.we have in...

Google Cloud SQL Instance through local phpMyAdmin

mysql,phpmyadmin,google-cloud-sql
Am new to Google Cloud SQL. I just created a instance in Cloud Console. Now I like to connect to that Instance via my localhost phpMyAdmin. But CloudSQL doestn't have any host name to configure. It only have IPV6 adress. So am little confused about how to do. I already...

Google Cloud SQL - ERROR 2003 (HY000): Can't connect to MySQL

mysql,google-app-engine,command-line-interface,ip-address,google-cloud-sql
I am trying to connect my Google Cloud SQL using the command line. I can successfully connect when at home and I set a static IP address. However, I have to be on the road the next few days and I can't be at home. I am hoping to connect...

Google Cloud SQL disable Table Name Case Sensitivity

google-cloud-sql
Is there a way to change the setting to disable table name case sensitivity? I know that in the .cnf all you have to do is add this; lower_case_table_names = 1 Although I cannot seem to find a way to do that. Thanks...

Google App Engine PHP fetchAll(PDO::FETCH_ASSOC) doesn't work

php,google-app-engine,pdo,google-cloud-sql
I've deployed a project on Google App Engine that returns Json Object on call to the url. I've use this code fetchAll(PDO::FETCH_ASSOC); to return results that will only use column name as the key to retrieve the value from when parsing in the app. However on deployment to the app...

How to Connect to a Google Cloud SQL Instance from a Different Server

php,mysql,sql,cloud,google-cloud-sql
I need your help! I'm trying to connect to the Google Cloud SQL instance from a different server (ie.,provided through Hostgator) but I am unable to select the Database (which is already created at Google Cloud SQL) using the mySQL function - "mysql_select_db" in order to store and retrieve data...

Simple DB query - GAE cloudSQL

mysql,google-app-engine,google-cloud-sql
I have a DB of size 50GB where the number of columns are 12. I have indexes on few of the columns. I am unable to get results from a simple query. SELECT id, subscriber, name, time_ac, type,message, UNIX_TIMESTAMP(time_ac) AS time FROM logs WHERE domain = 'domain' AND type =...

Migration from Google cloud sql to datastore

gae-datastore,google-cloud-sql,google-datastore
Is there an easy way to migrate a large (100G) Google cloud sql database to Google datastore? The way that comes to mind is to write a python appengine script for each database and table and then put it into the datastore. That sounds tedious but maybe it has to...

Cloud Endpoints with Cloud SQL sample code

java,google-app-engine,google-cloud-endpoints,google-cloud-sql
I am looking to use Cloud Endpoints to create an API on the Google App Engine but all the tutorials I see are for how to interact with the Cloud Datastore. I am looking to use Cloud SQL though. Does anyone have a Cloud Endpoints class sample code (in Java)...

How to connect to Google Cloud SQL from VB.NET?

vb.net,google-cloud-sql
I've created an app using VB.NET and I am planning on making a mobile app that will access the data created by the desktop app I made. So I'm thinking of uploading or publishing the database that the app is using somewhere on the web so that the mobile app...

Low performance of slow_log table in Google Cloud SQL

php,google-app-engine,google-cloud-sql
I'm using a Google Cloud SQL instance for a project on Google App Engine. I have enabled the slow query log flag to store slow queries. But the slow_log table's performance is really bad, just for selecting some data took about 6 minutes. I have also noted that the logged...

Bug configuring Cloud SQL instance? Error encountered while trying tutorial

google-cloud-sql
I'm following the tutorial at https://cloud.google.com/nodejs/getting-started/using-cloud-sql and hit an issue with the section "Configure the new Cloud SQL instance". Basically, I can't click "Save" successfully when entering the "0.0.0.0/0" network configuration. Chrome's Javascript Console shows an error "Custom HTML/JavaScript blocked. See go/13687728." What's going on? I tried continuing with the...

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

python,mysql,django,google-app-engine,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 1.2.4 there, and 1.2.5 in the virtual env, I get...

How to migrate Wordpress between Compute Engine instances

wordpress,migration,google-compute-engine,google-cloud-sql
I have recently created a very small Google Compute Engine instance, naively thinking it's one of those easily scalable things Google people keep raving about. I used the quick deployment feature of Wordpress and it all installed itself nicely, so I started configuring and adding data etc. However, I then...