Should I write to MySQL slave (replica) for reporting?
0
votes
3
answers
710
views
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,
Asked by Kevin
(101 rep)
Jun 3, 2017, 05:27 AM
Last activity: Dec 30, 2024, 06:03 AM
Last activity: Dec 30, 2024, 06:03 AM