Home > Software engineering >  Should two identical databases, one acting as the single source of truth, be forced to have the same
Should two identical databases, one acting as the single source of truth, be forced to have the same

Time:12-08

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

https://www.pgpool.net/docs/42/en/html/example-cluster.html

  • Related