Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 :

  1. I dont care about real time data . Syncing will be done once a day.
  2. I might have a different schema for the slave database.
share|improve this question
    
for same database you will have different schema on slave ? –  Abdul Manaf May 15 '13 at 12:07
    
I only need numbers in the slave database . I can sync the whole database but it'll be an overhead. –  iyad al aqel May 15 '13 at 12:11
    
what do you mean by numbers? –  Abdul Manaf May 15 '13 at 12:13
    
The simplest way to sync your database is to set master slave replication but in that your slave tables structure should be exact copy of master. –  Abdul Manaf May 15 '13 at 12:15
    
Please have a look at dev.mysql.com/doc/refman/5.1/en/replication.html this is what replication does. –  Abdul Manaf May 15 '13 at 12:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.