A Change-Data-Capture use-case: designing an evergreen cache

Track

Tehnologije & rješenja

Datum i vrijeme

utorak, 12. listopad 2021., 10:50

Dvorana

Dvorana A

Trajanje

45'

When one’s app is challenged with poor performances, it’s easy to set up a cache in front of one’s SQL database. It doesn’t fix the root cause (e.g. bad schema design, bad SQL query, etc.) but it gets the job done. If the app is the only component that writes to the underlying database, it’s a no-brainer to update the cache accordingly, so the cache is always up-to-date with the data in the database.Things start to go sour when the app is not the only component writing to the DB. Among other sources of writes, there are batches, other apps (shared databases exist unfortunately), etc. One might think about a couple of ways to keep data in sync i.e. polling the DB every now and then, DB triggers, etc. Unfortunately, they all have issues that make them unreliable and/or fragile.You might have read about Change-Data-Capture before. It’s been described by Martin Kleppmann as turning the database inside out: it means the DB can send change events (SELECT, DELETE and UPDATE) that one can register to. Just opposite to Event Sourcing that aggregates events to produce state, CDC is about getting events out of states. Once CDC is implemented, one can subscribe to its events and update the cache accordingly. However, CDC is quite in its early stage, and implementations are quite specific.In this talk, I’ll describe an easy-to-setup architecture that leverages CDC to have an evergreen cache.

Detalji o predavanju

Način održavanja: Osobno prisustvo
Vrsta: Predavanje
Razina težine: Srednje detaljno
Poželjna funkcija slušatelja: Razvojni inženjer ili softverski arhitekt , Voditelj tima ili projekta
Grupa aktivnosti: Tehnologije & rješenja

O predavaču

Organizatori

Konferenciju organiziraju Hrvatska udruga Oracle korisnika i Hrvatska udruga Java korisnika. 

Prati nas na Facebooku

Novosti, fotografije i zanimljivosti objavljujemo na službenoj Facebook stranici JavaCro konferencije.

Prati nas na Twitteru

Sve novosti i zanimljivosti vezane uz JavaCro objavljujemo i na Twitteru!

Zlatni pokrovitelj

Medijski pokrovitelji