views:

81

answers:

0

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