Configuring a database
Keycloak relies on a single database to store all its data. Even when running multiple instances of Keycloak, all of them will be talking to the same database. A database is crucial for the overall performance, availability, scalability, reliability, and integrity of Keycloak. Although Keycloak provides a caching layer to avoid database hits as much as possible, a performant database will help to make the system behave better when data needs to be loaded from the database.
In this topic, you are going to configure a PostgreSQL database. The same steps should work for any other database you choose. By default, Keycloak is configured with a very simple file-based H2 database that should not be used in production, by any means. Instead, you should configure a more robust database such as the following:
- MariaDB
- MariaDB Galera
- MySQL
- Oracle
- Microsoft SQL Server
- PostgreSQL
Make sure to check the documentation available...
