This afternoon I noticed a tweet refering to a new feature that AWS have announced that could simplify the management of database connections. Amazon RDS Proxy is currently in preview and only available for RDS MySQL and Aurora MySQL in a limited number of regions.
I believe that it will go some way towards solving two problems that I have encountered:
- Prevent reaching maximum connection limit of database.
- Reduce warm up time for lambdas that connect to a database.
I'll wait until some examples show up for Java before I decide whether this will work for the types of applications that I am used to developing.