I have two databases with virtually identical records, one acting as the single source of truth. The single source of truth regularly updates the other database so that they match.
I am wondering if the timestamps of each identical record should be forced to be the same between databases, or if I should allow each database to manage its own timestamps independently?
Are there any long-term pros or cons to identical timestamps, perhaps under the context of running helpful queries to maintain data integrity and uniformity should they get out of sync?
I am new to distributed systems, so thanks in advance for your patience and help.
CodePudding user response:
@Danyolo - I suggest you take a look at MongoDB replicasets. MongoDB has a really neat replication system to ensure high availability and resiliency. Check out this link:
https://docs.mongodb.com/manual/core/replica-set-architecture-geographically-distributed/
CodePudding user response:
Try to install DB Postgresql PGPOOL