0

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.

Rizwan Yahya
  • 111
  • 4
  • This would really be a better question for [dba.se], but I believe the answer Alex gave you is what you need... – voretaq7 Nov 10 '12 at 22:01

1 Answers1

1

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

Alex
  • 7,939
  • 6
  • 38
  • 52