Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 professional 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

1 Answer 1

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.