this post was submitted on 12 Aug 2024
551 points (96.8% liked)

Comic Strips

11972 readers
2715 users here now

Comic Strips is a community for those who love comic stories.

The rules are simple:

Web of links

founded 1 year ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] jmcs@discuss.tchncs.de 11 points 1 month ago (7 children)

And infinitely lower reliability because you can't have failovers (well you can, but people that run everything in the same host, won't). It's fine for something non critical, but I wouldn't do it with anything that pays the bills.

[–] tias@discuss.tchncs.de 24 points 1 month ago* (last edited 1 month ago) (5 children)

I work for a company that has operated like this for 20 years. The system goes down sometimes, but we can fix it in less than an hour. At worst the users get a longer coffee break.

A single click in the software can often generate 500 SQL queries, so if you go from 0.05 ms to 1 ms latency you add half a second to clicks in the UI and that would piss our users off.

Definitely not saying this is the best way to operate at all times. But SQL has a huge problem with false dependencies between queries and API:s that make it very difficult to pipeline queries, so my experience has been that I/O-bound applications easily become extremely sensitive to latency.

[–] Katana314@lemmy.world 6 points 4 weeks ago (2 children)

I’m going to guess quite a people here work on businesses where “sometimes breaks, but fixed in less than an hour” isn’t good enough for reliability.

[–] count_dongulus@lemmy.world 0 points 4 weeks ago* (last edited 4 weeks ago) (1 children)

Yeah if you need even 99.9% uptime, the most downtime you can accept in a year is eight hours.

[–] trxxruraxvr@lemmy.world 3 points 4 weeks ago

Most businesses dont require that kind of uptime though. If i killed or servers for a couple of hours between 02:00 and 04:00 every night probably nobody would notice for at least a year if it wasn't for the alerts we'd get.

load more comments (2 replies)
load more comments (3 replies)