One GAE Text Search question.

I am using com.google.appengine.api.datastore.Text
to store my blog's article content. I want to make a full
search on all the contents.

In GAE, you can't search on the blob property since
they are not indexed. How do you guys overcome this issue?

Thanks,
Seabook

Re: MySQL DELIMITER statement not working in Squirrel

OK. But when I try the following:
DROP PROCEDURE IF EXISTS test_delimiter;
CREATE PROCEDURE test_delimiter()
BEGIN
SELECT * FROM my_table;
END;
I get:
Error: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '' at line 3
SQLState: 42000
ErrorCode: 1064
Error occured in:
CREATE PROCEDURE test_delimiter()
BEGIN
SELECT * FROM my_table
So how do I create a multi SQL statement procedure or function using
Squirrel? Also, it would be nice to have SQL that works in both
MySQLWorkbench and Squirrel.

The rdbms API is not available because the MySQLdb library could not be loaded.

I have installed MySQL and the necessary support libraries / files
locally. It is accessible from MySQLWorkbench, Squirrel, and the
Python 2.7 command line (i.e. import MySQLdb succeeds without any
errors). I added the following line to my ./bash_profile file too:
export DYLD_LIBRARY_PATH="$DYLD_LIBRARY_PATH:/usr/local/mysql/lib/"
When I try to start dev_appserver in Eclipse or from a command line
using:
dev_appserver.py --debug --mysql_user=root myapp
I get the following warning and error:
WARNING 2011-11-30 21:07:54,891 rdbms_mysqldb.py:90] The rdbms API is
not available because the MySQLdb library could not be loaded.
ERROR 2011-11-30 21:08:19,042 dev_appserver_main.py:632] <type
'exceptions.NotImplementedError'>: Unable to find the MySQLdb library.
Please see the SDK documentation for installation instructions.
DEBUG 2011-11-30 21:08:19,046 dev_appserver_main.py:634] Traceback
(most recent call last):
File "/Applications/GoogleAppEngineLauncher.app/Contents/Resources/
GoogleAppEngine-default.bundle/Contents/Resources/google_appengine/
google/appengine/tools/dev_appserver_main.py", line 629, in main
dev_appserver.SetupStubs(appinfo.application, **option_dict)
File "/Applications/GoogleAppEngineLauncher.app/Contents/Resources/
GoogleAppEngine-default.bundle/Contents/Resources/google_appengine/
google/appengine/tools/dev_appserver.py", line 3183, in SetupStubs
rdbms_mysqldb.connect(database='')
File "/Applications/GoogleAppEngineLauncher.app/Contents/Resources/
GoogleAppEngine-default.bundle/Contents/Resources/google_appengine/
google/appengine/api/rdbms_mysqldb.py", line 96, in connect
'Unable to find the MySQLdb library. Please see the SDK '
I have tried the hack of adding "import MySQLdb" to the
dev_appserver.py file, but that didn't help.
Any ideas?

Re: MySQL DELIMITER statement not working in Squirrel

DELIMITER is a command for the client to use to know when to send the sql statement.  Squirrel doesn't know about it.

Sqirrel doesn't send the sql when enter is pressed, so it's not needed, just remove the DELIMITER commands.

Rob

MySQL DELIMITER statement not working in Squirrel

I have the following statements that work fine in MySQLWorkbench:
DROP PROCEDURE IF EXISTS test_delimiter;
DELIMITER //
CREATE PROCEDURE test_delimiter()
BEGIN
END//
DELIMITER ;
When I try to run them in Squirrel, I get:
Error: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'DELIMITER //
CREATE PROCEDURE test_delimiter()
BEGIN
END//
DELIMITER' at line 1
SQLState: 42000
ErrorCode: 1064
Error occured in:
DELIMITER //
CREATE PROCEDURE test_delimiter()
BEGIN
END//
DELIMITER
Any ideas why?
Also, it would be great to have Cloud SQL support MySQLWorkbench. Is
there a way to connect the two?

Re: Google Cloud SQL preview access

As Joe said in another thread, there's no fixed delay.  We're releasing spaces as resources allow and to try out a range of applications.

Ken

Re: Google Cloud SQL preview access

Hi,

Last time I request and after that about 2 days, google sent me a mail active google cloud sql account. But same to you. Yesterday, I do that with another email but now i am yet to receive active mail from google.
My friend told me that he filled up 3 days ago but now he's yet to receive too.
So I guess, maybe Google stop supporting trying google cloud sql.
I'm not sure.

Just waiting....

Thanks.

--
vì một ngày mai tươi sáng hơn

Google Cloud SQL preview access

Hi,
How can i get access to Google Cloud SQL? Though, I have filled up
access request form last week, i am yet to get the access.
Can you please let me know the criteria for giving access to Cloud
SQL?
Regards,
Vikas

Re: Google Apps Script JDBC Service and Google Cloud SQL

Integrating Cloud SQL with Apps Script is being considered. In the meantime, you can write an App Engine service as a wrapper that exposes Cloud SQL data to your Scripts.

-saurabh

Re: Google Apps Script JDBC Service and Google Cloud SQL

Sorry Joe but what is your answer.
I don't get it.
Regards
Laurent

Speed of one operation

Do GSQL scalable for one big operation? I use MySQL for fulltext
search by email database.
For example now I have about 9000 email in my table and fulltext
search take about 50-90ms. Is time dramatically increase when I upload
3000000 emails in my datadase?

--
Blog: www.rekby.ru

Re: Using GCSQL as application backend

Hi Nick

Google Cloud SQL is currently in limited preview. We'll be announcing pricing and sizing before we make it more widely available, which should give you the information you need to make the call

Joe


Joe Faith | Product Manager | Google Cloud SQL

Re: Is is possible to access Google Cloud SQL while running locally?

Make sure that the driver is in your class path and before using getConnection, register the driver with Class.forName("com.mysql.jdbc.Driver")

--Abhishek

Re: Is is possible to access Google Cloud SQL while running locally?

Yes it might have not found the driver. Where did u put your jar for MySQL connector?
--Abhishek

Using GCSQL as application backend

Hi,

I've written an application that's storing some transactional data in Google Cloud SQL

I'm wondering whether this is going to become an issue when I run into DB size and pricing restrictions?

Is the GCSQL intended -only- for reporting and limited unscalable operations, or is it feasible to use it as the sole backend for an application?

Just wondering whether I should port everything to the datastore and what the intentions of the project are

Loving the cloud SQL so far by the way, makes it so easy to utilise the appengine infrastructure whilst making use of existing Java and relational DB skills

Re: Is is possible to access Google Cloud SQL while running locally?

Thanks, that narrowed it down further.
I used c = DriverManager.getConnection("jdbc:mysql://localhost:3306/
mysql55?
user=root&password=******&useInformationSchema=true&useUnicode=true&characterEncoding=UTF8&useServerPrepStmts=true
");
to do it by hand and got an error:
java.sql.SQLException: No suitable driver found for jdbc:mysql://
localhost:3306....
So I'm guessing it isn't able to find the driver but the wiring in the
VM arguements looks good. Any suggestions?

Re: Cloud invite expired

https://code.google.com/apis/console/shp?frag=project:844144627291:activate&a=6&t=?d%3D6%26p%3D844144627291%26t%3D1323125193%23299726251

let us know how you get on

j

--
Joe Faith | Product Manager | Google Cloud SQL

Re: Google Apps Script JDBC Service and Google Cloud SQL

http://groups.google.com/group/google-cloud-sql-discuss/browse_thread/thread/3e083faf69109cc3

--
Joe Faith | Product Manager | Google Cloud SQL

Re: Is is possible to access Google Cloud SQL while running locally?

I suppose mysql55 is your database name, if this is so, then ur variables seems fine. To check the connection url you can write a simple jdbc code n see if u cud get connection object. Try replacing localhost in URL with IP of your machine.
--Abhishek

Re: where can i get detail tutorial for using cloud sql in gae?

If you are interested in it, here is a small post about my tutorial showing how to use googlecloudsql with play + siena :
http://mandubian.tumblr.com/post/13459210142/tutorial-for-googlecloudsql-with-play-1-2-3-siena

It's just a test app so issues might exist. Don't hesitate to report them on siena github or siena google group !

regards
Pascal

Re: Is is possible to access Google Cloud SQL while running locally?

Heh, I noticed that, I'm coming from Oracle where case isn't
important. It is in capital letters as that's the case I'm used too.
But yes, I created my table in uppercase. I tried lower case too just
to be sure. No dice.
What about my VM arguements:
Drdbms.server=local -Drdbms.driver=com.mysql.jdbc.Driver -
Drdbms.url=jdbc:mysql://localhost:3306/mysql55?
user=root&password=******&useInformationSchema=true&useUnicode=true&characterEncoding=UTF8&useServerPrepStmts=true
How do I know the URL is right? Where do I look to make sure this part
'localhost:3306/mysql55' is correct? I just copied the mysql55 part
from the MySQL Workbench
Thanks for your suggestions

Re: how to use cursor.executemany?

I don't think the %s should be in quotes.

Rob

Re: trigger (delimiter)

Yes it is, but entering these kind of commands through the browser-based input box may not be the best option.

I had more luck trying to create triggers and procedures (and changing the delimiter) through the command line tool or the Squirrel SQL client.

Re: Is is possible to access Google Cloud SQL while running locally?

Your table name is in capital letters or is in proper case? MySql is case-sensitive and could say table not found even if table exists but is in different case.

--Abhishek

Re: Is is possible to access Google Cloud SQL while running locally?

I remove the Schema and I get this:
java.sql.SQLException: Table not found in statement [SELECT * FROM
MYTABLE]

Re: Is is possible to access Google Cloud SQL while running locally?

I ask because I keep getting:
Error listing items: java.sql.SQLException: invalid schema name:
MILKRUN in statement [SELECT * FROM TESTDB.MYTABLE]
Even though I can execute that query fine within the MySQL Workbench.
Where is rmdbs.url stored?

Is is possible to access Google Cloud SQL while running locally?

From what I've read it doesn't look like it but I didn't really
understand the external connection thing.

I'm having problems creating my own MySQL instance and getting it to
work with my dev env and even still it would be a challenge to
maintain them both. Is it possible to run my application locally but
point to GCSQL?

trigger (delimiter)

I have a problem with creating trigger. Command "delimiter |" doesn't
work alone nor together with CREATE TRIGGER command. Is it possible to
create triggers (procedures) in sql cloud?

delimiter |

CREATE TRIGGER trigger_name AFTER INSERT ON tablex
FOR EACH ROW BEGIN
.......
END;
|

delimiter ;

how to use cursor.executemany?

code:
========
wkL = [("11111111111",), ("22222222222",), ("3333333333333",)]
#or wkL = ["11111111111","22222222222","3333333333333"]
cursor.executemany( u"insert into entries ( guestName, content )
values( '%s', 'ZZZZZZZZZZZ' )", wkL )

error
========
File "/base/data/home/apps/s~chatthor/1.354968998651775855/2.py",
line 19, in get
cursor.executemany( u"insert into entries ( guestName, content )
values( '%s', 'ZZZZZZZZZZZ' )", wkL )
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 344, in executemany
self.execute(statement, args)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 290, in execute
response = self._conn.MakeRequest('Exec', request)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 596, in MakeRequest
response = self._MakeRetriableRequest(stub_method, request)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms.py", line 620, in _MakeRetriableRequest
response = self.MakeRequestImpl(stub_method, request)
File "/base/python27_runtime/python27_lib/versions/1/google/storage/
speckle/python/api/rdbms_apiproxy.py", line 68, in MakeRequestImpl
raise OperationalError('could not connect: ' + str(e))
OperationalError: could not connect: ApplicationError: 1006
mysql_stmt_param_count: Not all variables bound. Got 1, expected 0.

Re: Google Apps Script JDBC Service and Google Cloud SQL

I'm definitely interested in this as well.  We have a client who is easily going to exceed the max number of cells in a Google spreadsheet with their Google sites collaboration application.

So we're looking at going directly into a MySQL database and would prefer to use Google Cloud SQL accessible from Google appscript and using the JDBC services: http://code.google.com/googleapps/appsscript/class_jdbc.html to access the tables.

How can we do this as it appears you're currently imposing a limitation of only Google App Engine instances being able to access Google Cloud SQL instances?  It appears to be simply a matter of Google enabling JDBC access from their Google Apps servers. It's an internal change so shouldn't be a drama. The JDBC services for Appscript are fully MySQL compliant so their shouldn't be any technical issues.

P.S. And yes, we have to use Google sites/appscript as this is imposed by the customer. GAE is not an option (currently!)

Regards,

Geoff

Re: Triggers / Stored procedures?

Yes it has initially you have to create from sql window and after that using program, you can call that proc.

 Thank you.

Regards,

Bhargava Sriram A.

Triggers / Stored procedures?

As far as I can tell, the documentation is not entirely clear about
this - are triggers/stored procedures supported?

Thanks,

Giovanni

Re: where can i get detail tutorial for using cloud sql in gae?

Yes but let me write it please :D

Re: where can i get detail tutorial for using cloud sql in gae?

thank you.
but what i need is a documentation.

Re: where can i get detail tutorial for using cloud sql in gae?

This is my purpose...
The demo already works there!
http://tweetsql.appspot.com/

I needed to update play-gae module to upgrade it to SDK 1.6.0 and also to customize a bit play-siena to use GoogleCloudSQL because this is MySQL but not exactly.

I will publish the code also to help people begin with it (and test a bit further than me all of this stuff ;))

Pascal

Re: where can i get detail tutorial for using cloud sql in gae?

Thanks a lot Pascal, please share it to all.

 Thank you.

Regards,

Bhargava Sriram A.

Re: where can i get detail tutorial for using cloud sql in gae?

I'm writing a tutorial for Play Framework + Siena Project.
Should publish it early next week!

regards
Pascal

Re: where can i get detail tutorial for using cloud sql in gae?

my examples:
from google.appengine.api import rdbms
conn = rdbms.connect(instance='projectname:instancename',
database='database_name', charset='utf8') # charset - for dev-server
cursor = conn.cursor()
cursor.execute('DELETE FROM `email` WHERE id=%s', [id])
cursor.close()
cursor = conn.cursor()
cursor.execute(u'REPLACE INTO `email` (`id`, `time`, `from`, `to`,
`subject`, `comment`, `text`) VALUES (%s, %s, %s, %s, %s, %s, %s)',
[email.id(), email.Time.strftime('%Y-%m-%d--%H-%M-%S'), email.From,
email.To, email.Subject, email.Comment, email.Text])
cursor.close()
cursor = conn.cursor()
cursor.execute("select from email WHERE `from`=%s", ['asd@mail.ru'])
result = cursor.fetchall()
for row in result:
...

where can i get detail tutorial for using cloud sql in gae?

the example code is too simple. i need detail tutorials for the conn
and curcor and other way to deal the data.

Re: Sql Syntax Error

Hi,

I think there is a extra comma in the end (the red one) --->  oth + "' ,)";

--Abhishek

Sql Syntax Error

Hai Team,
             while running my project from ecilpse i am getting this following error
1.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
2.I tried to set the value manually in that case it working fine

Here is my code,tell me that what mistake i have done in that code

  String statement ="INSERT INTO stock (systemno,username,

systemipadd,servicetagno,cpumodel,monitor,webcam,mouse,keyboard,headset,ethernetcable,vgacable,powercable,otherdevices) VALUES('" + sn + "', '" + un + "','" + sip + "','" + sip + "','" + stn + "','" + cpu + "','" + mon + "', '" + web + "','" + mouse + "' , '" + key + "' ,'" + head + "' , '" + enc + "'  ,'" + vgc + "'  , '" + pwc + "' ,'" + oth + "' ,)";
          PreparedStatement stmt = c.prepareStatement(statement);
          stmt.setString(1, sn);
          stmt.setString(2, un);
          stmt.setString(3, sip);
          stmt.setString(4, stn);
          stmt.setString(5, cpu);
          stmt.setString(6, mon);
          stmt.setString(7, web);
          stmt.setString(8, mouse);
          stmt.setString(9, key);
          stmt.setString(10, head);
          stmt.setString(11, enc);
          stmt.setString(12, vgc);
          stmt.setString(13, pwc);
          stmt.setString(14, oth);
          int success = 2;
          success = stmt.executeUpdate(statement);
Thanks
Sasikala

Re: Can we use same instance for more than one app ID?

Awesome, Thanks it works!!

- Bala

Re: Can we use same instance for more than one app ID?

Try changing your instance to a bigger size.

Ken 

Can we use same instance for more than one app ID?

Hi Team,

Can we access same instance / DB from more than one GAE application? while I was trying its saying "You have reached maximum number of authorized applications" even though it has only one enables.

Thanks,

Bala

Cloud invite expired

Hi,

I was just going through old emails and saw my cloud invite.
Unfortunately it has expired. Do I need to re-register or can I get
the invite sent again.

Thanks for your time.

Re: App Engine to connect cloud sql with error: ApplicationError: 1007 Invalid connection id

Connection has a ping() method.

Also it takes roughly the same amount of time to check connection validity as opening a new connection, so it might be easier to open a new connection at the beginning of each request and close it in the end.

Here's the doc:

def ping(self, reconnect=False):

    """Checks whether or not the connection to the server is working.

    If it has gone down, an automatic reconnection is attempted.

    This function can be used by clients that remain idle for a long while, to

    check whether or not the server has closed the connection and reconnect if

    necessary.

    Non-standard. You should assume that ping() performs an implicit rollback;

    use only when starting a new transaction.  You have been warned.

    Args:

      reconnect: Whether to perform an automatic reconnection.

    Raises:

      DatabaseError: The connection to the server is not working.

    """

Re: App Engine to connect cloud sql with error: ApplicationError: 1007 Invalid connection id

Hi Tony,
Thanks for your quick reply.
Could you tell me how to valid the connection?
The codes in my local dev environment worked well without any problem,
and it also worked without any problem in App Engine platform before
yesterday. That's so wired. And the problem still exist after I
restart the instance.

Re: App Engine to connect cloud sql with error: ApplicationError: 1007 Invalid connection id

Hi John,

The connection can become invalid for a variety of reasons. You'll need to check to see if the connection is valid before you use it.

App Engine to connect cloud sql with error: ApplicationError: 1007 Invalid connection id

I am using app engine on python to connect the Cloud SQL, and it
worked well for few days. But from yesterday, I got the error for any
database query:
OperationalError: could not connect: ApplicationError: 1007 Invalid
connection id.

In my python codes, I used singleton pattern to maintain one
connection for all my database operations, and I am not sure that
caused the problem.

Re: Mistake in documentstion,

OK.

http://code.google.com/p/googleappengine/issues/detail?id=6404

Re: Mistake in documentstion,

Hi Timofey,

Could you file a bug using http://code.google.com/p/googleappengine/issues/list?

Mistake in documentstion,

http://code.google.com/intl/en/appengine/docs/python/memcache/functions.html don't describe for_cas parameter for function get.

--
Blog: www.rekby.ru

Re: anybody running django on the app engine with the sql service?

I think a good way to connect could be using the remote api, but is not available neither planned.

Star this issue http://code.google.com/p/googlecloudsql/issues/detail?id=21 if you think would be helpful.

-Sebastian

www.devsar.com

Re: Using Cloud SQL via App Engine Remote API

I think this wold actually be a useful feature for a fair number of developers.

I've submitted a ticket: http://code.google.com/p/googlecloudsql/issues/detail?id=21

Richard

Re: No response for Google Cloud SQL Signup

Most of you people get their requests fulfilled after holidays.

 Thank you.

Regards,

Bhargava Sriram A.

No response for Google Cloud SQL Signup

I have fill the request form days ago and i haven't have response.

How many days will have i to wait?

I am really interested in test this service because that many projects
in that i work, run on MySQL.

Re: Using Cloud SQL via App Engine Remote API

I +1 this, because it would make easier the integration with django as it would make simple to add support of syncdb and schema migrations with the management commands.

Cheers, Sebastian

Re: Any way to change cloud sql instance global variable values

Sorry. This feature is not currently supported.

What if I create a new instance, give its name to you guys to set  just one variable value for me? Is it possible?

-- Abhishek

Re: Using Cloud SQL via App Engine Remote API

Hello,

I understand that I can use the command line client.

But the App Engine Remote API allows me to run my App Engine code and access Datastore entities from a remote client. Do you think there will be a Cloud SQL stub implemented for this at some point?

Not currently planned.  You can file something in the tracker and we'll see if other people want something similar.  http://code.google.com/p/googlecloudsql/

Ken 

Re: Any way to change cloud sql instance global variable values

What if I create a new instance, give its name to you guys to set  just one variable value for me? Is it possible?

-- Abhishek

Re: Using Cloud SQL via App Engine Remote API

Hello,

I understand that I can use the command line client.

But the App Engine Remote API allows me to run my App Engine code and access Datastore entities from a remote client. Do you think there will be a Cloud SQL stub implemented for this at some point?

Richard

Connection caching and sharing

Hello,

I'm sharing and caching a database connection in my Python App Engine for each instance by holding a reference to the connection at module level. Something like this:

_conn = None

def get_connection():

  global _conn

  

  if _conn is None:

    _conn = rdbms.connect(...)  

  return _conn

This seems to work OK and so far I haven't seen any problems with the connection timing etc.

Does anyone know if this is a good idea? Could I run into threading problems etc. At the moment each instance only served one request at a time but our app will be switching to multi-threaded Python2.7 soon. 

Is there any way of detecting a connection has become disconnected or timed-out and re-connect?

Regards

Richard

Re: Any way to change cloud sql instance global variable values

Hi Abhishek,

Unfortunately cloud sql does not support user-specified startup options at this point.

Re: Any way to change cloud sql instance global variable values

You can give your tables names in the correct case?

Cloud SQL limited preview

Dear Cloud SQL Limited Previewers

This is a friendly reminder that Cloud SQL is currently in limited preview: that means we are offering it on a limited basis to selected developers so that they can preview its capabilities and allow us to improve the service, and it is currently offered without performance or availability guarantees.

Cloud SQL is not currently recommended for mission-critical or high-intensity production applications.

While evaluating Cloud SQL we would ask you to bear in mind the following:

• All your data is multiply geographically replicated, but we do not currently offer an automated backup service. Backups can be taken manually through the Google Cloud SQL dashboard (under 'Actions').
  
  
• Synchronous replication also has an impact on write performance compared to non-replicated local disk. This especially affects bulk data imports. There are useful tips on optimising bulk imports here:
  http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html
  
  
• Also bear in mind that many queries also involve writing to disk, for example those involving 'order by' clauses, and that these will also be slowed by replication. There are useful tips on optimising such queries here:
  http://dev.mysql.com/doc/refman/5.5/en/order-by-optimization.html

Let me know if you have any questions

thanks

J

--
Joe Faith | Product Manager | Google Cloud SQL

Re: Any way to change cloud sql instance global variable values

So what could be the solution, given that my local mysql server has
lower_case_table_names variable set to 1, setting this variable
resolved my case sensitivity problem with hibernate locally and I need
same database to be imported to my cloud-sql instance so that same
application could work without giving any case-sensitivity problem on
app-engine with cloud-sql?
The only solution I could think of right now is to somehow get a
cloud-sql instance with 'lower_case_table_names' set to 1.
Please suggest.
--Thanks,
Abhishek

Re: Any way to change cloud sql instance global variable values

It's not a privilege issue. That particular system variable cannot be set dynamically according to http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_lower_case_table_names.

Re: Any way to change cloud sql instance global variable values

Hi Tony,

When I am trying to set global variable 'lower_case_table_names' , I am getting "Variable 'lower_case_table_names' is a read only variable".

--Abhishek

Re: Any way to change cloud sql instance global variable values

Hi Abhishek,

You should be able to set global variables. What's the error that you're seeing?

Re: Any way to change cloud sql instance global variable values

I think the SUPER privilege has not been granted to us on our cloud sql instance.
Is it possible that if we provide you with our instance name, then you will turn this variable on for us?

--Thanks
Abhishek

Re: Programmatic/Command Line Exporting of an Instance to Cloud Storage?

Unfortunately the feature to programmatically trigger an export is not available yet.

Re: Issue connecting SQL

To get the instance name, login to https://code.google.com/apis/ ;
Click on Google Cloud SQL --> Overview.
--
Manilal K M : മണിലാല്‍ കെ എം.
http://libregeek.blogspot.com

Re: Programmatic/Command Line Exporting of an Instance to Cloud Storage?

Thank you for the quick response!  but I am trying to solve a
different problem.
What I am attempting to do is find a way to trigger an export from
Google Cloud SQL to Google Cloud Storage.
I basically want to trigger the same functionality as clicking
[Instance Settings] -> (Export Data) menu functionality within the
Google Cloud SQL dashboard.
Thanks!

Re: Programmatic/Command Line Exporting of an Instance to Cloud Storage?

Hi Mac,

If you want to export your mysql dump to your cloud sql instance, then you can do it using google cloud sql command line tool.
Details could be found here:

http://code.google.com/apis/sql/docs/commandline.html

---Abhishek

Programmatic/Command Line Exporting of an Instance to Cloud Storage?

Is there any way of exporting an instance to cloud sql other than
using the UI in the cloud sql management screens? I have been
looking, but perhaps (or obviously) I am missing something...

Re: JDBC connection string problems

If you were trying to get this working from within a dev GAE app, I
haven't had any luck and truthfully haven't tried too hard. I was
working on a bootstrapping/migration utilities intended to run outside
of the GAE environment. I would be eager to hear if anybody has pulled
it off though.

Any way to change cloud sql instance global variable values

Hi,

Is there any way to change the value of global  variables for my cloud sql instance?
I want to change specifically the value of variable "lower_case_table_names" to 1.

Thanks,
Abhishek

Re: geospatial queries

I have been hoping for access to the app engine full-text search
solution. I don't have access yet.
Having a mysql solution that is likely to get corrupted unless the
data is read-only is not workable for my app that does many data
insertions.
Having a solution that is spreadsheet based (I guess for reporting)
like fusion tables doesn't seem right for an app that is dynamic and
needs to scale.
Waiting for Google to release full-text search support for app
engine :-(

Re: Using Cloud SQL via App Engine Remote API

Remote access to Cloud SQL is currently available via the command line

http://code.google.com/apis/sql/docs/commandline.html

or from the Squirrel client

http://code.google.com/apis/sql/docs/usingsquirrel.html

j

Re: Using Cloud SQL via App Engine Remote API

To be clear, I'm using the remote API described here:  http://code.google.com/appengine/articles/remote_api.html

Re: anybody running django on the app engine with the sql service?

Hi,

I'm working in the integration. It is still not tested and definitely not optimized and has some features that a want

to implement, but I made a admin interface works.

The most import features that I want to implement is to run a remote syncdb instruction. 

Yes, that is the tricky one and the reason why we say that it isn't supported.  You would have to build the python equivalent of the jdbc driver that we talk about here: https://code.google.com/apis/sql/docs/usingsquirrel.html

That's a lot of work.  As a workaround, maybe you can just get the CREATE TABLE statements that syncdb would execute and issue them manually.  I know it won't handle schema migrations and other stuff, but it is a start.

Ken

Using Cloud SQL via App Engine Remote API

Hello,

I've tried accessing Cloud SQL via the remote API but I get this error: "No api proxy found for service "rdbms"

I assume this isn't implemented yet. Is it planned to be?

It would be very useful.

Regards

Richard

Re: Issue connecting SQL

Thanks for your help!!

Is the instance_name means (appid name (or) sql instance name (or) just "instance_name")

Thanks,

Bala

Re: Registering project ID: Are hyphens allowed or not?

Hyphens apparently are not allowed -- it's a bug that the UI text claims they are. Sorry about the confusion.

Thanks,

Brian

Registering project ID: Are hyphens allowed or not?

Hi there,
When registering project ID, it clearly says 6-63 letters, digits or
hyphens. But when ever I add hyphen(s) (not as first or last
character) it always says that project ID isn't available. So I assume
that the tip must be invalid, or validation/availability process is
incorrect.
So "is-this-raD0M-test" invalid ID? AFAIK, it shouldn't be. Or maybe
that hyphens part should be removed from tip text.
- Thanks
Best regards,
Sami Lehtinen
http://www.sami-lehtinen.net/

Re: Issue connecting SQL

Are you trying to do this on your local machine or in a deployed app?

When you're running in appengine, your app will connect to Cloud SQL, assuming you've set up the connection properly (in the guestbook example, this is due to code of the form c = DriverManager.getConnection("jdbc:google:rdbms://instance_name/guestbook");). When you're running locally in the dev appserver, the JDBC driver proxies to a database on your local machine, assuming you've set the system properties up correctly.

Thanks,

Brian

Re: Issue connecting SQL

Also in my understanding I should have mysql server in my local machine, how this would work from appengine environment?

SQL Instance id mapped to application ID, IS there anything iam missing from application side?

Thanks,

Bala

Re: Issue connecting SQL

Hello Brian,

Here is my VM settings

-Ddatastore.default_high_rep_job_policy_unapplied_job_pct=50 -Xmx512m "-javaagent:C:\Program Files (x86)\eclipse\plugins\appengine-java-sdk-1.6.0\lib\agent\appengine-agent.jar" 

-Drdbms.server=local 

-Drdbms.driver=com.mysql.jdbc.Driver 

-Drdbms.url=jdbc:mysql://localhost:3306/yourdatabase?user=username&password=password

  java.sql.SQLException: Communications link failure  The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Caused by:

javax.servlet.ServletException: java.sql.SQLException: Communications link failure  The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.  at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)

Thanks,

Bala

Re: Issue connecting SQL

Hi,

See http://code.google.com/apis/sql/docs/developers_guide_java.html.

I think you might be setting the rdbms.server system property to your instance name. It should be the value "local".

Thanks,

Brian

Issue connecting SQL

Hi all,

I am new to this service, I am stuck here please let me know what Iam missing.

No enum const class com.google.appengine.api.rdbms.dev.LocalRdbmsService$ServerType <instance ID>

java.lang.IllegalArgumentException: No enum const class com.google.appengine.api.rdbms.dev.LocalRdbmsService$ServerType.A-CTI.COM:IT-INVENTORY:SARAS-DEV  at java.lang.Enum.valueOf(Enum.java:196)  at com.google.appengine.api.rdbms.dev.LocalRdbmsService$ServerType.fromFlagValue(LocalRdbmsService.java:70)  at com.google.appengine.api.rdbms.dev.LocalRdbmsService.createDelegate(LocalRdbmsService.java:164)  at com.google.appengine.api.rdbms.dev.LocalRdbmsService.init(LocalRdbmsService.java:84)  at com.google.appengine.tools.development.ApiProxyLocalImpl.startServices(ApiProxyLocalImpl.java:581)  at com.google.appengine.tools.development.ApiProxyLocalImpl.access$700(ApiProxyLocalImpl.java:46)  at com.google.appengine.tools.development.ApiProxyLocalImpl$2.run(ApiProxyLocalImpl.java:564)  at com.google.appengine.tools.development.ApiProxyLocalImpl$2.run(ApiProxyLocalImpl.java:562)  at java.security.AccessController.doPrivileged(Native Method)  at com.google.appengine.tools.development.ApiProxyLocalImpl.getService(ApiProxyLocalImpl.java:561)  at com.google.appengine.tools.development.ApiProxyLocalImpl.resolveDeadline(ApiProxyLocalImpl.java:233)  at com.google.appengine.tools.development.ApiProxyLocalImpl.doAsyncCall(ApiProxyLocalImpl.java:214)  at com.google.appengine.tools.development.ApiProxyLocalImpl.makeSyncCall(ApiProxyLocalImpl.java:147)  at com.google.apphosting.api.ApiProxy.makeSyncCall(ApiProxy.java:101)  at com.google.appengine.api.rdbms.RdbmsApiProxyClient$ApiProxyBlockingInterface.makeSyncCall(RdbmsApiProxyClient.java:89)  at com.google.appengine.api.rdbms.RdbmsApiProxyClient$ApiProxyBlockingInterface.openConnection(RdbmsApiProxyClient.java:75)  at com.google.cloud.sql.jdbc.internal.SqlProtoClient.openConnection(SqlProtoClient.java:58)  at com.google.cloud.sql.jdbc.Driver.connect(Driver.java:59)  at com.google.cloud.sql.jdbc.Driver.connect(Driver.java:26)  at java.sql.DriverManager.getConnection(DriverManager.java:582)  at java.sql.DriverManager.getConnection(DriverManager.java:207)  at org.apache.jsp.guestbook_jsp._jspService(guestbook_jsp.java:66)  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)  at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)  at com.google.appengine.tools.development.PrivilegedJspServlet.access$101(PrivilegedJspServlet.java:23)  at com.google.appengine.tools.development.PrivilegedJspServlet$2.run(PrivilegedJspServlet.java:59)  at java.security.AccessController.doPrivileged(Native Method)  at com.google.appengine.tools.development.PrivilegedJspServlet.service(PrivilegedJspServlet.java:57)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)  at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)  at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)  at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)  at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)  at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)  at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)  at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:78)  at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:327)  at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)  at com.google.appengine.tools.development.StaticFileUtils.serveWelcomeFileAsForward(StaticFileUtils.java:80)  at com.google.appengine.tools.development.LocalResourceFileServlet.maybeServeWelcomeFile(LocalResourceFileServlet.java:254)  at com.google.appengine.tools.development.LocalResourceFileServlet.doGet(LocalResourceFileServlet.java:120)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)  at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:35)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)  at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:60)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)  at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)  at com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:122)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)  at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)  at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)  at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)  at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)  at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)  at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)  at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)  at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:78)  at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)  at com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:362)  at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)  at org.mortbay.jetty.Server.handle(Server.java:326)  at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)  at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923)  at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)  at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)  at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)  at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)  at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Thanks,

Bala

Re: anybody running django on the app engine with the sql service?

Hi,

I'm working in the integration. It is still not tested and definitely not optimized and has some features that a want

to implement, but I made a admin interface works.

The most import features that I want to implement is to run a remote syncdb instruction. 

I think the easiest way to do it is to directly (from development environment) access the google cloud sql instance.

Are there some way that a I can connect the the cloud sql instance from the development environment in python? I didin't found any documentation about that.

Tomás

Re: Google Apps Script JDBC Service and Google Cloud SQL

Hi Joe,
Thanx for the answer and for this product.
Anyway I don't where is the problem.
Because it seems that we can't use the "JDBC Cloud SQL driver" with
Google Apps Script JDBC Service. And when I try to use the "MySQL
one", I don't connect. But I may not have the good connection URL.
Thx in advance.
Regards
Laurent

Re: anybody running django on the app engine with the sql service?

Hi Raúl

  This guy is working on the integration: https://github.com/tomascorrea/django-google-cloud-sql

  I havent test it, but looks promising.

-Sebastian

www.devsar.com

plus: http://plus.sserrano.com

linkedin: http://ar.linkedin.com/in/sebastianserrano

Re: anybody running django on the app engine with the sql service?

Hi,

Has anyone seen any progress about this anywhere?

Like Sebastián, I am about to get my hands dirty, trying to get Django to work with Cloud SQL on App Engine, but I'd like to save some time, if someone had already made it possible - or proven that it's really impossible.

Since Cloud SQL is based on MySQL, the innocent child in me wants to believe it will be a simple matter of copying Django's MySQL adapter, adding the from google.appengine.api import rdbms code and little more than that.

Probably too simple, I know, but what's like without some dreams, right? :)

Raul

Re: My Google Cloud SQL is not activated

Takes some time to activate it seems, mine also the same issue.

 Thank you.

Regards,

Bhargava Sriram A.

My Google Cloud SQL is not activated

My google cloud sql service is not activated
i hv request before few days.

pls help us to get this.

case sensitivity

Hi all,

Last week when we were testing our hibernate-oracle application with mysql (mysql server running on linux server), some of our queries failed due to the case difference of some of the tables. The solution we did was to set a variable   value to 1 in /etc/my.cnf file. This makes mysql ignore the cases and hibernate was happy to run the queries.
Since I need to run the same application with cloud-sql instance, there is a probability that same problem could occour. Is there any workaround to avoid case-sensitivity in cloud-sql instance? A stitch in time might help me save nine :) .

---Thanks,
Abhishek

Google Cloud SQL & Toad

I'm loving GCSQL but this squirrel client is pretty rough around the
edges, anyone managed to connect with Toad? Is it possible or does a
custom driver need to be written?

Re: Import Failure (Internal Failure)

Hi Joe,

> does this need changing?
> http://code.google.com/apis/sql/faq.html#importexportdatabases

I just got access and have tried out various things today. Most things
appear to work as long as you do the right actions - the help pages
and this group are rather useful to get on track. Error messages could
be better. It is also a bit silly that the SQL prompt in the web
interface assumes that you actually type in commands - if I just paste
something in, the execute button is still disabled so I must fiddle to
be allowed to execute.

Thanks for reporting this... I filed an issue to track it here:

http://code.google.com/p/googlecloudsql/issues/detail?id=20

Anyway, there appears to be something iffy with the import. The dump
I've experimented with claims to be imported, but the data is missing
from some of the tables. I'm pretty sure that the reason is that the
dump is not correctly sorted (data in one table refer to other tables
that are further down in the file). This is easily fixed as such, but
it illustrates my statement above: Error messages are currently not
handled in a very user friendly way - I must pretty much already
anticipate problems even though they are not reported.

Was this a dump you took via mysqldump on a non-Cloud SQL instance, or a dump you exported from another Cloud SQL instance? If the former, what were the exact mysqldump options you passed.

FWIW, apologies about the lack of good error reporting. We're aware of this issue.

And while I'm at it: The activity animation along the top during
import appears to be mostly for show - it seems to go on a lot longer
than the actual import.

It may be off by up to 60s (since that's how often we poll the server for status).

Now, don't take this wrong - I think this is a great idea and not bad
at all for early adopters. Keep it up!

/ Jonas

Re: Import Failure (Internal Failure)

Hi Joe,

I just got access and have tried out various things today. Most things
appear to work as long as you do the right actions - the help pages
and this group are rather useful to get on track. Error messages could
be better. It is also a bit silly that the SQL prompt in the web
interface assumes that you actually type in commands - if I just paste
something in, the execute button is still disabled so I must fiddle to
be allowed to execute.
Anyway, there appears to be something iffy with the import. The dump
I've experimented with claims to be imported, but the data is missing
from some of the tables. I'm pretty sure that the reason is that the
dump is not correctly sorted (data in one table refer to other tables
that are further down in the file). This is easily fixed as such, but
it illustrates my statement above: Error messages are currently not
handled in a very user friendly way - I must pretty much already
anticipate problems even though they are not reported.
And while I'm at it: The activity animation along the top during
import appears to be mostly for show - it seems to go on a lot longer
than the actual import.
Now, don't take this wrong - I think this is a great idea and not bad
at all for early adopters. Keep it up!
/ Jonas

Re: expired invitation link

Hi,

I tried many to reactivate Cloud SQL but still I'm not able to activate. Please help me out.

Thanks and Regards
Ashfaq

Re: Google Apps Script JDBC Service and Google Cloud SQL

Hi Laurent

its a really nice idea, and we're looking into it.

The obstacle you are probably running into is that the spreadsheet is not authorised to access that instance.

j

Google Apps Script JDBC Service and Google Cloud SQL

This summary is not available. Please click here to view the post.

Re: expired invitation link

Dmitry

i'll follow up off-board

j

expired invitation link

Missed Cloud SQL invitation letter in my inbox. Link is already expired=( But still would like to try this feature.

Joe, could you help with that?

thanks!

problem with accessing mysql

some how I missed the access URL now im not sure what happened about
the URL sent my google. but for me still it shows request access.

Re: Access more then one application to MySQL-instance.

I can't second application in "Authorized applications".

I have error:

You have reached the maximum number of authorized applications for this instance

Try using the "Instance Settings" to change your instance size.  The small size allows only one authorized app.

Ken 

Access more then one application to MySQL-instance.

I can't second application in "Authorized applications".

I have error:

You have reached the maximum number of authorized applications for this instance
--
Blog: www.rekby.ru

Re: MySQL version 5.5

Very slow import in mysql 5.5

I have dump for 11024 records. Size of dump 3MB (25 MB after decompress). Time for import it - 11 minutes.

Comparison with Datastore

Are there any comparisons of Cloud SQL versus the "standard" Google
AppEngine Datastore? How do they compare with each other performance-
wise?

Re: MySQL version 5.5

You should be able to create 5.5 instances now.

Re: MySQL version 5.5

We hear you, and we're looking at solutions.

In the meantime we'd suggest including a version number in the instance name if it is likely to be rebuilt regularly.

j

Re: MySQL version 5.5

Joe,
From what I've read on this group it is not possible to delete an
instance and reuse the instance name in a new instance.
Using the method in the article above database updates this would
force us to make changes to our applications to point to the new
instance name.
Is this something we would only have to deal with during the limited
preview or is this something we should expect going forward?
In other words will we need a new instance name for each database
upgrade?
Have the ability to re-use the instance name once the upgrade is
complete would be beneficial .
In some cases I can see a benefit of using two instances for cut-over
periods so we are in control.

Thoughts?

Re: MySQL version 5.5

No problem. I will wait until we hear its ready.
Thank you for the fast response!

Re: MySQL version 5.5

Hi,

There's a bit of a delay in getting 5.5 out as the default. Sorry for the inconvenience & confusion. We'll update this thread when it's ready.

Thanks,

Brian

Re: MySQL version 5.5

Joe, Thank you for the instructions but i'm having a problem.
When I tried to create a new database instance to move my data into it
created the new instance as version 5.1 still.
The dashboard for the new instance shows :
Properties
Status: Running
Version: MySQL 5.1
Replication Type: Synchronous
and the overview screen shows the version MySQL 5.1 also
Did i miss something ?

MySQL version 5.5

Dear All

 

As from today all new instances of Google Cloud SQL will run MySQL version 5.5. We would encourage users currently running older instances (version 5.1) to upgrade to the newer version; a step-by-step guide is available here: http://code.google.com/apis/sql/docs/upgrade.html

We will remove support for MySQL from Feb 2012.

Let us know if you have any questions

J

--
Joe Faith | Product Manager | Google Cloud SQL

Re: No response for Google Cloud SQL Limited Preview Signup

Hi Narender

I see you signed up yesterday; it may take a few more days yet

j

No response for Google Cloud SQL Limited Preview Signup

I signed up for Google Cloud SQL Limited Preview Signup and did not
get any response yet. I went in and signed up a second time but still
no response. Can anyone please look into it.

Thanks
Narender

Re: wrong project automatically activated via limited preview form!

Hi Roberto,

I'll follow up off-board

j

wrong project automatically activated via limited preview form!

I've signed up via "Google Cloud SQL Limited Preview Signup" and I've
got my invitation, but it got activated for a new project in the
Google APIs console.
It started a new empty "My Project" (517917635734) but I really want
to test it in my current project (244657026238).
I've tried everything and there's nothing I can do other than kindly
ask for you guys to switch it.
Thank you very much!

Re: Cant activate Cloud SQL

Chigurh

I'll contact you off-board about this

J

--
Joe Faith | Product Manager | Google Cloud SQL

Re: Unicode text in dev-server.

I solve it for me by add charset='utf8' in  rdbmc.connect parameter.

rdbms.connect(instance='...', database='...', charset='utf8')

Unicode text in dev-server.

When I try insert Russian text (unicode) from python I have exception:

  File "c:\programs\PYTHONLIB\MySQLdb\cursors.py", line 159, in execute

  File "c:\programs\PYTHONLIB\MySQLdb\connections.py", line 264, in literal

  File "c:\programs\PYTHONLIB\MySQLdb\connections.py", line 202, in unicode_literal

UnicodeEncodeError: 'latin-1' codec can't encode characters in position 0-5: ordinal not in range(256)

In production code work fine. I don't set connection explicit.Utf8 is default charset for my local database.

code example:

from google.appengine.api import rdbms

conn = rdbms.connect(instance='...', database='...')

cur = conn.cursor()

cur.execute(u'REPLACE INTO `email` (`id`, `time`, `from`, `to`, `subject`, `comment`, `text`) VALUES (%s, %s, %s, %s, %s, %s, %s)',

                    ['123', '2011-10-9--10-11-25', 'test@test.com', 'testto@test.com', u'Привет', u'Комментарий', u'Русский текст'])

Re: Cant activate Cloud SQL

I had the same problem and after re-log/retry, it worked for me!

Pascal

Re: Cant activate Cloud SQL

Nevermind, clicked the link again and now I got the "accept TOS"
message box and was able to enable it.
It seems it didn't work the first time because I wasn't logged in with
the correct account.
Sorry for the noise,
Pedro Morais

Re: Cant activate Cloud SQL

Oops, misread the original post.
Actually I add an URL, and clicked it, but it still shows Request
Access.
Regards,
Pedro Morais

Re: Cant activate Cloud SQL

I'm having the exact same issue.
Checked the project id from the URL slug, and it's the correct, but it
still shows "Request access" instead of the toggle switch.
Regards,
Pedro Morais

Re: Import taking too long?

Hi Jesse,

How many rows are added with each INSERT statement in the .sql file?  Make sure there are enough rows so that each INSERT is about 1 megabyte total.  Or to put it another way, how many INSERT statements are there in the file?

Ken

Import taking too long?

Folks,

I've tried twice now to run an import for a mysqldump via Cloud
Storage that contains roughly 1 million records (~250MB file).
The .sql file contains the usual - a series of CREATE TABLE and INSERT
() statements. There are 24 tables involved, each with < 5 indexes
and a couple of many-to-many maps in the Django style. I'd love to do
them all at once instead of running 24 separate imports - the DB size
isn't very large at all in the terms that I usually work.

I've attempted to run the import twice, and each time it got cut off
at the 24 hour mark with a generic error (I'm guessing Google cuts off
imports at 24 hours, yes?). At that time, it had completed roughly
100,000 records at a rate of a few per second (I was able to query the
tables with count(*)'s as they imported to check the rate), decreasing
in rate as the tables grew. Any ideas why this was so slow? Each
record is relatively small (think 10 VARCHAR(100) columns and a couple
of dates). I'm close to just giving up on it as impossible to import
at my scale, unless I get clued in on why it's taking so long.

Thanks,

Jesse

Cant activate Cloud SQL

Hi! I got this mail from nobody@google.com:
------------------------------------------------------------------------------------------------------------------------------------------------
Thank you for your interest in Google Cloud SQL. You can activate the
service using the URL below using your account:
Please note that the link expires in 48 hours.
Then visit our documentation at: https://code.google.com/apis/sqlservice/
For any questions or comments please use http://groups.google.com/group/google-cloud-sql-discuss
To receive announcements and updates about Google Cloud SQL, subscribe
to https://groups.google.com/group/google-cloud-sql-announce/
Looking forward to you getting started on Google App Engine using
Google Cloud SQL.
Thanks,
The Google Cloud SQL Team
------------------------------------------------------------------------------------------------------------------------------------------------
Where is the link that expires in 48 hours? I tried to activate Cloud
Sql in the Api console but i cant. Still says "request access". And i
only have API project in the project list.
What to do?

Re: Database Replication

Hi Abhishek

1. Sorry, we don't yet offer this
2. We understand your frustration, but slow import performance is a result of synchronous replication. We are initially focusing on durability & uptime rather than performance; hence synchronous replication.

J

Re: pricing

Hi William

We understand your concern and will be announcing pricing shortly.

Thanks for the kind words

J

pricing

Hi,

Cloud SQL is great, even epic, but I'm a bit "scared" : we have no
idea about the pricing yet...

Actually, I hesitate to make plans which would involve Cloud SQL
because I don't know yet if I can afford it.

Do you have any information about a price range and what kind of
operation will be charged, or at least, approximate date for pricing
information ? That would reassure us and encourage us to make real
plans.

PS : This is not an angry/complain message at all, Cloud SQL is the
only feature GAE was missing to be the perfect PaaS.

Database Replication

Hi all,

I have two queries rising their heads out of curiosity plus need.

1) Is there any data replication solution so that we could use the local counterpart of our cloud-sql database and keep it in sync with the changes in cloud-sql database?

2) Currently when we are importing just around 3-4 GB of data to my cloud-sql instance, it is taking a hell lot of time. I am wondering what will happen when we'll need to have all my data (around 400GB) to cloud-sql instance :) . Is there, or would there be, any mechanism to make such replication faster, at least to some extent ?

Thanks,
Abhishek

Re: Test agreement.

Hi Timofey

Anything you learned as a trusted tester is governed by the confidentiality clause in the agreement (which works both ways); but anything you subsequently learned through limited preview is public domain.

The best route would be if you send me a draft of what you wanted to say (to myself, not the list) and we'll see if there's anything that breaches those terms. 

We'd be very interested to hear about your experience in any case

thanks

Joe 

database monitoring

Hi Brian,

Its a yes for first two of your questions. It would be great if query execution time could be   monitored for a particular query.
By buffer gets I ment the use of internal data buffer cache in memory to avoid frequent disk access.
There are some monitoring tools our DBA use to keep an eye on DB health n performance. Our application, like all the major business applications, is highly database driven and we want it to perform even better over cloud sql. So I was wishing for some kinda monetoring and performance enhancing tool for cloud sql as well.

Re: database monitoring

Hi Abhishek,

Some questions inline below.

Thanks,

Brian

Re: database monitoring

The usual ones- Connection and user count, connection time, query execution time,response time,buffer gets,disk reads, and the like.

--Abhishek

Test agreement.

Hello.

Text of initial agreement for test SQL Cloud very big and difficult for understand.

I have question - can I describe my experience and research in my public blog?

--
Blog: www.rekby.ru

Re: need some help to get started on Google Cloud SQL

Hi ken,
Yes, dropping database or tables would be a better solution, However, I was trying to learn how the instance name works with a project id.  I experiment this。   Ａnd also I already deleted the instance, now the question is after the 2 month before it can be reused, is it possible that someone else uses this instance name before I recreate it and thus I lost it forever? 

No -- your instance name includes a project identifier that's globally unique. Unless you grant access to your project to someone else, nobody else can claim your instance name.

The unique instance name is based on only the instance name itself or combination of project_id:instance name?   But I guess this is not a big deal since this is invisible thing for a web app anyway and I can always create a different instance for my app as I learned.   
Thanks.
Xiping

Re: Can't repair table

Thanks.

Do you need my instance id and database name for research?

Do you need my database and table for research or I can drop and re-create it?

Re: database monitoring

What kinds of metrics are you interested in monitoring?

Thanks,

Brian

Re: Can't repair table

I've filed an issue in our external issue tracker for this: http://code.google.com/p/googlecloudsql/issues/detail?id=17

database monitoring

Hi,

Is there any way to monitor our cloud sql instance? Keeping the tab over database performrance would be a great help in comparing it with the local counterparts.  Monitoring helps in clearly visualizing the big picture and encourage decision makers to take a leap to cloud with rdbms.

Thanks,
Abhishek

Re: need some help to get started on Google Cloud SQL

Hi ken,
Yes, dropping database or tables would be a better solution, However, I was trying to learn how the instance name works with a project id.  I experiment this。   Ａnd also I already deleted the instance, now the question is after the 2 month before it can be reused, is it possible that someone else uses this instance name before I recreate it and thus I lost it forever?  The unique instance name is based on only the instance name itself or combination of project_id:instance name?   But I guess this is not a big deal since this is invisible thing for a web app anyway and I can always create a different instance for my app as I learned.   
Thanks.
Xiping

Re: Could not parse mapping document from .hbm.xml

Hi Ikai,

I've resolved the problem. You are right, something else was breaking this. A deadline exceeded exception while creating the session was the root cause. When I resolved that problem, the xml problem got resolved automatically.

Thanks,
Abhishek

Re: need some help to get started on Google Cloud SQL

found that
"if I delete my instance, can I reuse the instance name?
   Yes, but not right away. The instance name is reserved for up to
two months before it can be reused."
While reserving a instance name is good, I think for the owner of an
instance should be able to delete and recreate immediately.
In particular, in this early stage, people like me is learning how to
use or best use the service, am I right?  Ｔhanks.

Instead of deleting the instance, DROP TABLE or DROP DATABASE are an easy way to start over with the same instance.

Re: Could not parse mapping document from .hbm.xml

It's not obvious to me where the error is coming from, but if I had to guess, it's based on where you are putting this file. Where are you putting hibernate.cfg.xml in your application?

Can you get this working with a simple example to eliminate the possibility of something else breaking this?

--

Ikai

Re: Can't repair table

Yes. I did it from web console.

It repeat from sql command line:

sql> select count(*) from email;

+-----------------------+

| count(*)              |

+-----------------------+

|                  6118 |

+-----------------------+

1 row in set (0,79 sec)

sql> delete from email;

Can't change size of file (Errcode: 5)

From command line SQL tool repair table finish with success, but it took long time:

sql> select count(*) from email;

+-----------------------+

| count(*)              |

+-----------------------+

|                  6090 |

+-----------------------+

1 row in set (0,67 sec)

sql> repair table email;

Number of rows changed from 6090 to 5755

gb_gbsupport.email | repair | status   | OK

2 rows in set (274,17 sec)

Than try delete from table second time:

sql> select count(*) from email;

+-----------------------+

| count(*)              |

+-----------------------+

|                  5757 |

+-----------------------+

1 row in set (0,53 sec)

sql> delete from email;

Can't change size of file (Errcode: 5)

sql> select count(*) from email;

Connection id no longer valid.

re-open sql command line tool

sql> select count(*) from email;

+-----------------------+

| count(*)              |

+-----------------------+

|                  5758 |

+-----------------------+

1 row in set (0,79 sec)

Re: Can't repair table

Is this from SQL prompt in the web console? Do you see the same error from the command line SQL tool?

I have MySQL instance with 1 database. Database have 1 table `email` with full text index.

Now size of instance 46 MB.

I try: "REPAIR TABLE email" and see error: 

Error 0: 

Unable to execute statement

But after some time (1-2 minutes) table start work as repaired.

Re: I can't delete data from table

My table `email` broke some days ago. I tried to repair it, but have error 0 'Unable to execute statement'. Now I can't delete data from it table.

I have instance with one database. Database have one table.

Volume of MySQL instance - about 50MB.

Structure of table:

CREATE TABLE IF NOT EXISTS `email` (

  `id` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

  `time` datetime NOT NULL,

  `from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

  `text` text COLLATE utf8_unicode_ci,

  PRIMARY KEY (`id`),

  KEY `time` (`time`),

  FULLTEXT KEY `email_full_text` (`text`,`from`,`to`,`subject`,`comment`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

I can't delete data from table

I want delete all data from my table.

I try: DELETE FROM `email` and DELETE FROM `email` WHERE 1=1

I have error: 

Error 0: 

Unable to execute statement

 

--
Blog: www.rekby.ru

Re: How to do Full Text Search in GSQL?

If I change the table type in the the dump file and then import the
database into Google MySQL will the Full Text Search functionality
still be available on the Google version of the database? Will I
still be able to run Full Text Searches against the table that is
hosted on Google MySQL?
Thanks

Can't repair table

I have MySQL instance with 1 database. Database have 1 table `email` with full text index.

Now size of instance 46 MB.

I try: "REPAIR TABLE email" and see error: 

Error 0: 

Unable to execute statement

But after some time (1-2 minutes) table start work as repaired.

Re: How to do Full Text Search in GSQL?

I use MyISAM tables for full text search.

You can change table type in dump file before import it into google MySQL.

Re: need some help to get started on Google Cloud SQL

Thank you for all the quick and clear explanations. Yes, you are
absolute right, by using myproject:myinstance, I was able to get the
Guestbook sample code running with easy! I will test out the local
db in a few minutes by following the link you provided. Thanks a
lot! Have a great day!

Re: Using foreign keys

Glad to hear it.

Rob

Re: need some help to get started on Google Cloud SQL

You would use myproject:myinstance.  Your local database doesn't actually use the instance name specified, but rather will always talk to the local database pointed to by the rdbms.url system property (see http://code.google.com/apis/sql/docs/developers_guide_java.html#using_the_java_development_server)

2. I followed the Guestbook tutorial on Google Cloud SQL website
exactly and by accessing my deployed tutorial app on App engine with
"myinstance" only in driver string, I get  "Error: Server Error   The
server encountered an error and could not complete your request."
What is the best approach to trouble shooting the issues of a deployed
web app on Google App Engine like this?  (sorry, this might be a app
engine question).

There's a "Logs" page in AppEngine that may have some information.  Also, while developing, I prefer to throw ServletException on errors since those will propagate back and give you a stack trace on the web page.  It makes things easier while developing and debugging.

2. After I deleted an instance I created, and then tried to create it
again, I got an error  like "instance .... already exists in the
domain".   How  can I really delete the instance so that I can
recreate it from "the domain" (which domain) ?

I don't think that's possible yet.

3. In order to run the same code using a local database, I have to
create the same database instance and the database, tables, etc as on
Cloud SQL as I think.   This seems imply that in question 1, I should
not have "myproject" in the driver string, since a local database will
not have a project name for a database instance, am I right?

I am very excited to learn how to best use Google cloud computing
services and all other cool web development tools.

Thanks and best regards

Thanks,

Rob