News for hackers. Stuff that matters.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Thursday January 30, 2025 @12:18PM (#42879850)
Fun read. I am a bit curious on not mentioning OLAP, at all?

From my experience, the vast majority of complications in systems is people not realizing they are asking an OLAP question while wanting parts of OLTP semantics.

I'm also curious how much of this extra complication comes from having a central database that tries to be a source of truth for everything? As an easy example, inventory systems that try and have a cloud source of truth have obvious problems when on the ground inventory issues crop up. That is, a lot of the complication is between the distributed nature of the application and database, sure. But, another large source is the non-distributed abstraction that a central database can represent not centralized activity.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by mamcx on Thursday January 30, 2025 @01:48PM (#42880803)
> I'm also curious how much of this extra complication comes from having a central database that tries to be a source of truth for everything?

You can reverse this as 'how much extra complication comes from having many disparate databases, so now you push all ACID complications at the company level instead of the software(rdbms)'

It is a tricky problem!

Having a single source of truth is a tremendous simplification, especially for the people.

It should be ideal that the other databases are pure materializations on top of it, but then not matter what you have the need to input more stuff that is not part of the central one, and now you have both problems.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by nyrikki on Thursday January 30, 2025 @02:38PM (#42881348)
Single source of truth is different in distributed systems, well the costs are different.

Using the language of 'software architecture: thee hard parts' this forces your entire system into a single 'architectural quanta', basically it is a monolith.

There are situations where monoliths are acceptable or even the least worst option.

The 'Fallacies of distributed computing' covers most of these.

It can work better if you use a hierarchical model, but OLTP is almost exclusively the relational model.

ACID transactions become pretty brittle, software becomes set in stone etc...

There are use cases, but the value proposition is typically much weaker

Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Thursday January 30, 2025 @01:59PM (#42880908)
A single source of truth for facts is fine. A single source of truth that has to be reflected by external reality? Less fine. At that point, you pretty much have to have reconciliation processes to account for when they don't match.

Oddly, I'd argue that the better way to view this is that the central database is the materialization of the data sources scattered around where work actually happens. As such, you have to have constructs that account for provenance and timing introduced there that aren't as necessary at the edges.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by honestSysAdmin on Thursday January 30, 2025 @12:48PM (#42880140)
> From my experience, the vast majority of complications in systems is people not realizing they are asking an OLAP question while wanting parts of OLTP semantics.

If you could elaborate on this further, I and others are probably very interested in reading more about it.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Thursday January 30, 2025 @01:32PM (#42880657)
As the sibling says, it is easy to think about in terms of what you are doing with the data. Reporting on how many transactions of a type have happened over a duration? Probably OLAP. Really, if the word "report" shows up, at all, probably OLAP. Executing parts of a workflow for an active transaction? OLTP.

Briefly looking, I can't find the books that I thought covered a lot of this in a good way. Will keep looking, apologies.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by datadrivenangel on Thursday January 30, 2025 @01:33PM (#42880668)
Designing Data Intensive Applications is a very good book in this space.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by bobnamob on Friday January 31, 2025 @01:44AM (#42885186)
Designing Data Intensive Applications by Martin Kleppmann is required reading if you're in this space.

I can't recommend it highly enough.

[1] https://www.amazon.com/Designing-Data-Intensive-Applications...

Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Friday January 31, 2025 @12:07PM (#42889417)
Indeed, I upvoted that response to me, but I should have said as much. This is the book I couldn't remember the name of for the life of me. Really good book.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by juancn on Thursday January 30, 2025 @01:17PM (#42880480)
The main data access difference between OLAP systems and OLTP systems is how many records on average do you need to access:

- OLAP: most queries need most records (aggregations span large swaths of data)

- OLTP: most queries access just a few records

Also, in OLAP, in many cases, you can live with a single-updater model without much trouble, where OLTP, the strength is to have many concurrent updaters (but mostly non-overlapping).

Re:Scalable OLTP in the Cloud: What's the Big Deal? by greggyb on Thursday January 30, 2025 @04:11PM (#42882233)
- OLAP: read-mostly, table-scan heavy, many queries run ad-hoc by users

- OLTP: write-mostly, index-seek heavy, ~all queries pre-defined up front

Re:Scalable OLTP in the Cloud: What's the Big Deal? by hobs on Thursday January 30, 2025 @02:18PM (#42881133)
OLAP - Most queries need an aggregate of records. Generally you do NOT need most records, but simply the records grouped by dimensions per interval (for almost all olap reporting). You do not change the data, you observe it. If you change it, you are not dealing with OLAP data.

OLTP - You are dealing with the ins and outs of people using stuff to do things. You buy something, you check out something, you some way perturb the state of things. This should not require large amount of row lookups in 99.9% of cases.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by yoda97 on Thursday January 30, 2025 @05:14PM (#42882702)
So the first focuses on analytics and reporting, the second on transactions and performance. They are not meant to replace each other, they serve different purposes. Some teams may need both.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by guru4consulting on Friday January 31, 2025 @02:56PM (#42891214)
Apart from the above differences, another important difference is that OLAP is often columnar based, as opposed to the typical OLTP being row-based. So, OLAP queries use different kinds of index. Snowflake has introduced Hybrid tables where the same data is stored and indexed twice, once in OLAP columnar type and the other in OLTP style row index.
Re:Scalable OLTP in the Cloud: What's the Big Deal? by datadrivenangel on Thursday January 30, 2025 @01:32PM (#42880661)
I agree that analytical queries cause a significant portion of the complication in transactional systems.

However, at global/twitter scale, just basic CRUD operations become pretty hard for OLTP, so scalable OLTP in the cloud is a pretty big deal, especially when you get fun things like phantom read/writes as writes may take time to get to distributed read replicas, so a user may send a tweet and then not see it on their profile for a while.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Thursday January 30, 2025 @02:02PM (#42880933)
I mean, sure? I hesitate to take the global/twitter scale debates seriously, unfortunately. They are dominated by straw men arguments that you can get sub 50ms latency on every action for all viewers. :(
Re:Scalable OLTP in the Cloud: What's the Big Deal? by tharkun__ on Thursday January 30, 2025 @05:36PM (#42882867)
You can't and it shouldn't matter and I don't care if everyone sees my upvotes on Reddit right away / at the same time as others or if I see theirs or when exactly my comments show up.

But global/twitter/reddit etc. scale does matter in that I don't really remember a PHPBB or slashdot or HN swallowing my comments, ever. Even if you get an error you can always just go back in the browser and your input box is there with your comment.

But reddit has been effing atrocious over the last few months. You get "Internal Server Error" when trying to do any voting or commenting a lot and it won't go away until you refresh the page like 17 times (until presumably you round robin get to some BE server that actually works. It's also been swallowing comments, where about every third or fourth comment it accepts the comment instead of throwing an Internal Server Error at you (which would be preferable) and instead it "accepts" it but it will never show up. Ever. Only chance is to copy every comment before submitting, in case you have to re-submit it from scratch.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by taeric on Thursday January 30, 2025 @05:40PM (#42882902)
Exactly on that first statement.

I think I agree across the board. HN and Stack Overflow are both amusing examples of much simpler architectures that kind of get to the point, though? Such that I'm not clear if we are on the same page, there.

(And I, sadly, have zero experience with Reddit.)

Re:Scalable OLTP in the Cloud: What's the Big Deal? by lmm on Thursday January 30, 2025 @11:36PM (#42884730)
> don't really remember a PHPBB or slashdot or HN swallowing my comments, ever.

Really? I remember it happening a lot.

> Even if you get an error you can always just go back in the browser and your input box is there with your comment.

That's a relatively new feature and doesn't always work. (Old, I can't speak to new) Reddit's "push a button and it submits without moving off the page" is much nicer.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by tharkun__ on Friday January 31, 2025 @06:05PM (#42893445)
New reddit. Same submit without moving off the page. It's great if there is an actual error returned from their BE. You can try again etc.

The problematic case is that very often now it accepts your comment without any errors and... Then nothing. Your comment will never ever show up. The system swallowed it. Whole. Without chewing.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by lmm on Monday February 03, 2025 @12:24AM (#42915246)
> The problematic case is that very often now it accepts your comment without any errors and... Then nothing. Your comment will never ever show up. The system swallowed it. Whole. Without chewing.

Huh. I've never seen that. Does it not show on your user page even? I've known it to take a few seconds for comments to show up, and mods on certain subs love to silently delete comments (sometimes automatically), but I've never seen them just disappear.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by tharkun__ on Thursday February 06, 2025 @07:28PM (#42967959)
Not the thread, not the user page. Nowhere. Just gone.

I do also have the case where it disappears but a refresh / going to the user page will show it, i.e. something async on their end was just a few milliseconds too slow or something.

And posting the exact same comment again (I c+p them now) works. So it wouldn't be any automatic removals and it's too fast for manual removals.

Re:Scalable OLTP in the Cloud: What's the Big Deal? by zo1 on Friday January 31, 2025 @01:08AM (#42885079)
You can tell a lot about Reddit and it's early "architecture" from this video.

https://www.infoq.com/presentations/reddit-architecture-evol...

That and the Instagram architecture video are such eye-opening examples that I always send to juniors when they have doubts about their own abilities. In most cases, we're astronomically no where near Reddit/Twitter/Instagram scale, and yet we avoid a lot of the common pitfalls we see presented in those videos. Side note, I'm shocked at the quality, but hey "Time To Market!"

The Instagram video: https://www.youtube.com/watch?v=hnpzNAPiC0E

Re:Scalable OLTP in the Cloud: What's the Big Deal? by tharkun__ on Friday January 31, 2025 @06:23PM (#42893631)
Haha yeah.

I had the same eye opening experience when I first "met" Jira. I was pretty fresh out of uni myself, yet I knew you should never use a business key that people might want to change and always use surrogate keys for your database.

And here is Jira "happily" using Issue Key as both the business key that signifies which project an issue belongs to, which can very obviously change as soon as you move a ticket to another project and as the primary key in their database and thus for everything related to an issue like say issue links.

I was laughing so hard that you couldn't tell I was also crying and cursing at the same time coz I had to deal with that fact.

They've since introduced ids for things but ... duuuudes! WTF! lol