AWDS Lambda RDS Connection

We are trying to add an AWS X ray JSBC interceptor to our lambda functions, and to add a JDBC interceptor we added a Tomcat JDBC data source with maximum active and maximum idle connection as 1. Connections are not reused, and we get a lot of “already closed error connection” . Another picture that we observed is that Lambda takes almost 10 minutes to clear the connection from the Aurora DB. Has anyone successfully implemented pooling with Lambda (Java 8) and RDS (Aurora).

+4
source share
1 answer

I had some recent success with the latest transitions from MariaDB Connector-J and aurora. I had no problems with any requests, but with my jdbcurl likejdbc:mariadb:aurora://host:port/db?...

See https://mariadb.com/kb/en/the-mariadb-library/failover-and-high-availability-with-mariadb-connector-j/#specifics-for-amazon-aurora

I am still working on the connection pool without errors, but I am running random DEBUG from HikariCP o TransientConnectionErroror the MariaDB-J connector withNullPointerException

0
source

Source: https://habr.com/ru/post/1679403/


All Articles