Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a situation in which we need to have two separate databases, DB1 has X number of tables and DB2 has 4 tables in which 3 of them must be synced with DB1, so that no matter we update these 3 tables from DB1 or DB2 it synced with each other. fourth table would be specific to DB2 only.

share|improve this question

closed as off topic by thinice, voretaq7 Nov 10 '12 at 22:01

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

This would really be a better question for Database Administrators, but I believe the answer Alex gave you is what you need... – voretaq7 Nov 10 '12 at 22:01

You should use a replicate-ignore-table configuration option.

share|improve this answer

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