Global Database
Hi, I'd like to create a URL shortener. I figured I needed a global database with at least 3 points of presence: Europe, Asia, and America.
Except that I hesitate on which solution to choose. I'm open to all ideas. Initially, I was planning to go to MongoDB Atlas. But it's much too expensive (it's just a learning project). I was thinking of using Apache Cassandra, but I never used it.
I don't know which solution is the simplest to maintain, and which one will be the most adapted. Because there will be many more read requests than write requests.
You can use AWS dynamodb global table if you want to use a NoSQL solution, or aws Aurora global database for sql.
+1 for DynamoDB global tables (although you probably don't need this feature from the outset). It's usage-based pricing which is pennies for small workloads. Just read up on it first, specifically how you should design for it and it's quite different to what people are used to.
Until you have many users you don't need multi region at all. Just use a simple RDS Postgres.
Dont have real experience there, but you could check on cockroach db
Don't think about scaling when what you have is just an idea.
Work on your product first then all these challenges will be addressed as you grow. At the moment you are trying to solve a nonexistent problem.
Just do top level decisions like NoSQL or RDS, choose one, select a vendor or if you have a bare metal just install whatever database you want and deep dive into coding.
On what basis did you use to say MongoDB atlas is expensive? I make at least $100 a month and have never paid anything.
Thanks for the advice!
I think I'll go with a MongoDB installation on a VPS, that's good enough for me.
The free Atlas plan is cool. But I wanted to say that when you want to move up in the range and no longer go through the free plan, it's too expensive for me. I don't know the performance of the base plan.
This comment was deleted 5 years ago