Microservices and data consistency: but how do we do for real?
There has been a lot of hype around microservices. They offer many advantages for implementing DevOps best practices and having autonomous multidisciplinary teams work in parallel.
There has been a lot of hype around microservices. They offer many advantages for implementing DevOps best practices and having autonomous multidisciplinary teams work in parallel.
Let's take a look how CDC(Change Data Capture) can be done with triggers and message queuing service built directly in the Oracle Database and how easy it is to integrate it with MicroProfile Reactive Messaging. We will create Always free instance of Oracle Database in Oracle Cloud(OCI), setup simple data capture with triggers and build in queuing and consume the data with MicroProfile Reactive Messaging AQ connector in Helidon.
Good to know:
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.