1

I 'd like to get an answer to this question guiding our actions:

Do we have a fundamental rule that the slave db must be identically same with master db on both count of columns and the orders?

We are using Tungsten replicators connecting a master and slave db. But we recently have a special requirement that we considering adding one more columns only to slave db ( at the 1st position ). Thus we would get a different table structure in slave db compared to master db on the same table.

We would like to know if this is workable solution. Thanks Martin

Martin Zang
  • 105
  • 2
  • 6

1 Answers1

0

Yes, It should be same. Master and Slave replication run by forwarding the queries. If any insert , update, delete (DML) queries is run on Master database server, Master forward that query to slave server. If the slave don't have same schema (table name , column name) it crash the requested query from master and ultimately it crash the replication. If you want to change table name on slave just to select data you can use views. Hope this helps.

Faizan Younus
  • 793
  • 1
  • 8
  • 13
  • I guess that depends on how you replicate and what filters you are using. For example the drop-column filter lets you remove columns http://docs.continuent.com/tungsten-replicator-5.1/filters-reference-dropcolumn.html. And if you extract change data capture then you can be flexible with what you remove or add. The only constrain is that the table must have a primary key. – Jan Zeiseweis Oct 12 '17 at 11:44