Re: [google-cloud-sql-discuss] 2nd gen backups with mysqldump --routines --events possible?

Hello Rob,

As previously mentioned by Vadim, the 2nd Generation Cloud SQL export should include everything. This is valid when using the SQL Admin API as well. You won't need to use ExportContext.SqlExportOptions to include routines or events, if you wish to export them in back up. You can try this using Google APIs Explorer.

Sincerely,

On Thursday, May 19, 2016 at 2:56:20 PM UTC-4, Rob wrote:

Thanks, will give it a test.

It is possible to achieve the same with the SQLAdmin API Export? Does gen 2 via the admin API t now also to specify --routines --events ?

I ask only because ExportContext.SqlExportOptions does not seem to have any options other than Schema Only and the specific tables.

On Thursday, May 19, 2016 at 2:50:27 PM UTC-4, Vadim Berezniker wrote:

Second Generation backups should include everything, you should not have to change any settings.

Give it a try.

On Thu, May 19, 2016 at 11:46 AM Rob <rober...@parasql.com> wrote:

In first gen Cloud SQL it was not possible to specify backups with the equivalent of mysqldump --routines --events (triggers were backed up as that is the default).

Is it possible to specify these parameters for gen2 Cloud SQL? Could this even be made the default so everything is backed up?

Also, is this now possible at least via the CloudSQLAdmin API so i can run my own backups that include everything?

--

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8e747c6a-3e39-42a6-b982-5eeff4ed8668%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: 2nd Gen DB instance is updating outside of the maintenance window

Great thanks, message sent

On Wednesday, 25 May 2016 21:35:01 UTC+1, Tianzhou Chen wrote:

Sorry, could you please send your instance name to clou...@google.com

On Wednesday, May 25, 2016 at 1:12:37 PM UTC-7, Ben Rometsch wrote:

Is this normal? I have my maintenance window set to Tuesday, 1:00 AM — 2:00 AM UTC+1, but my site is currently down at 20:00 UTC. What does "Update" signify in the Operations Log? Is this a MySQL patch update? All of these have been happening outside of the backup window too! 

DB has been down now for about 10 minutes!?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e49b1977-8e1c-4ee8-8458-37f80661fd84%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: 2nd Gen DB instance is updating outside of the maintenance window

Sorry, could you please send your instance name to cloud-sql@google.com

On Wednesday, May 25, 2016 at 1:12:37 PM UTC-7, Ben Rometsch wrote:

Is this normal? I have my maintenance window set to Tuesday, 1:00 AM — 2:00 AM UTC+1, but my site is currently down at 20:00 UTC. What does "Update" signify in the Operations Log? Is this a MySQL patch update? All of these have been happening outside of the backup window too! 

DB has been down now for about 10 minutes!?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2ee4d8db-3bca-4dfc-846a-c8f2abf85150%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: 2nd Gen DB instance is updating outside of the maintenance window

Hi Ben,

    Could you please send me a private message with the instance name you have, I will take a look.

Thanks
Tianzhou

On Wednesday, May 25, 2016 at 1:12:37 PM UTC-7, Ben Rometsch wrote:

Is this normal? I have my maintenance window set to Tuesday, 1:00 AM — 2:00 AM UTC+1, but my site is currently down at 20:00 UTC. What does "Update" signify in the Operations Log? Is this a MySQL patch update? All of these have been happening outside of the backup window too! 

DB has been down now for about 10 minutes!?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3442ec6a-ebb4-4d13-a75b-917c0000adf4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] 2nd Gen DB instance is updating outside of the maintenance window

Is this normal? I have my maintenance window set to Tuesday, 1:00 AM — 2:00 AM UTC+1, but my site is currently down at 20:00 UTC. What does "Update" signify in the Operations Log? Is this a MySQL patch update? All of these have been happening outside of the backup window too! 

DB has been down now for about 10 minutes!?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/d9321548-d673-4dae-8bae-4516e5e60378%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: There are any plans to support MySQL 5.7?

Hello Amina,

Cloud SQL does not automatically upgrade between major MySQL versions.  The steps for migrating an instance from MySQL 5.6 to 5.7 involve exporting data from the MySQL 5.6 instance and importing that data into the 5.7 instance.  Sample migration steps can be found in our documentation.

On Sunday, May 22, 2016 at 1:42:55 AM UTC-7, Amina wrote:

Thank you very much for supporting mysql 5.7

1. I saw that I cannot change existing instance from 5.6 to 5.7, even if I stop the instance before editing: (the option is disabled)

2. I try to create a 5.7 replicate of 5.6, and it is not works. The version is disabled.

Do you have any recommendation how to migrate an 5.6 Cloud SQL instance to 5.7? I didn't found any way?

I know I can export (dump) the data to cloud storage and import to 5.7, but I will miss any operation that happened between the import and export.

Do you have any recommendation?

On Thursday, May 19, 2016 at 11:49:11 PM UTC+3, Tony Tseng wrote:

Hi Ian,

MySQL 5.7 is available now on Second Generation: https://cloud.google.com/sql/faq#about_1

You can create a 5.7 instance today. On the instance creation page, click on "Advanced options", and you should see a drop down box for database version.

On Wednesday, May 11, 2016 at 5:51:23 PM UTC-7, Ian wrote:

Hello Zeehad,

Has JSON support been added to Cloudsql in the meantime?

If not, do you have a rough ETA? ;-)

Thanks,

Ian

On Monday, March 14, 2016 at 8:59:52 PM UTC, Zeehad (Cloud Platform Support) wrote:

Hello Eric,

As mentioned recently on another post, please know we're currently working on it but cannot provide you with an exact timeline as it takes time to deploy a new version. I suggest you add a 'star' to the original feature request as a vote for the issue and to receive automatic updates.

Cheers!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/5ac2f4c7-4fd0-4fcc-9b44-a136897e6a13%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Google vision api not working

Hi,

You are probably not going to find many Cloud Vision experts on the Cloud SQL discussion list. The cloud-vision-discuss list might be a better place for you to ask.  I recommend you include the exception you get back, and also the actual HTTP request your java code is sending (which you can do by setting the com.google.api.client.http.level property to CONFIG)

Yours,

David

On Fri, May 20, 2016 at 11:21 PM, Jaiwant Rawat <f2012714@pilani.bits-pilani.ac.in> wrote:

I was your api but it is not working for the following image (url.png) 

When I was using your java code when I give image in  encoded byte format it is giving exception but when I am giving image using source from cloud storage url  then it is working ..

It is working fine for other image . 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/aa323f96-d735-4534-a135-e8ffe477f410%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bZHH9oT9S8m4FjmK5nki%2BURWQenukX1u7EXuhORkNQrbg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: There are any plans to support MySQL 5.7?

Thank you very much for supporting mysql 5.7

1. I saw that I cannot change existing instance from 5.6 to 5.7, even if I stop the instance before editing: (the option is disabled)

2. I try to create a 5.7 replicate of 5.6, and it is not works. The version is disabled.

Do you have any recommendation how to migrate an 5.6 Cloud SQL instance to 5.7? I didn't found any way?

I know I can export (dump) the data to cloud storage and import to 5.7, but I will miss any operation that happened between the import and export.

Do you have any recommendation?

On Thursday, May 19, 2016 at 11:49:11 PM UTC+3, Tony Tseng wrote:

Hi Ian,

MySQL 5.7 is available now on Second Generation: https://cloud.google.com/sql/faq#about_1

You can create a 5.7 instance today. On the instance creation page, click on "Advanced options", and you should see a drop down box for database version.

On Wednesday, May 11, 2016 at 5:51:23 PM UTC-7, Ian wrote:

Hello Zeehad,

Has JSON support been added to Cloudsql in the meantime?

If not, do you have a rough ETA? ;-)

Thanks,

Ian

On Monday, March 14, 2016 at 8:59:52 PM UTC, Zeehad (Cloud Platform Support) wrote:

Hello Eric,

As mentioned recently on another post, please know we're currently working on it but cannot provide you with an exact timeline as it takes time to deploy a new version. I suggest you add a 'star' to the original feature request as a vote for the issue and to receive automatic updates.

Cheers!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3380aa46-258d-4f19-a3f5-f9922dd67a51%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Google vision api not working

I was your api but it is not working for the following image (url.png) 

When I was using your java code when I give image in  encoded byte format it is giving exception but when I am giving image using source from cloud storage url  then it is working ..

It is working fine for other image . 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/aa323f96-d735-4534-a135-e8ffe477f410%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: There are any plans to support MySQL 5.7?

Hi Ian,

MySQL 5.7 is available now on Second Generation: https://cloud.google.com/sql/faq#about_1

You can create a 5.7 instance today. On the instance creation page, click on "Advanced options", and you should see a drop down box for database version.

On Wednesday, May 11, 2016 at 5:51:23 PM UTC-7, Ian wrote:

Hello Zeehad,

Has JSON support been added to Cloudsql in the meantime?

If not, do you have a rough ETA? ;-)

Thanks,

Ian

On Monday, March 14, 2016 at 8:59:52 PM UTC, Zeehad (Cloud Platform Support) wrote:

Hello Eric,

As mentioned recently on another post, please know we're currently working on it but cannot provide you with an exact timeline as it takes time to deploy a new version. I suggest you add a 'star' to the original feature request as a vote for the issue and to receive automatic updates.

Cheers!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c593778f-9a15-489d-924a-7ee914f9c258%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] 2nd gen backups with mysqldump --routines --events possible?

Thanks, will give it a test.

It is possible to achieve the same with the SQLAdmin API Export? Does gen 2 via the admin API t now also to specify --routines --events ?

I ask only because ExportContext.SqlExportOptions does not seem to have any options other than Schema Only and the specific tables.

On Thursday, May 19, 2016 at 2:50:27 PM UTC-4, Vadim Berezniker wrote:

Second Generation backups should include everything, you should not have to change any settings.

Give it a try.

On Thu, May 19, 2016 at 11:46 AM Rob <rober...@parasql.com> wrote:

In first gen Cloud SQL it was not possible to specify backups with the equivalent of mysqldump --routines --events (triggers were backed up as that is the default).

Is it possible to specify these parameters for gen2 Cloud SQL? Could this even be made the default so everything is backed up?

Also, is this now possible at least via the CloudSQLAdmin API so i can run my own backups that include everything?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6215f210-cf03-48d8-babc-98ae982a8ed0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2a8fb9ca-fef1-4897-811c-a87364cd9085%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] 2nd gen backups with mysqldump --routines --events possible?

Second Generation backups should include everything, you should not have to change any settings.

Give it a try.

On Thu, May 19, 2016 at 11:46 AM Rob <robert.dyas@parasql.com> wrote:

In first gen Cloud SQL it was not possible to specify backups with the equivalent of mysqldump --routines --events (triggers were backed up as that is the default).

Is it possible to specify these parameters for gen2 Cloud SQL? Could this even be made the default so everything is backed up?

Also, is this now possible at least via the CloudSQLAdmin API so i can run my own backups that include everything?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6215f210-cf03-48d8-babc-98ae982a8ed0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p0VyYc%3D7duoT1cB4qv_SJQX0Hjs2WKyPadw3uDmvy3ZCA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] 2nd gen backups with mysqldump --routines --events possible?

In first gen Cloud SQL it was not possible to specify backups with the equivalent of mysqldump --routines --events (triggers were backed up as that is the default).

Is it possible to specify these parameters for gen2 Cloud SQL? Could this even be made the default so everything is backed up?

Also, is this now possible at least via the CloudSQLAdmin API so i can run my own backups that include everything?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6215f210-cf03-48d8-babc-98ae982a8ed0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: billing enabled but project not working

Hello Jaiwant,

I can confirm that billing for your project ID (330935732633) is active.

Let me know if you have further questions or concerns.

Faizan

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6f617c2b-e96c-43a8-82c7-24491ee0703e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Could SQL instance hung at backup

There is a service upgrade starting from Saturday causing some disruption. All the affected instances should be fixed now. Please let us know if you still experience issue.

Sorry for the inconvenience.

Tianzhou

On Tuesday, May 17, 2016 at 7:46:26 AM UTC-7, Nicholas Geovanis wrote:

In my case, simply waiting from about 9:30pm until subsequent 8:30am gave it enough time to recover (total "recovery" time was about 20 hours). Apparently it's in good condition. It is only a 10GB instance so one thinks that was not really a recovery, something else going on.


On Monday, May 16, 2016 at 6:23:20 PM UTC-5, Faizan wrote:

Hello Nicholas,

This question is related to Google CloudSQL as such, I am forwarding this thread to CloudSQL discussion group. Further followups on this thread can be done on that group.

I hope that helps.

Faizan

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e24ab8b6-93bd-4a95-90ba-1b60ec353657%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] billing enabled but project not working

Project imageversion1 (#330935732633) has billing disabled. Please enable it.

But I have enabled it , please help ..

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/519d3fa3-a58d-463c-9668-3a68fa1f2be8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Could SQL instance hung at backup

In my case, simply waiting from about 9:30pm until subsequent 8:30am gave it enough time to recover (total "recovery" time was about 20 hours). Apparently it's in good condition. It is only a 10GB instance so one thinks that was not really a recovery, something else going on.


On Monday, May 16, 2016 at 6:23:20 PM UTC-5, Faizan wrote:

Hello Nicholas,

This question is related to Google CloudSQL as such, I am forwarding this thread to CloudSQL discussion group. Further followups on this thread can be done on that group.

I hope that helps.

Faizan

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ec0dedfe-ebd8-4364-b176-0c8280619893%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Process terminated because the request deadline was exceeded. (Error code 123)

All requests to the Google Cloud SQL are returning instant errors: "Process terminated because the request deadline was exceeded. (Error code 123)". We have only 1 active connection to Cloud SQL. We tried to restart SQL instance, no matter. It doesn't work

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9b683bed-5744-4083-9aa7-d60aed4ecc9a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Could SQL instance hung at backup

I have the same problem with a Cloud SQL database in us-central (advertopia-mysql-2). The control panel first indicated "Running Backup..." and blocked all other options (import, export, restart, stop, delete). Now, that message is no longer appearing and the database is dead. I am not able to SSH into it to restart (connection eventually times out) and I am completely stuck. My Website is dead. I think somthing went wrong in the datacenter during the backup and the instance still thinks (incorrectly) that the backup is in progress.

I am trying without much luck to force a restart from curl with this command:

curl -X POST -d "" https://www.googleapis.com/sql/v1beta4/projects/Advertopia/instances/advertopia-mysql-2/restart

...but now I'm struggling with authorization...

{

 "error": {

  "errors": [

   {

    "domain": "global",

    "reason": "required",

    "message": "Login Required",

    "locationType": "header",

    "location": "Authorization"

   }

  ],

  "code": 401,

  "message": "Login Required"

 }

}

Any ideas or advice is greatly appreciated.

John K.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fce129a5-159b-4cd4-a4ff-3852011d0806%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Could SQL instance hung at backup

I have tried to forward a thread from GCE discussion group to this group but for some reason the original question is not showing here. For the reference Nicholas question is posted on this thread.

Faizan

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4afe6b9d-aa9d-43ad-a847-b0a0f63aafdc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Fwd: Could SQL instance hung at backup

Hello Nicholas,

This question is related to Google CloudSQL as such, I am forwarding this thread to CloudSQL discussion group. Further followups on this thread can be done on that group.

I hope that helps.

Faizan

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a6c961a8-859c-4788-ab07-a847100c5f77%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: 2nd gen Cloud Storage usage is increasing rapidly

Hey Ufuk,

Did you manage to contact cloud-sql@google.com as Vishnu suggested?

Regards,

Nick
Cloud Platform Community Support

On Thursday, May 5, 2016 at 3:06:12 PM UTC-4, Ufuk Togay wrote:

I have removed instance once disk size is reached to 32GB. This cost me a lot. There is a service sold but there is no service for customers. And it is biggest company of the world.

Shame on you Google.

By the way, about long running queries, same DB was/is running on dedicated server just fine.

5 May 2016 Per, 20:32 tarihinde, 'Vishnu Fafat' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> şunu yazdı:

Hi,

This could happen if you are executing some long-running queries which end up writing temp data to the disk.

If this still happening, can you send us your instance details and some details about schema and access patterns to cloud-sql@google.com

On Sunday, May 1, 2016 at 6:04:41 AM UTC-7, Ufuk Togay wrote:

1 Mayıs 2016 Pazar 16:03:37 UTC+3 tarihinde Ufuk Togay yazdı:

Hi there

I just moved to GCS 2nd gen for better performance. Created db-n1-standard-16 instance with MySQL 5.6 yesterday. Db itself has 2gb data. But after 24 hours storage used is jumped to 10GB. I increased storage capacity to 20gb but it doesn't seem to stop. Increasing about 30mb per minute. I am pretty sure there is no data inserted to my tables.

Logging is disabled and backup is disabled.

Is this normal behaviour?

Is it every going to stop? 

Thanks in advance.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/m5eHC9vnlO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2669e8a2-4365-420f-9dbf-d307c0dfa117%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3a9ae2e2-4354-40e5-8464-e29364bcc51e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: There are any plans to support MySQL 5.7?

Hello Zeehad,

Has JSON support been added to Cloudsql in the meantime?

If not, do you have a rough ETA? ;-)

Thanks,

Ian

On Monday, March 14, 2016 at 8:59:52 PM UTC, Zeehad (Cloud Platform Support) wrote:

Hello Eric,

As mentioned recently on another post, please know we're currently working on it but cannot provide you with an exact timeline as it takes time to deploy a new version. I suggest you add a 'star' to the original feature request as a vote for the issue and to receive automatic updates.

Cheers!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/1be21d10-5de7-425d-a671-75b098df44a1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Question on connections.

A common approach is to use connection pooling in the client application. 

It avoids the need to re-establish connections (which can be expensive in terms of latency) and allows you to limit the total amount of connections in use at any time. It works well in practice.

In case it doesn't, then you may need to introduce caching in your application or apply other techniques (for example creating read replicas and spreading load to them or sharding the data amongst multiple database instances). Things get a lot more complicated once you start going down this path so it's best to see if connection pooling will suffice. 

If performance is a concern, I suggest setting up a load test to see how well the application performs.

On Wed, May 11, 2016 at 5:45 AM meName <boney.scindia@gmail.com> wrote:

Hi,

So as i understand, there is no limit for QPS. But what if my website is dynamic and relies on DB for retrieving and updating information, and say more than 4000 concurrent connections are done at the same time?

My idea of concurrent connections is, say, 10000 users accessing my site at the same time and my site has a script that connects to the DB, so this means that there are 10000 connections at the same time.

Please assist.

Many Thanks.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/68c4ea17-6ed0-4243-b23b-894a538f5a20%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p2bPg8RZ5PC5rCQB23OX1O5VirUeNQf9qyQVt068J%3DVKA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Question on connections.

Hi,

So as i understand, there is no limit for QPS. But what if my website is dynamic and relies on DB for retrieving and updating information, and say more than 4000 concurrent connections are done at the same time?

My idea of concurrent connections is, say, 10000 users accessing my site at the same time and my site has a script that connects to the DB, so this means that there are 10000 connections at the same time.

Please assist.

Many Thanks.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/68c4ea17-6ed0-4243-b23b-894a538f5a20%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Limit of queries per minute

There's no artificial limit. It is limited only by the available CPU/IO of the instance.

On Tue, May 10, 2016 at 2:06 AM Onkar Shinde <boney.scindia@gmail.com> wrote:

Hi,

Is there a limit on the queries i am allowed from my website per minute or per second?

Thanks.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c612b854-9418-4d76-914e-5c5877bddd61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p36beQod7-L_iyQr8FeX1f8HVeauMqyBi5S-aSCGhw_MQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Limit of queries per minute

Hi,

Is there a limit on the queries i am allowed from my website per minute or per second?

Thanks.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c612b854-9418-4d76-914e-5c5877bddd61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Adding a primary key in a huge CloudSQL table

Hey Austin,

This isn't a Cloud SQL -specific error but rather a MySQL error, which is mentioned in many places around the net. It ultimately derives either from the fact that in order to alter a table, a temp table is required, or simply from the fact that adding the column, as small as it is, when multiplied by the number of rows, becomes too large (although it's much more likely to be the former situation).

Since Cloud SQL instances have a maximum amount of disk storage which is provisioned automatically, and which your ALTER query is apparently hitting, it appears that you may have no choice but to attempt to shard the table (which, with so many rows and columns, ought to have been sharded to begin with if the possibility of altering the table were needed in the future) and then run primary key alteration on each table shard, or run the query without the primary key. You could also look into some more exotic possibilities such as the potential relevance of innodb_file_per_table, as recommended in this Stack Overflow Q&A.

Let me know if this works out for you,

Cheers,

Nick
Cloud Platform Community Support

On Monday, April 25, 2016 at 2:08:44 PM UTC-4, Augustin Wenger wrote:

I have a 8Go table in my CloudSQL database that (for now) doesn't have a primary key.

It is composed of 52 million rows of 20 columns each.

I would like to add one, since I will remove duplicates and doing so without primary key is too timeconsuming for MySQL

However, I am having issues to make this run, and I'm wondering if I'm actually doing it in the most efficient way.

I wanted to add this primary key using the following line :

     ALTER TABLE mytable ADD COLUMN id INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

I expected this request to increase the size of my database by a few hundreds MB, and run rather quickly.

However, when I ran the request, I saw the database usage increase a lot ( + 14 GB),  and after 2 hours of running time, I saw the following error message : 

"Error 1114 : the table 'mytable' is full".

When this error occurs, the database storage usage goes back to normal, but no change has been made to mytable

My questions are :

- What is CloudSQL trying to do when I launch my request, and how come it takes him so long ?

- What could I do to make my request executed more quickly by CloudSQL ? What am I missing ?

Thanks in advance,

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/524e01ad-f9e0-411c-915a-1857fe17b32c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Cloud SQL skipping backups even if there are changes

Hey Stevie,

A backup will skip if the instance has been idle since the last backup. If you feel that this isn't the case, this represents a potential production issue which should be reported in the Cloud SQL Public Issue Tracker. When reporting an issue, provide as much technical information about your system as possible, timeline of events, any relevant ID's, and we'll be able to take a look at the issue.

Sincerely,

Nick
Cloud Platform Community Support

On Tuesday, April 26, 2016 at 8:28:04 AM UTC-4, Stevie Frederick wrote:

The automatic backup skipped the last 4 scheduled backups:

DUE_TIME                          ERROR  STATUS

 

2016-04-25T14:00:00.344000+00:00  -      SKIPPED

2016-04-24T14:00:00.814000+00:00  -      SKIPPED

2016-04-23T14:00:00.769000+00:00  -      SKIPPED

2016-04-22T14:00:00.909000+00:00  -      SKIPPED

2016-04-21T14:00:00.527000+00:00  -      SUCCESSFUL

Even though there were changes in the database. My other GCloud SQL instances have continued on their schedule however.

Any ideas why this is happening? I haven't been able to find anything in the support documents.

Bests,

-Stevie

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/24723f57-6ce3-4f3e-ae04-377c48170a28%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Re: 2nd gen Cloud Storage usage is increasing rapidly

I have removed instance once disk size is reached to 32GB. This cost me a lot. There is a service sold but there is no service for customers. And it is biggest company of the world.

Shame on you Google.

By the way, about long running queries, same DB was/is running on dedicated server just fine.

5 May 2016 Per, 20:32 tarihinde, 'Vishnu Fafat' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> şunu yazdı:

Hi,

This could happen if you are executing some long-running queries which end up writing temp data to the disk.

If this still happening, can you send us your instance details and some details about schema and access patterns to cloud-sql@google.com

On Sunday, May 1, 2016 at 6:04:41 AM UTC-7, Ufuk Togay wrote:

1 Mayıs 2016 Pazar 16:03:37 UTC+3 tarihinde Ufuk Togay yazdı:

Hi there

I just moved to GCS 2nd gen for better performance. Created db-n1-standard-16 instance with MySQL 5.6 yesterday. Db itself has 2gb data. But after 24 hours storage used is jumped to 10GB. I increased storage capacity to 20gb but it doesn't seem to stop. Increasing about 30mb per minute. I am pretty sure there is no data inserted to my tables.

Logging is disabled and backup is disabled.

Is this normal behaviour?

Is it every going to stop? 

Thanks in advance.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/m5eHC9vnlO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2669e8a2-4365-420f-9dbf-d307c0dfa117%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAO0g6ZW_3MBiQX2muN5%2BsjUJzN8p6GU%3D9MqBs-ODdiVtCT8h1g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: 2nd gen Cloud Storage usage is increasing rapidly

Hi,

This could happen if you are executing some long-running queries which end up writing temp data to the disk.

If this still happening, can you send us your instance details and some details about schema and access patterns to cloud-sql@google.com

On Sunday, May 1, 2016 at 6:04:41 AM UTC-7, Ufuk Togay wrote:

1 Mayıs 2016 Pazar 16:03:37 UTC+3 tarihinde Ufuk Togay yazdı:

Hi there

I just moved to GCS 2nd gen for better performance. Created db-n1-standard-16 instance with MySQL 5.6 yesterday. Db itself has 2gb data. But after 24 hours storage used is jumped to 10GB. I increased storage capacity to 20gb but it doesn't seem to stop. Increasing about 30mb per minute. I am pretty sure there is no data inserted to my tables.

Logging is disabled and backup is disabled.

Is this normal behaviour?

Is it every going to stop? 

Thanks in advance.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2669e8a2-4365-420f-9dbf-d307c0dfa117%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Release date / Road Map of cloud sql 2nd generation?

Hello Johan,

Cloud SQL Second Generation is still under active development and currently it's not possible to provide any fixed time frame for its general availability or stable release. If you're looking to use this in production and require SLA, please use the 1st generation for now. Once it becomes GA, it will be announced here.

Cheers!

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c28a1e44-737c-49b0-9498-9274d37003f2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Release date / Road Map of cloud sql 2nd generation?

Hi, 

We're starting up a new project on the Google Cloud and we need a SQL database and since the 2nd generation is still in beta we lean towards choosing the 1st generation. But we'll probably not go live in a month or so, so before going all in with the 1st generation I want to get some insights (if possible) of the road map of the 2nd generation. I.e. is the 2nd generation supposed to go GA "soon" or is it expected to take a while still?

Regards,

/Johan

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/660e1165-3475-43fb-9de4-bf9c8bd250b3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: 2nd gen Cloud Storage usage is increasing rapidly

1 Mayıs 2016 Pazar 16:03:37 UTC+3 tarihinde Ufuk Togay yazdı:

Hi there

I just moved to GCS 2nd gen for better performance. Created db-n1-standard-16 instance with MySQL 5.6 yesterday. Db itself has 2gb data. But after 24 hours storage used is jumped to 10GB. I increased storage capacity to 20gb but it doesn't seem to stop. Increasing about 30mb per minute. I am pretty sure there is no data inserted to my tables.

Logging is disabled and backup is disabled.

Is this normal behaviour?

Is it every going to stop? 

Thanks in advance.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/0f316720-57e3-421c-ae33-21fbdad31568%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] 2nd gen Cloud Storage usage is increasing rapidly

Hi there

I just moved to GCS 2nd gen for better performance. Created db-n1-standard-16 instance with MySQL 5.6 yesterday. Db itself has 2gb data. But after 24 hours storage used is jumped to 10GB. I increased storage capacity to 20gb but it doesn't seem to stop. Increasing about 30mb per minute. I am pretty sure there is no data inserted to my tables.

Logging is disabled and backup is disabled.

Is this normal behaviour?

Is it every going to stop? 

Thanks in advance.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8bfc755a-cb2e-4e3b-a8ce-b0ec76f77c48%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Connect to 2nd generation cloud sql from AppEngine standard enviorment.

Please have a look at the official post describing this : https://groups.google.com/forum/#!topic/google-cloud-sql-announce/a4kJX3emde0  

Cloud SQL 2nd gen documentation : https://cloud.google.com/sql/docs/dev-access#gaev1-csqlv2

On Thursday, April 28, 2016 at 5:26:59 PM UTC+2, Jack Liu wrote:

Has anybody tried to successfully connect from AppEngine to 2nd generation cloud sql?

I tried today but it seems does not work.
OperationalError: (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'root'@'cloudsqlproxy~*.*.*.*' (using password: NO)")

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/7b288c07-d793-404b-8e2e-327e22b8921b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.