Design and Evaluation of a 4-Way Oracle GoldenGate Replication Architecture for Hybrid Cloud Environments

Authors

  • Karuppusamy Gopalan, Tiruvenkadam Cuddalore Vardharajan, Eric K Lam

Keywords:

Oracle GoldenGate, Multi-Master Replication, Hybrid Cloud, Active-Active Replication, Data Integrity, High Availability, Conflict Resolution, Real-Time Data Streaming

Abstract

In the era of hybrid cloud adoption, enterprises face significant challenges in maintaining data consistency, high availability, and operational continuity across geographically dispersed and heterogeneous environments. This study presents a novel implementation of 4-way active-active Oracle GoldenGate replication across on-premises and multi-cloud platforms, enabling real-time data synchronization, conflict resolution, and automated failover mechanisms [1][2]. The architecture interconnects four nodes—two on-premises and two cloud-based (Azure)—to deliver seamless data replication with less lag, ensuring transactional integrity and zero-downtime operations for critical enterprise applications. Key innovations include the use of Oracle GoldenGate Microservices Architecture, integration with cloud-native services [5], and deployment of Conflict Detection and Resolution (CDR) techniques to handle bi-directional updates in a multi-master configuration [2][3]. Experimental evaluation demonstrates that the proposed system achieves high throughput, minimal replication lag, and robust failover capabilities under diverse workloads and simulated failure conditions [6][7]. The results validate the effectiveness of the 4-way replication strategy in supporting disaster recovery, data sovereignty compliance, and cross-region data access in a hybrid cloud setting. This work contributes to the field of cloud database management by offering a scalable and resilient model for enterprise-grade data replication, applicable to sectors demanding high availability such as healthcare, finance, and e-commerce.

Downloads

Download data is not yet available.

References

Oracle Corporation, “Oracle GoldenGate 19c Documentation,” Oracle Help Center, 2023. [Online]. Available: https://docs.oracle.com/en/middleware/goldengate/core/19.1/index.html

Oracle Corporation, “Using Conflict Detection and Resolution in Oracle GoldenGate,” Oracle Help Center, 2022. [Online]. Available: https://docs.oracle.com/en/middleware/goldengate/core/19.1/cdrua/index.html

M. F. Bari, M. Ghafoor, and S. A. Madani, “Multi-master database replication: Issues and approaches,” *International Journal of Computer Applications*, vol. 55, no. 14, pp. 1–7, Oct. 2012.

A. S. Tanenbaum and M. Van Steen, *Distributed Systems: Principles and Paradigms*, 2nd ed., Upper Saddle River, NJ: Prentice-Hall, 2007.

Microsoft Azure, “Azure ExpressRoute: Extend your on-premises networks into the Microsoft cloud,” Microsoft Documentation, 2023. [Online]. Available: https://learn.microsoft.com/en-us/azure/expressroute/

L. Qiu, V. N. Padmanabhan, and G. M. Voelker, “On the placement of web server replicas,” in *Proc. IEEE INFOCOM 2001*, Anchorage, AK, 2001, pp. 1587–1596.

M. S. Kumar and R. Ramachandran, “Performance and consistency in cloud-based distributed database systems,” *International Journal of Cloud Computing and Services Science*, vol. 4, no. 1, pp. 10–19, Jan. 2015.

Oracle Corporation, “Oracle GoldenGate Veridata: Data Comparison and Validation,” Oracle Documentation, 2022. [Online]. Available: https://www.oracle.com/middleware/technologies/goldengate-veridata.html

Y. Saito and M. Shapiro, “Optimistic replication,” *ACM Computing Surveys*, vol. 37, no. 1, pp. 42–81, Mar. 2005.

A. Adya et al., “Generalized isolation level definitions,” in *Proc. 16th IEEE Int’l Conf. Data Engineering (ICDE)*, San Diego, CA, USA, 2000, pp. 67–78.

Downloads

Published

19.04.2025

How to Cite

Karuppusamy Gopalan. (2025). Design and Evaluation of a 4-Way Oracle GoldenGate Replication Architecture for Hybrid Cloud Environments. International Journal of Intelligent Systems and Applications in Engineering, 13(1), 262 –. Retrieved from https://ijisae.org/index.php/IJISAE/article/view/7653

Issue

Vol. 13 No. 1 (2025)

Section

Research Article

License

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

All papers should be submitted electronically. All submitted manuscripts must be original work that is not under submission at another journal or under consideration for publication in another form, such as a monograph or chapter of a book. Authors of submitted papers are obligated not to submit their paper for publication elsewhere until an editorial decision is rendered on their submission. Further, authors of accepted papers are prohibited from publishing the results in other publications that appear before the paper is published in the Journal unless they receive approval for doing so from the Editor-In-Chief.

IJISAE open access articles are licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. This license lets the audience to give appropriate credit, provide a link to the license, and indicate if changes were made and if they remix, transform, or build upon the material, they must distribute contributions under the same license as the original.