I have a database that contains orders , products ..etc. I have another system that generates reports based on this database. Due to heavy load i want to separate those systems Where i have the master database for products .. and a slave database for the reporting system.
Whats the best approach to build this given that :
- I dont care about real time data . Syncing will be done once a day.
- I might have a different schema for the slave database.