Keycloak 20.0.3 and mariadb galera

[Jean-Yves DE BUE]

Hello.

For a project, I'm using keycloak with galera cluster (mariadb 10.5) .

A first launched, I had issues because of mising primary keys.

"This table type requires a primary key [Failed SQL: (1173) CREATE TABLE gv_keycloak.DATABASECHANGELOG..."

I found a workaround by using innodb_force_primary_key=0 in my mariadb config file.

I don't understant why primary keys are not used.

I could also create primary keys but changing datamodel is not safe and could impact keycloak updates.

Some of you already had this issue ?.

Is keycloak really safe to work with galera ?.

Regards,

Jean-Yves