News for hackers. Stuff that matters.
Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Thursday October 19, 2017 @06:57PM (#15512253)
what % of people have workload beyond something that PG on i3.16xlarge can handle?
Re:MongoDB shares jump more than 30% in $192M IPO by gaius on Friday October 20, 2017 @02:46AM (#15513938)
I always think this when people talk about scaling. You can buy off the shelf now boxes with 48 or 96 cores, 1-2T of RAM, internal bays for 10s of T of SSD or connect it to an AFA and get 100s of T. This is not even an exotic custom build system, just a commodity, and has been for years. Running a recent version of a conventional database on a box like this goes a very, very long way, with very little hassle because you don't even need to think about "sharding", and you can always add a hotstandby for offloading reads, or for redundancy in another DC, or whatever. Systems like this can quite happily bottleneck on the network before the database starts breaking a sweat.

Remember, sharding isn't scaling the database. Sharding is admitting your database can't scale so you're offloading the problem to another layer.

Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Friday October 20, 2017 @08:22AM (#15515171)
You can have 224 cores and 12TB RAM in a commodity Supermicro box.
Re:MongoDB shares jump more than 30% in $192M IPO by gaius on Friday October 20, 2017 @05:20PM (#15519181)
Indeed. You would need one helluva Postgres workload to overload that. Not one in a million people genuinely have that requirement.
Re:MongoDB shares jump more than 30% in $192M IPO by KallDrexx on Thursday October 19, 2017 @08:54PM (#15512800)
It's also about locality of your data. Having a global infrastructure means 150-200ms minimum latency per query if you have a system in India or Singapore with a database server in a US data center region. That adds up quick.
Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Thursday October 19, 2017 @09:41PM (#15512977)
That is orthogonal concern to what is being discussed if you run geo distributed Mongo cluster you will either have slow queries or will compromise on data integrity.
Re:MongoDB shares jump more than 30% in $192M IPO by KallDrexx on Friday October 20, 2017 @09:19AM (#15515503)
It's not orthogonal because it is harder to have master-master cross data center setups in relational databases even in scenarios where eventual consistency is acceptable (such as a use case for a piece of our infrastructure we have).

Sure MongoDB may not be the best fit for it but my point is more that these are scenarios where horizontal scaling is an important consideration makes more sense for some nosql solutions than for sql solutions. It's not just about single box performance.

Re:MongoDB shares jump more than 30% in $192M IPO by hendzen on Thursday October 19, 2017 @07:39PM (#15512466)
people who don't want to get woken up if Amazon decides to terminate said i3.16xlarge...
Re:MongoDB shares jump more than 30% in $192M IPO by qaq on Thursday October 19, 2017 @08:05PM (#15512595)
Not a fan of AWS or cloud in general but accepted that this the direction the world is going for now. The AWS instance type was purely for illustration purposes.
Re:MongoDB shares jump more than 30% in $192M IPO by jlarocco on Thursday October 19, 2017 @07:51PM (#15512528)
Missed the point completely...
Re:MongoDB shares jump more than 30% in $192M IPO by acdha on Thursday October 19, 2017 @08:20PM (#15512661)
I think you should reconsider that dismissal: everyone needs n > 1 instances for reliability while increasingly few tasks require more {CPU,RAM,IOPs} than a single server can provide. That means that a growing percentage of problems will require clustering for reliability more than performance, and that favors the easiest to manage since in most cases every option will be fast enough.
Re:MongoDB shares jump more than 30% in $192M IPO by gnaritas on Thursday October 19, 2017 @09:28PM (#15512944)
Horizontal scaling is often just as much about redundancy as it is scaling; no one server solution is a valid answer to a production application.