I am trying to create a deamon to denormalize my Database.
I use ActiveMQ as queue manager I have 2 data bases: Relational one (write + replication), and denormalized one (for reads)
My question is what's the best practice to denormalize my real DB I have some ideas:
- MySQL proxy (with lua) which reads the Queue (is this possible)
- Trigger in MySQL
- Java daemon as a service which reads the Queue
- Cron tab ? (but I will have a big time of latency