Keep sync both read and write databases.

▪ Publishes an event that subscribe from Read Database and update the read table accordingly.

▪ Synchronization handles with async communication using message brokers.

▪ This creates Eventual Consistency principle.

▪ The Read database eventually synchronizes from the Write database.

▪ Some lag in the process due to async communication with message brokers that applies

publish/subscribe pattern.

▪ Welcome to Eventual consistency.

https://medium.com/airasia-com-tech-blog/cqrs-data-sync-using-pub-sub-dff4fb15b3d9