I would use a replication mechanism like master-slave or multi-master replication to ensure that data is replicated across all nodes in the database. I would also use conflict resolution mechanisms to ensure that updates to the same data item are handled correctly.
