'How to fix too many connections error SQLAlchemy MySQL and FastAPI

I'm developing an API using FastAPI with gunicorn for the production side. For the database part, I'm using SQLalchemy with MySQL. The application will crash if more than 100 users try to get an endpoint (due to connection limits with the DB). Does anyone know how I can develop an API that can handle hundreds (even thousands) of requests and do DB queries efficiently?

mysqlapisqlalchemygunicornfastapi


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions