[keycloak-user] Galera Replication and Caching

[Jared Blashka]

We've got synchronous replication enabled. I've looked in the DB tables for
both galera nodes and the data is there. e.g. both DB nodes have client
'myclient' but the UI for Keycloak node 2 doesn't list a 'myclient'. But
Keycloak will error if you try to add 'myclient' saying it already exists.

On Wed, Oct 12, 2016 at 4:42 PM, Marek Posolda <mposolda at redhat.com> wrote:

> Then it's probably related to the Galera cluster rather then to caching...
>
> Do you have DB configured with synchronous replication (eg. inserting some
> record on DB1 is successfully finished after the record is successfully
> replicated to DB2 too) ?
>
> You can maybe compare with the configuration in my docker image
> https://github.com/mposolda/keycloak-mariadb . I can't recall to see any
> issue like this, but not sure about other aspects of my configuration
> (performance etc).
>
> Marek
>
>
> On 12/10/16 19:08, Jared Blashka wrote:
>
> We're already running 1.9.8.Final. Our previous configuration was using 2
> clustered nodes configured against the same DB node and we didn't run into
> this issue.
>
> On Wed, Oct 12, 2016 at 2:45 AM, Marek Posolda <mposolda at redhat.com>
> wrote:
>
>> Which Keycloak version are you using? If it's older than 1.9.8.Final,
>> then it's suggested to upgrade as there were caching fixes meanwhile.
>>
>> There is also possibility to disable caching in keycloak-server.json (or
>> in standalone.xml in latest version). It's mentioned in the docs how to
>> do it.
>>
>> Finally it may also help if you have opportunity to try with 2 Keycloak
>> cluster nodes configured against same DB node. This may help to better
>> isolate the problem and see if it's related to caching or to MariaDB
>> cluster.
>>
>> Marek
>>
>> On 10/10/16 22:31, Josh Cain wrote:
>> > Hi all,
>> >
>> > We're running into a problem with a couple of MariaDB instances +
>> > Galera.  When I go to add a client on the first Keycloak node/DB (we'll
>> > call it DB01), it add successfully.  I can then go to the second
>> > Keycloak Node/DB (call this one DB02) and do not see the client on the
>> > 'clients' list.  However, if I were to add the same client on DB02, I
>> > get the expected 'client with ID already exists' message.  What's more,
>> > if I bounce the Keycloak node that talks to DB02, the client list
>> > populates with the new entry added at DB01.
>> >
>> > Was guessing it's some kind of caching issue - is there a setting where
>> > I can alter this behavior?
>> >
>>
>> _______________________________________________
>> keycloak-user mailing list
>> keycloak-user at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/keycloak-user
>>
>
>
>