Score:0

1 million concurrent database connections

il flag

In https://cloud.google.com/sql/docs/quotas, it mentioned that "Cloud Run services are limited to 100 connections to a Cloud SQL database.". Assume I deploy my service as Cloud Run, what's the right way to handle 1 million concurrent connections? Can cloud spanner enables this - I can't find documentation discussing maximum concurrent connections on cloud spanner maximum concurrent connection with Cloud Run.

vn flag
Any system that needs a million concurrent connections is a site that needs an entire team of experts that can set up and maintain it. That's megacorporation-sized stuff.
djdomi avatar
za flag
Does this answer your question? [Can you help me with my capacity planning?](https://serverfault.com/questions/384686/can-you-help-me-with-my-capacity-planning) and cee i agree i believe that a huga huge cluster would be required
Score:1
cn flag

When it comes to limits with Google Cloud Spanner, the official documentation points out the concurrent connections are limited up to 100 per session.

Value/Limit

Commit size (including indexes)/ 100 MB

Concurrent reads per session/ 100

Mutations per commit (including indexes)/ 20,000

Concurrent Partitioned DML statements per database/ 20,000

Configuring the number of sessions

In general, we do not recommend modifying the default number of sessions used by the client libraries. If you have a special workload, we recommend setting the lower bound to the number of expected concurrent transactions, and set the upper bound to an initial test number, such as 100. If the upper bound is not adequate, increase it. Increasing the number of active sessions uses additional resources on the Cloud Spanner database service, so failing to clean up unused sessions can degrade performance. We also recommend having no more than 100 sessions per gRPC channel.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.