News for hackers. Stuff that matters.
Re:SQL: 2023 Has Been Released by jahewson on Thursday June 01, 2023 @05:00PM (#36157255)
Why shard when you can just replicate?
Re:SQL: 2023 Has Been Released by lmm on Thursday June 01, 2023 @05:37PM (#36157707)
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?
Re:SQL: 2023 Has Been Released by lmm on Thursday June 01, 2023 @07:00PM (#36158615)
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.