4 ms·
Nobody said anything about multimaster. You keep a hot standby in a different availability zone and stream your transactions to it. Failover when needed. Unles
by vox_mollis 11y ago
Nobody said anything about multimaster. You keep a hot standby in a different availability zone and stream your transactions to it. Failover when needed.
Unless you're a bank, you run asynchronous with watchdog scripts and accept the very very small risk that you lose a few transactions within the ~100ms window of async latency.
It's all risk analysis. For most of us, hours of downtime is riskier than losing a tiny sliver of data for a small number of customers.
- nickpsecurity 11y agoThat's a proven approach going back decades. A number of banks do it, too, because it often works well enough in practice where data isn't lost. A trick on that is having something on each end that sort of checksums the data(base) for certain time periods to see if anything was lost. Then, resends that stuff. My use of that was inspired by the transport layer of the Tsunami file-transfer protocol with the implementation very similar, too. :)