Answer the question
In order to leave comments, you need to log in
Why is Google App Engine limited to 100 concurrent connections from a single server to a MySQL instance?
That page says "Each App Engine instance running in a standard environment cannot have more than 100 concurrent connections to an instance". What is the reason for this limitation and how to get around it?
Each MySQL instance of my project stores exactly 10,000 users. The system distributes users by their ID. That is: if the user ID is 17 829, then information about it will be stored in the second instance. If the ID is 44 925, then in the fifth and so on.
If we assume that at the same time 400 requests for information about the profiles of users whose ID is less than 10,000 came to the same PHP server, then an error will be generated due to the limitation mentioned above. If this is true, how can this limitation be circumvented? I've thought about creating multiple read replicas and just spreading requests, but that's not cost effective.
Thanks to
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question