right now we have an issue that we would like to write in multi master topology that, in each office, we have a master DB and each office may write data to the same table in their office and finally data integrity must be keep.
this is really mulit master but in differnet locatoin and not in a cluster environmet, how can we do it?
hardware and software, please suggest.
the same table in each database on each location must have data integrity, no data can be destory.
1) Change table design by adding one more time stamp column so no matter what database vendor it is, we use the timestamp to make decision on which to keep ?
2) hardware applicatant ?
3) BIG data?