Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

12
  • 7
    You might want to read about the CAP theorem. This says you can only pick two of Consistency Avaliability and Partition Tolerance. This makes ensuring consistency in a distributed system difficult, if not impossible. Commented Sep 20, 2023 at 13:59
  • 1
    Why do you have things strewn across multiple DBs? Why not move to a single DB (perhaps with multiple read replicas)? Commented Sep 20, 2023 at 14:01
  • 9
    There are entire research papers focused on this topic. This topic is not one that can be easily answered in a stackoverflow question. There are books written about this (TLDR: most of them conclude that this is a very, very difficult task and only provide strategies to mitigate the problem, not completely solve it) Commented Sep 20, 2023 at 22:52
  • 1
    @guillaume31 I've made some additions to my question which hopefully make clearer what I'm asking for. Commented Sep 21, 2023 at 8:31
  • 3
    @slebetman you say "There are entire research papers focused on this topic", but you don't give us one example. Same thing about "books". Can you list some of them, or, at least, give us a way to how find it? Commented Sep 21, 2023 at 10:35