Hi,
I want to use in the same keycloak, different datasource to store in
different database the eventsStore, realm and user data.
I configure 3 different mysql connections KeycloakDS, KeycloakLocal and
KeycloakRemote jndi source in standalone.xml for wildfly and it works
correctly.
In the keycloak-server.json there are this line for definition
"eventsStore": {
"provider": "jpa",
"jpa": {
"exclude-events": [ "REFRESH_TOKEN" ]
}
},
"realm": {
"provider": "jpa"
},
"user": {
"provider": "jpa"
},
and for connections
"connectionsJpa": {
"default": {
"dataSource": "java:jboss/datasources/KeycloakDS",
"databaseSchema": "update"
} ,
},
but how is possible specify a different connectionsJpa and use it for
realm,user and eventsStore ?
I try to modify the jpa connections declaration like this
"connectionsJpa": {
"default": {
"dataSource": "java:jboss/datasources/KeycloakDS",
"databaseSchema": "update"
} ,
"second": {
"dataSource": "java:jboss/datasources/KeycloakLocal",
"databaseSchema": "update"
},
"third": {
"dataSource": "java:jboss/datasources/KeycloakRemote",
"databaseSchema": "update"
}
},
and no errors appears but all data and table are created in KeycloakDS only.
How can I configure to use the second a jpa connection for "realm data"
and to use third jpa connection for "users data" ?
Thank you very much