[google-cloud-sql-discuss] Re: Queries related to Cloud SQL concurrent connections and requests

No Sandeep,
I am stuck in understanding the above mentioned three points If you can help.

On Wednesday, January 27, 2016 at 3:07:26 PM UTC+5:30, sande...@sruthika.net wrote:

Hi karthik,

Even my scenario is similar.I have users more than 10k!! what is the final solution??

On Wednesday, January 27, 2016 at 1:09:17 PM UTC+5:30, Kartik Domadiya wrote:

I need help in understanding few things related to Cloud SQL.

We have an app on App Engine using Datastore. Now we have requirement of using Cloud SQL with Datastore. The data is migrated from Datastore to Cloud SQL via cron jobs on Appengine.

I was just going through the below links to know the basic details related to performance and limitations.
https://cloud.google.com/sql/docs/diagnose-issues#data-issues
https://cloud.google.com/sql/pricing#v1-pricing
https://cloud.google.com/sql/faq#sizeqps

So for looks like First Generation Tier D0 - D1 will serve the purpose.

Few things which are confusing me:

a) What is Pending Connection and how does it affect ?

        Not sure if this throws 1033 Instance has too many concurrent requests, when it exceeds 100. How do we handle this ? Is it like we can create 250 connections but use only 100 at a time ?

b) 250 Concurrent Connections.

        Should throw error Too Many Connections if it exceeds 250

c) Per app engine instance 12 concurrent connections per SQL Instance. How do we ensure that no more than 12 connections per app engine instance ? 

    Have gone through 

            http://stackoverflow.com/questions/10424442/what-are-the-connection-limits-for-google-cloud-sql-from-app-engine-and-how-to

            http://stackoverflow.com/questions/10158805/whats-a-good-approach-to-managing-the-db-connection-in-a-google-cloud-sql-gae/10438622#10438622

    But people face certain issues in that.

d) We got OperationalError: (2013, "Lost connection to MySQL server at 'reading initial communication packet', system error: 38") error when     we tried a test with 1000+ requests concurrently.

We have 1500+ people(as of now and it will grow) using our system concurrently and looks like it will fail. So we are just confused if we can use Cloud SQL due to the above mentioned issues. But solutions should be available though. 

--
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/69c69102-86ac-43a9-a16d-a093ccf47abe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.