Configure JDBC pools as reader/writer with RDS

1

Hi!!!
I am in the process of moving our keycloak database from a simple self-managed ec2 instance to an RDS cluster on AWS and was wondering if there is a way to configure keycloak to use both the read and write endpoints of an RDS cluster and send queries to both nodes.

I have seen some information on the postgres jdbc driver website (Connecting to the Database) indicating that you can create more than one pool to split queries, but I don’t know if keycloak supports this type of configuration or how to properly apply it in keycloak.

1 Like
2

Hello were you able to get this working. I am trying to do something similar but the cluster endpoint that I have configured does not route reads to reader and writes to writer. So I see scope creation going to the reader and that is causing failures