Re:SQL: 2023 Has Been Released
by jahewson on Thursday June 01, 2023 @05:00PM
(#36157255)
Why shard when you can just replicate?
[ Parent
| on HN ]
Because replica failover is rarely seamless (and often doesn't actually work at all, IME).
Re:SQL: 2023 Has Been Released
by mikepurvis on Thursday June 01, 2023 @06:34PM
(#36158357)
Instinctively that's surprising... replica failover should be far simpler technically, shouldn't it?
No? Replication tends to be a bodged-on mess throughout, full of undertested edge cases, of which failover is definitely one. If you build the system so that nodes joining and leaving is a natural and normal part of operation, well, it naturally works a lot better.