0

I intent to put reporting/analytics database on slave and run job scheduler every night to aggregate and insert data from operational database to reporting database.

Should I do this or I have to setup dedicated server for reporting/analytics database and use some tools to aggregate and insert data from slave to reporting server?

Thank for help,

0

I would do the nightly aggregation into a Summary Table on the Master. This abides by the principle that the Master and Slave are always in sync (within a slight delay). It also allows for multiple slaves to share the read load.

2
  • My master node is quite busy so I set up a dedicated slave for reporting only and other slaves for other tasks. – Kevin Jun 3 '17 at 5:38
  • 1
    Should we discuss how to make the Master less busy? – Rick James Jun 3 '17 at 5:39
0

Depends upon the criticality of Master and your wallet. If reporting queries are bothering much to Master, you may add a slave to it. If your business grows then chances of reporting might require different indexes created on main data hence you might need to handle different backup policies for Master and Analytics slave.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.