Re: [google-cloud-sql-discuss] Digest for google-cloud...@googlegroups.com - 1 update in 1 topic

I am using sqlalchemy dialect and here is the URI i am using.

mysql+mysqldb://root@/<dbname>?unix_socket=/cloudsql/<projectid>:<region>:<instancename>

but i got the following error.  OperationalError: (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'root'@'cloudsqlproxy~*.*.*.*' (using password: NO)")

  Do you have any idea where went wrong?


On Saturday, April 30, 2016 at 1:32:44 AM UTC+8, amadison wrote:

yes, it works just fine for my projects... the socket string is a little different than the 1st gen was

On Fri, Apr 29, 2016 at 9:59 AM, <google-cloud...@googlegroups.com> wrote:

google-cloud-sql-discuss@googlegroups.com

Google Groups

Topic digest
View all topics

• Connect to 2nd generation cloud sql from AppEngine standard enviorment. - 1 Update

Connect to 2nd generation cloud sql from AppEngine standard enviorment.

Jack Liu <liuyo...@gmail.com>: Apr 28 08:26AM -0700 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)")

Back to top

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.

--
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/474f818c-3ed9-4b42-ad1e-1a315c5bb5df%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Digest for google-cloud-sql-discuss@googlegroups.com - 1 update in 1 topic

yes, it works just fine for my projects... the socket string is a little different than the 1st gen was

On Fri, Apr 29, 2016 at 9:59 AM, <google-cloud-sql-discuss@googlegroups.com> wrote:

google-cloud-sql-discuss@googlegroups.com

Google Groups

Topic digest
View all topics

• Connect to 2nd generation cloud sql from AppEngine standard enviorment. - 1 Update

Connect to 2nd generation cloud sql from AppEngine standard enviorment.

Jack Liu <liuyoufeng@gmail.com>: Apr 28 08:26AM -0700 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)")

Back to top

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.

--
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/CAEB7q8KhxN0an36%2BC6LOAMO-Ca0A0sjLMBuMsez1P7f10%2Ben8w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

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/7c53ea17-5555-4036-a001-743b7de981d3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] In Cloud SQL second generation, you do not support point-in-time recovery. So Why binary-logs are so HUGE?

Hi Amina-

As David mentions, point in time recovery is supported for Cloud SQL First Generation instances.  It is not yet supported for Second Generation instances.  Binary logging is required to enable replication (failover or read replicas) on Second Gen instances.  Your existing binary log files can be removed by disabling backups and binary logging.

Thanks,

Brett

On Tuesday, April 26, 2016 at 9:50:24 AM UTC-7, David Newgas wrote:

Hi,

We do support point in time recovery: https://cloud.google.com/sql/docs/backup-recovery#pitr. Binary logs are kept as far back as your oldest backup (7 days).

On Tue, Apr 26, 2016 at 1:05 AM, Amina <aminadavg@gmail.com> wrote:

My DB contains 3GB of data.

The binary log 10GB. 

What do you keep the binary log, after the failover instance replicate the data?

As I understand you do not support point-in-time recovery, so I don't need it. 

Am I right?

How long do you save the binlogs?

--
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/970852e2-0998-4de3-acd7-80eacc4d3a3c%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/7fcd2f1b-4f52-4fe7-9840-916efdec8e92%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Is it possibile to view in StackDriver logging all sql queries that runs on Cloud SQL second generation?

If you want to view all queries that run, you must set general_log=TRUE and log_output=TABLE following https://cloud.google.com/sql/docs/mysql-flags. The output is stored in the mysql.general_log table, and is in CSV format.

As CSV is inefficient and can massively increase restart times, we strongly recommend you keep this table small by frequently truncating it. If you need to preserve the contents use INSERT ... SELECT. See https://cloud.google.com/sql/docs/mysql-flags#tips-general-log

On Tue, Apr 26, 2016 at 12:14 AM, Amina <aminadavg@gmail.com> wrote:

--
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/c8507cfc-bccf-41c3-9be2-590a4a99d699%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_bZLaXx_Ux560UaM4dn_XuaDK8OoY_OhJ5dQMCu0_A0v6Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] In Cloud SQL second generation, you do not support point-in-time recovery. So Why binary-logs are so HUGE?

Hi,

We do support point in time recovery: https://cloud.google.com/sql/docs/backup-recovery#pitr. Binary logs are kept as far back as your oldest backup (7 days).

On Tue, Apr 26, 2016 at 1:05 AM, Amina <aminadavg@gmail.com> wrote:

My DB contains 3GB of data.

The binary log 10GB. 

What do you keep the binary log, after the failover instance replicate the data?

As I understand you do not support point-in-time recovery, so I don't need it. 

Am I right?

How long do you save the binlogs?

--
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/970852e2-0998-4de3-acd7-80eacc4d3a3c%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_baxY7dM-vG2Uq2T%2BXf_gnc2EWMmc0wFPLiuOzL5nyriYw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

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/905abe5d-36e6-4f44-91e1-f6198b6a19eb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] In Cloud SQL second generation, you do not support point-in-time recovery. So Why binary-logs are so HUGE?

My DB contains 3GB of data.

The binary log 10GB. 

What do you keep the binary log, after the failover instance replicate the data?

As I understand you do not support point-in-time recovery, so I don't need it. 

Am I right?

How long do you save the binlogs?

--
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/970852e2-0998-4de3-acd7-80eacc4d3a3c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: I have change the size of Cloud SQL second generation. How to change the size of the failover instance?

After waiting couple if minutes it is done automatically.

On Tuesday, April 26, 2016 at 10:07:31 AM UTC+3, Amina wrote:

I cannot change the size (from 10GB to 50GB) of the failover instance.

But the master instance now have 50GB. What should  do?

--
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/1cda5fc2-751a-4f7f-9f9f-67698f9face4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Is it possibile to view in StackDriver logging all sql queries that runs on Cloud SQL second generation?

--
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/c8507cfc-bccf-41c3-9be2-590a4a99d699%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] I have change the size of Cloud SQL second generation. How to change the size of the failover instance?

I cannot change the size (from 10GB to 50GB) of the failover instance.

But the master instance now have 50GB. What should  do?

--
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/8100ebd9-9910-4b4e-94fb-c059ae75e066%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

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/7a3e2efd-1513-48dc-8a90-a79b4c993ecd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Cloudsim

Can anyone help me in implementing best fit decreasing algorithm Bin packing algorithm in cloudsim

--
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/0ed09bbe-e67e-4f5b-a5b1-eb3f559e77e7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How do I add proxy and authorization to access Cloud SQL db from my PC

Thank you,

I was able to follow the steps and it works for me with cloud proxy installed on my local windows 8 machine. Now I access the db using cloud_sql_proxy_x64.exe..

Thanks again

Babu

On Tuesday, April 19, 2016 at 11:42:13 AM UTC+5:30, Babu wrote:

That seems to be an excellent option and thank you for suggesting. That way I don't have to use the VM only for proxy. 

I will follow the steps mentioned and try to set it up.

Regards

On Monday, April 18, 2016 at 9:10:45 PM UTC+5:30, Kevin Malachowski wrote:

To be explicit: you can run the Cloud SQL Proxy directly from your PC. No need to use a Compute Engine VM! Please feel free to post back if you are having trouble setting up the Proxy, we'll be glad to help out.

In general, there are three major steps:

1) Download the proxy: on the page previously linked, you can download a precompiled version for your OS/CPU combination of your system.

2) Run the proxy: there are a few examples at the bottom of the page on how to start running the proxy

3) Connect to the proxy: depending on what flag options you passed to the proxy when starting it, you will need to configure your application (mysql command line, for example) to connect via TCP or UNIX socket.

If you have gcloud installed and have run `gcloud auth login`, the latest version of the proxy will just use those credentials when accessing Cloud SQL Databases.

On Sunday, April 17, 2016 at 11:38:22 AM UTC-7, Kamran (Google Cloud Support) wrote:

Hello Babu,

You can use Cloud SQL Proxy. The Cloud SQL Proxy is useful when connecting from clients with dynamic IP addresses. Please visit this article for more information about Google Cloud SQL Proxy and installation instructions. However, please note that this is a Beta release.

Sincerely,

Kamran

On Sunday, April 17, 2016 at 1:26:03 AM UTC-4, Babu wrote:

Hello,

I am a newbee on cloud sql - please help me. 

I have created a mySql 2nd Generation database on google cloud. I am able to access it from my PC, add/remove tables etc after I add my IP address (from whatismy ip search on google) in the authorized IP address list. But my IP address keeps changing everyday and I have to keep updating the IP address. 

I read that it is possible to fix this by creating a proxy in the Google Compute Engine. With my inexperience I could not follow the instructions on the google website.

Can someone help me to create a proxy on Google Compute engine, so that my PC gets authorized even if the IP address changes? 

Thank you very much..

--
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/cbfa8fd1-e429-4e31-afb3-7b662ef45e9a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: 2nd Gen sql failover replica was promoted but won't run backups

Could you send your project and instance name to cloud-sql@google.com? We can investigate on the backend.

On Tuesday, April 19, 2016 at 6:44:25 AM UTC-7, Kurt Josep wrote:

I promoted a failover replica 2 weeks ago and have it set up to have backups and a binary log so that I can create read replicas and failover replicas but it isn't running backups during the backup window...  am I missing something in the documentation about how failover replicas even if promoted will never function as "masters" or do they have a bug in how they handle the failover promotion process that didn't properly provision this new db and okay it for backups to run?  

--
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/e3bf243d-fc4b-411e-a13e-b15f7de48b2f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] 2nd Gen sql failover replica was promoted but won't run backups

I promoted a failover replica 2 weeks ago and have it set up to have backups and a binary log so that I can create read replicas and failover replicas but it isn't running backups during the backup window...  am I missing something in the documentation about how failover replicas even if promoted will never function as "masters" or do they have a bug in how they handle the failover promotion process that didn't properly provision this new db and okay it for backups to run?  

--
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/e94c9ce2-d842-4dbc-9358-db9d8a3ab904%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How do I add proxy and authorization to access Cloud SQL db from my PC

That seems to be an excellent option and thank you for suggesting. That way I don't have to use the VM only for proxy. 

I will follow the steps mentioned and try to set it up.

Regards

On Monday, April 18, 2016 at 9:10:45 PM UTC+5:30, Kevin Malachowski wrote:

To be explicit: you can run the Cloud SQL Proxy directly from your PC. No need to use a Compute Engine VM! Please feel free to post back if you are having trouble setting up the Proxy, we'll be glad to help out.

In general, there are three major steps:

1) Download the proxy: on the page previously linked, you can download a precompiled version for your OS/CPU combination of your system.

2) Run the proxy: there are a few examples at the bottom of the page on how to start running the proxy

3) Connect to the proxy: depending on what flag options you passed to the proxy when starting it, you will need to configure your application (mysql command line, for example) to connect via TCP or UNIX socket.

If you have gcloud installed and have run `gcloud auth login`, the latest version of the proxy will just use those credentials when accessing Cloud SQL Databases.

On Sunday, April 17, 2016 at 11:38:22 AM UTC-7, Kamran (Google Cloud Support) wrote:

Hello Babu,

You can use Cloud SQL Proxy. The Cloud SQL Proxy is useful when connecting from clients with dynamic IP addresses. Please visit this article for more information about Google Cloud SQL Proxy and installation instructions. However, please note that this is a Beta release.

Sincerely,

Kamran

On Sunday, April 17, 2016 at 1:26:03 AM UTC-4, Babu wrote:

Hello,

I am a newbee on cloud sql - please help me. 

I have created a mySql 2nd Generation database on google cloud. I am able to access it from my PC, add/remove tables etc after I add my IP address (from whatismy ip search on google) in the authorized IP address list. But my IP address keeps changing everyday and I have to keep updating the IP address. 

I read that it is possible to fix this by creating a proxy in the Google Compute Engine. With my inexperience I could not follow the instructions on the google website.

Can someone help me to create a proxy on Google Compute engine, so that my PC gets authorized even if the IP address changes? 

Thank you very much..

--
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/5d054f30-4af0-44ca-926f-35bad919944b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How do I add proxy and authorization to access Cloud SQL db from my PC

To be explicit: you can run the Cloud SQL Proxy directly from your PC. No need to use a Compute Engine VM! Please feel free to post back if you are having trouble setting up the Proxy, we'll be glad to help out.

In general, there are three major steps:

1) Download the proxy: on the page previously linked, you can download a precompiled version for your OS/CPU combination of your system.

2) Run the proxy: there are a few examples at the bottom of the page on how to start running the proxy

3) Connect to the proxy: depending on what flag options you passed to the proxy when starting it, you will need to configure your application (mysql command line, for example) to connect via TCP or UNIX socket.

If you have gcloud installed and have run `gcloud auth login`, the latest version of the proxy will just use those credentials when accessing Cloud SQL Databases.

On Sunday, April 17, 2016 at 11:38:22 AM UTC-7, Kamran (Google Cloud Support) wrote:

Hello Babu,

You can use Cloud SQL Proxy. The Cloud SQL Proxy is useful when connecting from clients with dynamic IP addresses. Please visit this article for more information about Google Cloud SQL Proxy and installation instructions. However, please note that this is a Beta release.

Sincerely,

Kamran

On Sunday, April 17, 2016 at 1:26:03 AM UTC-4, Babu wrote:

Hello,

I am a newbee on cloud sql - please help me. 

I have created a mySql 2nd Generation database on google cloud. I am able to access it from my PC, add/remove tables etc after I add my IP address (from whatismy ip search on google) in the authorized IP address list. But my IP address keeps changing everyday and I have to keep updating the IP address. 

I read that it is possible to fix this by creating a proxy in the Google Compute Engine. With my inexperience I could not follow the instructions on the google website.

Can someone help me to create a proxy on Google Compute engine, so that my PC gets authorized even if the IP address changes? 

Thank you very much..

--
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/25a45138-05a9-4c4f-a16e-0f0f8275cf6d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: How do I add proxy and authorization to access Cloud SQL db from my PC

Hello Babu,

You can use Cloud SQL Proxy. The Cloud SQL Proxy is useful when connecting from clients with dynamic IP addresses. Please visit this article for more information about Google Cloud SQL Proxy and installation instructions. However, please note that this is a Beta release.

Sincerely,

Kamran

On Sunday, April 17, 2016 at 1:26:03 AM UTC-4, Babu wrote:

Hello,

I am a newbee on cloud sql - please help me. 

I have created a mySql 2nd Generation database on google cloud. I am able to access it from my PC, add/remove tables etc after I add my IP address (from whatismy ip search on google) in the authorized IP address list. But my IP address keeps changing everyday and I have to keep updating the IP address. 

I read that it is possible to fix this by creating a proxy in the Google Compute Engine. With my inexperience I could not follow the instructions on the google website.

Can someone help me to create a proxy on Google Compute engine, so that my PC gets authorized even if the IP address changes? 

Thank you very much..

--
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/bc75a3e6-7bbd-4a12-905c-08de015f6376%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] How do I add proxy and authorization to access Cloud SQL db from my PC

Hello,

I am a newbee on cloud sql - please help me. 

I have created a mySql 2nd Generation database on google cloud. I am able to access it from my PC, add/remove tables etc after I add my IP address (from whatismy ip search on google) in the authorized IP address list. But my IP address keeps changing everyday and I have to keep updating the IP address. 

I read that it is possible to fix this by creating a proxy in the Google Compute Engine. With my inexperience I could not follow the instructions on the google website.

Can someone help me to create a proxy on Google Compute engine, so that my PC gets authorized even if the IP address changes? 

Thank you very much..

--
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/91635fdb-25c3-49f2-b474-fe11e269fb7f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Error 2003 (HY000): can't connect to MySQL server on ' ' (10060)

To be clear, this issue will only be affecting first generation instances.

On Thu, Apr 14, 2016 at 10:51 AM, David Newgas <dnewgas@google.com> wrote:

I have updated the dashboard with some more information (although it may take a while for you to see it due to caching)

On Thu, Apr 14, 2016 at 10:12 AM, David Newgas <dnewgas@google.com> wrote:

Hi,

We are having some networking issues for a small number of instances. We have a small FYI on http://status.cloud.google.com/ which I'm hoping to update with more information shortly. We're working on resolving the issue now. For now try connecting from a GCE instance (including cloud shell) or using a GCE instance to proxy connections from your laptop.

Yours,

David

On Thu, Apr 14, 2016 at 2:55 AM, Kelly Ingram <kelly@cloudle.com.au> wrote:

I have a Google Cloud SQL Instance that I have been using for some time now and connecting successfully from MySQL Workbench. However as of yesterday I can't connect using MySQL Workbench (or the command line on my laptop) and get the error:

ERROR 2003 (HY000): Can't connect to MySQL server on '207.xxx.xxx.xx' (10060)

I have done the following already:

• Authorised my laptop's IP address (found using whatismyip.com) in the Google Console.
  
• Assigned an IPv4 address to the database in the Google Console.
  
• Created new users and passwords to see if it was a user issue. But that didn't help.
  
• Restarted the instance, restarted my home network/laptop and got new IP addresses (and updated the authorised IP address accordingly).
  
• Upgraded to the latest MySQL workbench 6.3 CE but still have the issue.
  

The database works as my app can connect to it and accesses the data, I just can't get a remote connection from my laptop.

Someone else is having a similar problem with their Django project (https://github.com/GoogleCloudPlatform/appengine-django-skeleton/issues/16)

I am new to this and am out of ideas on how to fix it. Any help would be greatly appreciated.

This communication together with any attachments transmitted with it ("this email") is intended only for the use of the addressee and may contain information which is privileged and confidential. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient you are hereby notified that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited.  If you have received this email in error please notify us immediately by email at admin@cloudle.com.au  Please then immediately delete, erase or otherwise destroy this email and any copies of it.  Addressees should check this email for viruses. Cloudle Pty Ltd makes no representations as regards to the absence of viruses in this email.

Any opinions expressed in this email are those of the author and do not necessarily constitute the views of Cloudle Pty Ltd. Nothing in this email shall bind the Company in any contract or obligation.

--
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/921e23e4-0715-41ea-87b9-2f7a6980bf09%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_bZ3Q_o0BCCkye5zObnmy7sWWnTCAXSADFuXBNzj2trdfg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Error 2003 (HY000): can't connect to MySQL server on ' ' (10060)

I have updated the dashboard with some more information (although it may take a while for you to see it due to caching)

On Thu, Apr 14, 2016 at 10:12 AM, David Newgas <dnewgas@google.com> wrote:

Hi,

We are having some networking issues for a small number of instances. We have a small FYI on http://status.cloud.google.com/ which I'm hoping to update with more information shortly. We're working on resolving the issue now. For now try connecting from a GCE instance (including cloud shell) or using a GCE instance to proxy connections from your laptop.

Yours,

David

On Thu, Apr 14, 2016 at 2:55 AM, Kelly Ingram <kelly@cloudle.com.au> wrote:

I have a Google Cloud SQL Instance that I have been using for some time now and connecting successfully from MySQL Workbench. However as of yesterday I can't connect using MySQL Workbench (or the command line on my laptop) and get the error:

ERROR 2003 (HY000): Can't connect to MySQL server on '207.xxx.xxx.xx' (10060)

I have done the following already:

• Authorised my laptop's IP address (found using whatismyip.com) in the Google Console.
  
• Assigned an IPv4 address to the database in the Google Console.
  
• Created new users and passwords to see if it was a user issue. But that didn't help.
  
• Restarted the instance, restarted my home network/laptop and got new IP addresses (and updated the authorised IP address accordingly).
  
• Upgraded to the latest MySQL workbench 6.3 CE but still have the issue.
  

The database works as my app can connect to it and accesses the data, I just can't get a remote connection from my laptop.

Someone else is having a similar problem with their Django project (https://github.com/GoogleCloudPlatform/appengine-django-skeleton/issues/16)

I am new to this and am out of ideas on how to fix it. Any help would be greatly appreciated.

This communication together with any attachments transmitted with it ("this email") is intended only for the use of the addressee and may contain information which is privileged and confidential. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient you are hereby notified that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited.  If you have received this email in error please notify us immediately by email at admin@cloudle.com.au  Please then immediately delete, erase or otherwise destroy this email and any copies of it.  Addressees should check this email for viruses. Cloudle Pty Ltd makes no representations as regards to the absence of viruses in this email.

Any opinions expressed in this email are those of the author and do not necessarily constitute the views of Cloudle Pty Ltd. Nothing in this email shall bind the Company in any contract or obligation.

--
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/921e23e4-0715-41ea-87b9-2f7a6980bf09%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_bbU4iO6vu-DSS4c6wZZ23_fGzLP2CzC98Wh2GBwV%2Bnp7g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-cloud-sql-discuss] Error 2003 (HY000): can't connect to MySQL server on ' ' (10060)

Hi,

We are having some networking issues for a small number of instances. We have a small FYI on http://status.cloud.google.com/ which I'm hoping to update with more information shortly. We're working on resolving the issue now. For now try connecting from a GCE instance (including cloud shell) or using a GCE instance to proxy connections from your laptop.

Yours,

David

On Thu, Apr 14, 2016 at 2:55 AM, Kelly Ingram <kelly@cloudle.com.au> wrote:

I have a Google Cloud SQL Instance that I have been using for some time now and connecting successfully from MySQL Workbench. However as of yesterday I can't connect using MySQL Workbench (or the command line on my laptop) and get the error:

ERROR 2003 (HY000): Can't connect to MySQL server on '207.xxx.xxx.xx' (10060)

I have done the following already:

• Authorised my laptop's IP address (found using whatismyip.com) in the Google Console.
  
• Assigned an IPv4 address to the database in the Google Console.
  
• Created new users and passwords to see if it was a user issue. But that didn't help.
  
• Restarted the instance, restarted my home network/laptop and got new IP addresses (and updated the authorised IP address accordingly).
  
• Upgraded to the latest MySQL workbench 6.3 CE but still have the issue.
  

The database works as my app can connect to it and accesses the data, I just can't get a remote connection from my laptop.

Someone else is having a similar problem with their Django project (https://github.com/GoogleCloudPlatform/appengine-django-skeleton/issues/16)

I am new to this and am out of ideas on how to fix it. Any help would be greatly appreciated.

This communication together with any attachments transmitted with it ("this email") is intended only for the use of the addressee and may contain information which is privileged and confidential. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient you are hereby notified that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited.  If you have received this email in error please notify us immediately by email at admin@cloudle.com.au  Please then immediately delete, erase or otherwise destroy this email and any copies of it.  Addressees should check this email for viruses. Cloudle Pty Ltd makes no representations as regards to the absence of viruses in this email.

Any opinions expressed in this email are those of the author and do not necessarily constitute the views of Cloudle Pty Ltd. Nothing in this email shall bind the Company in any contract or obligation.

--
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/921e23e4-0715-41ea-87b9-2f7a6980bf09%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_bb%2BjCFaEoB2ZtPaphKpR-oW1bQoqTTH%3DThJq137ZiGxvw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Error 2003 (HY000): can't connect to MySQL server on ' ' (10060)

I have a Google Cloud SQL Instance that I have been using for some time now and connecting successfully from MySQL Workbench. However as of yesterday I can't connect using MySQL Workbench (or the command line on my laptop) and get the error:

ERROR 2003 (HY000): Can't connect to MySQL server on '207.xxx.xxx.xx' (10060)

I have done the following already:

• Authorised my laptop's IP address (found using whatismyip.com) in the Google Console.
  
• Assigned an IPv4 address to the database in the Google Console.
  
• Created new users and passwords to see if it was a user issue. But that didn't help.
  
• Restarted the instance, restarted my home network/laptop and got new IP addresses (and updated the authorised IP address accordingly).
  
• Upgraded to the latest MySQL workbench 6.3 CE but still have the issue.
  

The database works as my app can connect to it and accesses the data, I just can't get a remote connection from my laptop.

Someone else is having a similar problem with their Django project (https://github.com/GoogleCloudPlatform/appengine-django-skeleton/issues/16)

I am new to this and am out of ideas on how to fix it. Any help would be greatly appreciated.

This communication together with any attachments transmitted with it ("this email") is intended only for the use of the addressee and may contain information which is privileged and confidential. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient you are hereby notified that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited.  If you have received this email in error please notify us immediately by email at admin@cloudle.com.au  Please then immediately delete, erase or otherwise destroy this email and any copies of it.  Addressees should check this email for viruses. Cloudle Pty Ltd makes no representations as regards to the absence of viruses in this email.

Any opinions expressed in this email are those of the author and do not necessarily constitute the views of Cloudle Pty Ltd. Nothing in this email shall bind the Company in any contract or obligation.

--
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/921e23e4-0715-41ea-87b9-2f7a6980bf09%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-cloud-sql-discuss] Re: Long access time and SQL Rquest

Hey Yuval,

How are you measuring this time? It's possible that it includes network latency time? Is it possible you could determine the IP address of the instance and run mtr from your server / development environment to that instance, to see if network latency is a problem?

Regards,

Nick
Cloud Platform Community Support

On Friday, April 8, 2016 at 5:42:19 PM UTC-4, Yuval Yohai wrote:

Hello,

In our system we get around 300ms access time for each SQL query.

We also get very long time to log-in to the server.

Has anyone encountered such long access time?

Is there a way to lower down?

Thaks,

Yuval

--
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/89164df9-b923-4ed3-8321-407e53da4d2e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.