How to Efficiently Choose the Right Database for Your Applications

Re:How to Efficiently Choose the Right Database for Your App... by skunkworker on Sunday February 28, 2021 @01:52AM (#26291220)

There are some tools that make horizontal sharding much easier, like Vitess which is MySQL only. But most businesses won't come close to needing these kinds of capabilities.

I would say for anyone starting out and worrying about how large a single node can scale, Postgres can run well on aa 64/128core server, 2TB ram and 20TB ZRAID6 with a chain of read replicas. This can be done out of the box on Postgres without much issue and can get many businesses quite far, but once you go to the lots and lots of TB, or you have specific write latency, consistency, or other requirements, you have to evaluate multiple databases against your company's specific usage patterns and data, as no benchmark will give you a good idea.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by samlambert on Sunday February 28, 2021 @11:01AM (#26294250)

Vertical scaling and scaling out via replicas is only excusable in a world where sharding isn't a solved problem.

With a bunch of read replicas you have to deal with eventual consistency when you get replication lag as well as the inability to scale writes.

If you shard out horizontally you get write scaleability, and read scalability with much less chance of replication delay. You like likely be reading from the master node most of the time. You also gain a bunch of operational flexibility, and smaller failure domains.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by gher-shyu3i on Monday March 01, 2021 @11:56AM (#26304834)

Don't you still have replication delay when sharding horizontally?

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by mtVessel on Sunday February 28, 2021 @12:56PM (#26295312)

How does horizontal sharding help with HA/DR concerns?

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by rzzzt on Sunday February 28, 2021 @06:06AM (#26292476)

Multi-master replication was also a MySQL-only functionality that came built in, while on Postgres you had to pick a third-party solution (I think...)? Did that change in recent times?

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by pezezin on Tuesday March 02, 2021 @06:37AM (#26314196)

I have been looking for how to set up multi-master replication, and as far as I know you still need a third-party solution.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by avinassh on Monday March 01, 2021 @12:37AM (#26300041)

> There are some tools that make horizontal sharding much easier, like Vitess which is MySQL only.

I am just curious, how does Vitess do that?

[ Parent | on HN ]