Sample Header Ad - 728x90

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