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
Clean Master Data Before UAE E-Invoicing
0dev.to
How Kubernetes and Docker Support Cloud Data Engineering
0dev.to
A crafted regex runs code on GitLab servers
0dev.to
Last-Mile ETA Drift: Recalculating Delivery Windows When Dwell Time and Failed Stops Break the Route Plan
0dev.to
Model-based estimation and imputation with torus missing values
0arXiv stat.CO
Theoretical guarantees for stochastic gradient sampling methods via Gaussian convolution inequalities
0arXiv stat.CO