Backend
Optimizing Geo-replicated Deterministic Databases
arXiv cs.DB0 views
arXiv:2611.05882v1 Announce Type: new Abstract: In transactional databases, achieving active-active replication among geo-distributed replicas is challenging due to the high coordination cost in ensuring the serializability of concurrent cross-node transactions. Deterministic concurrency control (DCC) has emerged as a promising alternative: it establishes a global order for a batch of transactions before execution and thereby amortizes this coordination cost across the batch. To better understand the performance characteristics of DCC, we conduct a theoretical analysis of traditional two-phase locking and optimistic concurrency control to account for geo-replication and introduce a model for DCC. We compare the three paradigms and identify the conditions under which DCC is advantageous. Guided by the insights from this analysis, we then present Quirinus, a DCC-based geo-replicated database that optimizes transaction execution through speculative execution, transaction reordering, integration of conflict-free replicated data types (CRDTs), and fast-path commit. Even without these optimizations, Quirinus achieves up to 6.2x the TPC-C throughput of Tiga under our configuration.
Source:https://arxiv.org/abs/2611.05882PreviousWhiel: A Neurosymbolic Platform for Certified Relational Program VerificationNextWhen Is One Query per Template Enough? Adapting Learned Cost Models to New Hardware
Related posts

Shopify Analytics Explained: How to Read Your Store Reports
0dev.to Beginners
How many calories do you burn a day? The Mifflin-St Jeor formula with a worked example
0dev.to Beginners
Integrate Error Tracking in Node.js with a Backend API — Quiet Course Imports
0dev.to Node
Cloud Storage for Node.js-Based User Avatar Uploads: Backup Retention Rules
0dev.to Node
Amoxi: What a durable agent run costs, measured
0dev.to Node
AI Image Retention in Node.js: Presigned Uploads and Trust Boundaries
0dev.to Node