4 ms·
Yes, if multi-masters change the same rows of same table, it would cause conflict. Consensus protocol like raft, has limitation: it requires low delay among th
by jinhualuo 7y ago
Yes, if multi-masters change the same rows of same table, it would cause conflict.
Consensus protocol like raft, has limitation: it requires low delay among the nodes, so normally, it would be deployed in the same data-center. Moreover, if all changes (conflict or not), handled by consensus protocol, the performance would be bad. In fact, data-centers are normally loose coupling (the application normally choose the same data-center as the data source/target). So data-centers just need somehow light-weighted conflict resolution.
pgcat lww, just like Cassandra, provides counter column concept, which is used to retain each change among data-centers, and simple aggregation helper function there. pgcat lww is done by pg trigger, so if you need customization of your business, you could modify the trigger function to fit it.