Re:Denormalization for Performance: Don't Blame the Relation...
by CaptainZapp on Wednesday October 19, 2016 @08:56AM
(#12743298)
But for other problems such as distributed databases, you can't do joins across 2 geographically separated data centers
That's where replication comes in as your (arguably) most powerful weapon.
I work with databases for, literally, decades and have never seen a successful implementation of two-phase-commits or joins on geographically distinct entities.
I work with databases for, literally, decades and have never seen a successful implementation of two-phase-commits or joins on geographically distinct entities.