Scaling MySQL Server for Handling High Volume Requests in a Multitenant Application
0
votes
0
answers
40
views
I am currently working on developing a multi-tenant application where I have implemented a backend that identifies the tenant from the header and connects to the appropriate database.
However, I encountered an issue when attempting to create multiple databases and sending requests to the MySQL server. I consistently received an error indicating "too many connections."
I am seeking guidance on how to configure my MySQL server to handle a large number of requests, as my backend receives a significant influx of requests simultaneously. The high volume of database creation and simultaneous requests ultimately leads to a crash of my SQL server.
Asked by maher s
Jun 26, 2023, 06:13 AM
Last activity: Jun 27, 2023, 10:13 PM
Last activity: Jun 27, 2023, 10:13 PM