You may be able to use H2, but it would require testing it with the load that you're
expecting. You may also need to do some tuning to make it work properly as at least there
used to be issues around concurrency.
End of the day MySQL or PostgreSQL are a lot more mature databases so you are much less
likely to encounter bugs or concurrency/load issues.
----- Original Message -----
From: "Kamal Jagadevan" <j.kamal(a)ymail.com>
Sent: Tuesday, 22 July, 2014 5:03:47 PM
Subject: [keycloak-user] Using H2 database in PROD
Are there any Strong reasons/recommendation for moving Keycloak backend from
H2 database to a different database?
I noticed this in the Reference guide "....you might want to use a better
relational database for Keycloak like PostgreSQL"...
Our application is on-premise solution and wouldn't involve with
substantially large number of users.
Please advise if we can go with Keycloak & H2 database for production.
keycloak-user mailing list