3 ms·
> And yet some of the most popular OLTP databases in the world today are still highly dependent on a single node architecture. Which databases? SQLite is the o
by pbowyer 1y ago
> And yet some of the most popular OLTP databases in the world today are still highly dependent on a single node architecture.
Which databases? SQLite is the one I can think of, but it's designed for that use-case. Others start as single node but will replicate to other nodes, either as master-slave or master-master.
- redwood 1y agoPostgres, MySQL
- pbowyer 1y agoThey both have replication, which allows them to be multi-node.
- ViewTrick1002 1y agoWith the bounds capped by a single writer. Unless you can shard the data and create a distributed database with manual sharding. But yes. Postgres remains an amazing choice, especially with modern hardware, until you also have the money available to tackle said write throughput issue.
- sgt 1y agoI think the point is that sharding won't really help that much since transactions will happen across all or most shards, and then you have certain accounts that will be more active than others.
- samlambert 1y agoif your sharding schema is designed properly you will avoid cross shard transactions.
- sgt 1y agoHow so? Any account may transact with any other account - regardless which shard it resides in.
- big_hacker 1y agoTigerBeetle doesn't shard either.
- redwood 1y agoGood catch.
- jorangreef 1y agoYes, sharding would kill performance under contention, which characterizes many OLTP workloads (e.g. top ten bestseller list on Black Friday, super stocks like NVIDIA, the big 4 banks on a switch, PhonePe/Google Pay on UPI etc)
- menaerus 1y agoSharding is if anything a way to reduce the contention.
- jorangreef 1y agoTransactions typically need to hit the same set of house accounts. For example, fee accounts, omnibus accounts etc. Or a central bank switch may only have 4 major banks. Or a system like UPI may have 85% of transactions flowing through 2 hubs. Say 50% through PhonePe. And say 35% through Google Pay.
- pjmlp 1y agoI am quite sure Oracle and MS SQL server do just fine in multi-node cluster based architectures, but maybe that isn't their target audience.
- bob1029 1y agoMSSQL has a full-blown Death Star deployment option now: https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-architecture https://learn.microsoft.com/en-us/azure/azure-sql/database/h...
- lomase 1y agoThe HN crowd does not talk much about those, but every single place I have worked used them or Postgres.
- pjmlp 1y agoSame here, I happily ignored all the NoSQL movement, and little by little, they got all relevant features out of it.