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
Photo to Rap Video: How the Pipeline Works (Lip-Sync, Beat Alignment, and the Pitfalls)
0dev.to Machine Learning
Schedule an Email and Recall a Sent Message in Outlook: How Each Works
0dev.to Tutorial
Deploy a plain ERC-20 without writing Solidity — and know which fields you can never change
0dev.to Tutorial
How to Get YouTube Video Stats With Python and the YouTube Data API
0dev.to Tutorial
Why Explaining Your Boundaries Always Backfires (The J.A.D.E. Trap)
0dev.to Career
WARN Act and Trade Adjustment Assistance — the Help That Expired, and What's Left
0dev.to Career