What is the best denormalization practice in CQRS?

Question

I am trying to create a deamon to denormalize my database.

I use ActiveMQ as a queue manager. I have 2 databases: relational (write + replication) and denormalized (for reading)

My question is what is the best practice for denormalizing my real DB I have some ideas:

• MySQL proxy (with lua) that reads the queue (this is possible)
• Trigger in MySQL
• Java daemon as a service that reads a queue
• Cron tab? (but I will have a big delay time

Answer 1

, "" , Event Sourcing , . per se, ( , )

, Eventing ( Ruby) https://eventide-project.org/.

CQRS : http://lucisferre.net/2010/11/04/a-brief-introduction-to-cqrs/

, , , , . "write" , - , . , , .

, , .

, SQL, . , , . http://www.udidahan.com/?blog=true