Split Read/Write DB transactions

[Lucas Ferreira]

Hi, 

Was taking a look at the docs and didn't see anything related to splitting read/write DB transactions. Today in our architecture we deploy database clusters with write and read replicas, and it would be awesome to make Keycloak use the read replicas for all read only transactions, and just use the write replicas if the transaction writes something to the DB.

Is there any implementation in Keycloak to do that, or has someone already done that?

Thanks,

Lucas Ferreira.

[Tatsiana Tupeka]

+1 here 

--
You received this message because you are subscribed to the Google Groups "Keycloak User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to keycloak-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/keycloak-user/a73b6c92-69f6-4733-be47-8cc58985622fn%40googlegroups.com.

[Schuster Sebastian (IOB/PAU1)]

In all configurations I have seen people enable event auditing so even read requests cause a write to the DB. Only pure read requests on the Admin API might not cause a write so I am not sure how useful that would be…

 

Mit freundlichen Grüßen / Best regards

Dr.-Ing. Sebastian Schuster

Product Area User Management (IOB/PAU1)
Bosch.IO GmbH | Ullsteinstr. 128 | 12109 Berlin | GERMANY | www.bosch.io
Tel. +49(30)726112-485 | Mobil +49(152)02177668 | Telefax +49(30)726112-100 | Sebastian...@bosch.io

Sitz: Berlin, Registergericht: Amtsgericht Charlottenburg; HRB 148411 B
Aufsichtsratsvorsitzender: Stefan Koss; Geschäftsführung: Dr. Andreas Nauerz, Yvonne Reckling 

To view this discussion on the web visit https://groups.google.com/d/msgid/keycloak-user/CAO3PqCuJMPWt8r6JnAGgw7bG7uSAE%3DU09ZeFoyOqqn-5coxaxQ%40mail.gmail.com.