Submit your papersSubmit Now
For Enquiries: [email protected]
IIARD LogoIIARD

A Study on the Impact of Data Replication Strategies on Performance in Distributed Database System

Egboson Famvie, Kizzy Nkem Elliot, Anasuodei Bemoifie Moko, Biobele Okardi

Abstract

Data replication is a fundamental mechanism in distributed database systems, supporting fault tolerance, availability, and reliable data access across networked nodes. Cockroach DB is a cloud- native, open-source distributed SQL database that relies on replication and consensus protocols to maintain consistency and resilience in clustered environments. This study investigates the performance implications of synchronous and asynchronous replication strategies within a CockroachDB-based distributed system. A simulation-driven experimental framework is employed to evaluate system behavior under controlled conditions. Key performance metrics including transaction latency, throughput, read and write response times, and replication delay are measured while maintaining consistent cluster topology and configuration parameters. The results show that synchronous replication enforces strong consistency by requiring coordinated acknowledgements from replicas before transaction commitment, but this approach incurs higher coordination overhead, leading to increased latency and reduced throughput. Conversely, asynchronous replication improves write responsiveness and overall throughput by decoupling transaction commits from replica synchronization, although it introduces temporary inconsistencies due to replication lag. The findings highlight the inherent trade-off between consistency and performance in distributed database systems. This study provides practical guidance for selecting appropriate replication strategies based on workload characteristics and application consistency requirements, contributing empirical insight to the configuration and optimization of modern distributed data platforms.

Keywords

Distributed DatabasesData Replication StrategiesCockroach DBSynchronous. Asynchronous ReplicationPerformance EvaluationConsistency and Throughput

References

Abadi, D. J. (2012). Consistency tradeoffs in modern distributed database system design: CAP is only part of the story. Computer, 45(2), 37–42. https://doi.org/10.1109/MC.2012.33 Abadi, D. J. (2018). The design and implementation of modern column-oriented database systems. Foundations and Trends® in Databases, 5(3), 197–280. Bernstein, P. A., & Newcomer, E. (2009). Principles of Transaction Processing (2nd ed.). Morgan Kaufmann. Bernstein, P. A., Hadzilacos, V., & Goodman, N. (1987). Concurrency Control and Recovery in Database Systems. Addison-Wesley. Brewer, E. A. (2000). Towards robust distributed systems. Proceedings of the 19th Annual ACM Symposium on Principles of Distributed Computing . Brewer, E. A. (2012). CAP twelve years later: How the “rules” have changed. Computer, 45(2), 23–29. https://doi.org/10.1109/MC.2012.37 Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. Gilbert, S., & Lynch, N. (2002). Brewer’s conjecture and the feasibility of consistent, available, partition-tolerant web services. ACM SIGACT News, 33(2), 51–59. Gray, J., Helland, P., O’Neil, P., & Shasha, D. (1996). The dangers of replication and a solution. Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, 173–182. Howard, H., Mortier, R., Rotsos, C., et al. (2015). Raft refloated: Do we have consensus? ACM SIGOPS Operating Systems Review, 49(1), 12–21. Jain, R. (1991). The Art of Computer Systems Performance Analysis. Wiley. Kleppmann, M. (2017). Designing Data-Intensive Applications. O’Reilly Media. Lamport, L. (1998). The part-time parliament. ACM Transactions on Computer Systems, 16(2), 133–169. Lamport, L. (2001). Paxos made simple. ACM SIGACT News, 32(4), 18–25. Ongaro, D., & Ousterhout, J. (2014). In search of an understandable consensus algorithm . Proceedings of the 2014 USENIX Annual Technical Conference, 305–319. Özsu, M. T., & Valduriez, P. (2016). Principles of Distributed Database Systems (4th ed.). Springer. Özsu, M. T., & Valduriez, P. (2020). Principles of Distributed Database Systems (5th ed.). Springer. Pavlo, A., et al. (2017). Self-driving database management systems. CIDR 2017. Saito, Y., & Shapiro, M. (2005). Optimistic replication. ACM Computing Surveys, 37(1), 42–81. Schroeder, B., Harchol-Balter, M., et al. (2016). Fast databases with fast durability and recovery through multicore parallelism. USENIX ATC. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill. Stonebraker, M., et al. (2018). The case for ACID transactions. CIDR 2007 (revisited). Taft, R., et al. (2020). CockroachDB: The resilient geo-distributed SQL database. Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data, 1493–1509. Tanenbaum, A. S., & Van Steen, M. (2017). Distributed Systems: Principles and Paradigms (3rd ed.). Pearson. Vogels, W. (2009). Eventually consistent. Communications of the ACM, 52(1), 40–44.

More Articles from INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND MATHEMATICAL THEORY

Advances in Algorithmic Contract Scoring for Pre-Negotiation Yield Optimization and Risk Retention

Author: Ngozi Samuel Uzougbo, Michael Ominyi, Cyril Chimelie Anichukwueze, Blessing, Chika Jones

DevTest flow: Designing a Scalable Continuous Testing Pipeline for High-Velocity Software Delivery

Author: Lawal Ahmed Oladimeji, Achori Busayo, Akeju BusayoZainab, Saka Samson, Damilare, Mbah Demian Chidi, Runsewe Similoluwa Mayowa, Oladiti Luqman, Abiodun