Guidance Required: Recommended Databases and Configuration for Session Store in UAA (v78.0.2)

We are using UAA version 78.0.2 with session data managed via SPRING_SESSION. Our current database is MySQL Aurora Serverless v2, and we have observed issues with table-level locks when deleting expired sessions. This is causing disruptions in the login flow and resulting in failed user authentication attempts.

Request for Guidance:

1. Database Recommendations:

• Which databases are best suited for storing session data to prevent locking issues and support high concurrency during login operations?

2. Session Store Configuration Best Practices:

• What are the recommended best practices for configuring the session store in UAA to ensure optimized performance and reliable session management?

3. Mitigation of Locking/Blocking Issues:

• Any specific strategies or configurations you recommend to resolve the current locking and blocking issues, particularly SPRING_SESSION

Thanks

The issue concerns UAA 78.0.2 session data in SPRING_SESSION on MySQL Aurora Serverless v2, but it names no files, tests, or entry points. Start by investigating the session-store configuration and the reported table-lock behavior; done would be documented database recommendations, configuration practices, and mitigation guidance for reliable login flows.