Overview
Amazon RDS allows users to create multiple databases within a single database instance. And connections to each of these databases are shared across the DB instance. This setup can become a bottleneck when the number of connections per DB instance is limited. This article explains how you can achieve scalability in this environment. It presents the method I used for scaling, explores alternative approaches, and discusses their pros and cons.
The Problem with Shared DB Connections Across Databases
Amazon RDS hosts multiple databases within a single instance, and there are a limited number of connections shared amongst all these