adiom-data / dsync

Database synchronization tool
https://adiom.io
GNU Affero General Public License v3.0
5 stars 1 forks source link

Full data integrity check draft #75

Open isapego opened 1 month ago

isapego commented 1 month ago

The main idea: We scan over all the documents, hashing them, multiplying hashes (order-independent check, xor can be used as an alternative) and then using the same logic as in basic verification to combine the resulting hashes with the respecting namespaces and get the final hash.

The cons of this approach -- it takes the same amount of time as the reading of the whole DB. There are different ways that we could use to improve the performance (e.g. hashing on the server side using js functions), but this approach is not universal and should be tested across different DBMS separately. Probably, an optimization, that can be implemented in the future.

The code is a draft, which means: