Abstract
Information is one of the most important assets of an organization. Therefore, database management systems need to ensure that this information is adequately safeguarded. Moreover, non-functional characteristics such as availability, performance, and security become critical during the use and management of a database. Therefore, to assure such capabilities, database management systems implement high availability and fault-tolerance systems. However, most times these solutions have high costs with privative licenses and specific implementation requirements. This paper presents a method to address server replication and failover by using open source utilities available in the Linux operating system. We accomplish such goals through the implementation of synchronous and asynchronous techniques which use the activity logs provided by the database management system. Finally, in order to demonstrate the feasibility of this proposal, it has been carried out a proof of concept implementation with Oracle databases deployed on a Linux operating system, in which the high-availability issue is solved successfully through dual back up with synchronous and asynchronous methods.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Mukherjee N, Chavan S, Colgan M, Gleeson M, He X, Holloway A, Kamp J, Kulkarni K, Lahiri T, Loaiza J, Macnaughton N, Mullick A, Muthulingam S, Raja V, Rungta R (2016) Fault-tolerant real-time analytics with distributed oracle database in-memory. In: 2016 IEEE 32nd international conference on data engineering (ICDE), pp 1298–1309
Wu X, Wang K, Su Z, Liu Y (2012) Research and implementation of the high-availability spatial database based on oracle. In: 2012 international conference on computer science and service system, pp 1713–1716
Yu K, Gao Y, Zhang P, Qiu M (2015) Design and architecture of dell acceleration appliances for database (DAAD): a practical approach with high availability guaranteed. In: 2015 IEEE 17th international conference on high performance computing and communications, 2015 IEEE 7th international symposium on cyberspace safety and security, and 2015 IEEE 12th international conference on embedded software and systems, pp 430–435
Amirishetty AK, Li Y, Yurek T, Girkar M, Chan W, Ivey G, Panteleenko V, Wong K (2017) Improving predictable shared-disk clusters performance for database clouds. In: 2017 IEEE 33rd international conference on data engineering (ICDE), pp 237–242
Wong L, Arora NS, Gao L, Hoang T, Wu J (2009) Oracle streams: a high performance implementation for near real time asynchronous replication. In: IEEE 25th international conference on data engineering, 2009. ICDE 2009. IEEE, pp 1363–1374
Somani AK, Vaidya NH (1997) Understanding fault tolerance and reliability. Computer 30(4):45–50
Kreutz D, Ramos F, Verissimo P (2013) Towards secure and dependable software defined networks. In: Proceedings of the second ACM SIGCOMM workshop on hot topics in software defined networking. ACM, pp 55–60
Proskurin S, McMeekin D, Karduck AP (2012) Smart camp building scalable and highly available it-infrastructures. In: 2012 6th IEEE international conference on digital ecosystems and technologies (DEST), pp 1–6
Jaiswal C, Kumar V (2015) DBHAaaS: Database high availability as a service. In: 2015 11th international conference on signal-image technology internet-based systems (SITIS), pp 725–732
Ping Y, Hong-Wei H, Nan Z (2014) Design and implementation of a MySQL database backup and recovery system. In: Proceedings of the 11th world congress on intelligent control and automation, pp 5410–5415
Agrawal D, El Abbadi A, Salem K (2015) A taxonomy of partitioned replicated cloud-based database systems. IEEE Data Eng. Bull. 38(1):4–9
Kemme B, Alonso G (1998) A suite of database replication protocols based on group communication primitives. In: Proceedings. 18th international conference on distributed computing systems 1998. IEEE, pp 156–163
Moiz SA, Sailaja P, Venkataswamy G, Pal SN (2011) Database replication: a survey of open source and commercial tools. Database 13(6)
Ray A (2002) Oracle data guard: ensuring disaster recovery for the enterprise. An Oracle white paper
Meeks J (2009) An oracle technical white paper-oracle data guard with oracle database 11g release 2. Oracle
Chaurasiya V, Dhyani P, Munot S (2007) Linux highly available (HA) fault-tolerant servers. In: 10th international conference on information technology (ICIT 2007). IEEE, pp 223–226
Litchfield D (2007) Oracle forensics part 1: Dissecting the redo logs. NGSSoftware Insight Security Research (NISR), Next Generation Security Software Ltd, Sutton
Candea G, Cutler J, Fox A, Doshi R, Garg P, Gowda R (2002) Reducing recovery time in a small recursively restartable system. In: Proceedings international conference on dependable systems and networks, pp 605–614
Tridgell A, Mackerras P et al (1996) The RSync Algorithm
Acknowledgment
This research was supported by the vice-rectorate of investigations of the Universidad del Azuay. We thank our colleagues from Laboratorio de Investigación y Desarrollo en Informática (LIDI) de la Universidad del Azuay who provided insight and expertise that greatly assisted this research.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Cordero, M.O., Cordero, G.O., Martinez, E.C. (2019). An Open Source Synchronous and Asynchronous Approach for Database Replication. In: Botto-Tobar, M., Barba-Maggi, L., González-Huerta, J., Villacrés-Cevallos, P., S. Gómez, O., Uvidia-Fassler, M. (eds) Information and Communication Technologies of Ecuador (TIC.EC). TICEC 2018. Advances in Intelligent Systems and Computing, vol 884. Springer, Cham. https://doi.org/10.1007/978-3-030-02828-2_4
Download citation
DOI: https://doi.org/10.1007/978-3-030-02828-2_4
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-02827-5
Online ISBN: 978-3-030-02828-2
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)