Jepsen Disputes MongoDB's Data Consistency Claims

Re:Jepsen Disputes MongoDB's Data Consistency Claims by wdb on Saturday May 23, 2020 @05:23PM (#23286593)

I really enjoy using PostgreSQL only I just don't know how to make it scale easily. Running it on large VM in the cloud works fine until you have lots of data or need it easily accessible. How can you have the data in three different regions (e.g. Europe, US, Asia) when you using something like Google Cloud? Seems to be a hard problem to crack.

[ Parent | on HN ]

Re:Jepsen Disputes MongoDB's Data Consistency Claims by jatone on Monday May 25, 2020 @09:27AM (#23300812)

generally speaking the only reason that would be difficult would be due to legal constraints on the data locality.

if it was just performance than read only replica's in each region would solve most of the issues.

for the legal case generally I just end up with a separate postgresql DB in each region and during login the region is determined by user/company.

usually ends up being like 1k LOCs total.

[ Parent | on HN ]

Re:Jepsen Disputes MongoDB's Data Consistency Claims by mateuszf on Sunday May 24, 2020 @02:28PM (#23293483)

Try with Aurora Postgres Global Database, it's on AWS, but should be accessible from other clouds.

[ Parent | on HN ]