Automated dump and import

+1  

We can run a query in each table to dump data that is newer than the last date we checked

YAML 想法

select * from table where version > lastUpdate

This would get all the records that have been updated since t he last update.

We could then import this data.

I don't know what to do about data that already exists, we would have to generate update record sql commands.

Whenever data is changed, update the lastUpdate field so that the next dump will cover that row.

chronological,


(別通知) (可選) 請,登錄

多主複製的複雜性不僅僅在於查找其他副本站點中的新增功能。我們可以使在一個節點上創建的數據只能通過與該節點進行交互來進行編輯,但是所有由每個節點創建的數據都將複製到所有其他節點。

The complexity of Multi-Master replication does not stop at looking up what's been new in other replica sites. We could make the data that was created on one node only editable via interacting with that node, but all created by every node replicated to all other nodes.