S
S
SET12020-02-13 18:27:36
Google Cloud Platform
SET1, 2020-02-13 18:27:36

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

1 answer(s)
D
Dimonchik, 2020-02-13
@dimonchik2013

and here it’s already normal, figured it out?
Google Vision API. How to distribute the load?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question