Skip to main content
SpringerLink
Log in

A Database-Specific Pattern for Multi-cloud High Availability and Disaster Recovery

  • Conference paper
  • First Online:
Advances in Service-Oriented and Cloud Computing (ESOCC 2015)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 567))

Included in the following conference series:

Abstract

High availability and disaster recovery (HADR) are often discussed in highly critical business systems for business function recovery and continuity concerns. With the development of cloud computing, virtual cloud services are perfectly matched to HADR scenarios, and interoperability is a significant aspect to help users to use HADR service across different cloud platforms and providers. In this paper, we present an architectural pattern describing the integration of high availability and disaster recovery. We focus on database cluster replication between private cloud and public cloud environments. This HADR pattern for database cluster replication implements both synchronous and asynchronous replication concurrently for high availability and disaster recovery purposes. To evaluate the effectiveness of this pattern, we simulate a MySQL-database-cluster HADR scenario under three strategies: hot standby, warm standby and cold standby, and analyze the performance, business continuity features and cost.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

References

  1. Benton, D.: Disaster recovery: a pragmatist’s viewpoint. Disaster Recovery J. 20(1), 79–81 (2007)

    Google Scholar 

  2. Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrency Control and Recovery in Database Systems. Addison-Wesley, New York (1987)

    Google Scholar 

  3. Buschmann, F., Meunier, R., Rohnert, H., Sommerlad, P., Stal, M., Sommerlad, P., Stal, M.: Pattern-Oriented Software Architecture: A System of Patterns, vol. 1. Wiley, New York (1996)

    Google Scholar 

  4. Creeger, M.: Cloud computing: an overview. ACM Queue 7(5), 2 (2009)

    Google Scholar 

  5. Cully, B., Lefebvre, G., Meyer, D., Feeley, M., Hutchinson, N., Warfield, A.: Remus: high availability via asynchronous virtual machine replication. In: Proceedings of the USENIX Symposium on Networked Systems Design and Implementation, pp. 161–174 (2008)

    Google Scholar 

  6. Fu, S.: Failure-aware resource management for high-availability computing clusters with distributed virtual machines. J. Parallel Distrib. Comput. 70(4), 384–393 (2010)

    Article  MATH  Google Scholar 

  7. Robinson, G., Narin, A., Elleman, C.: Using Amazon Web Services for disaster recovery. http://media.amazonwebservices.com/AWS_Disaster_Recovery.pdf. Accessed October 2014

  8. Gray, J., Siewiorek, D.P.: High-availability computer systems. Computer 24(9), 39–48 (1991)

    Article  Google Scholar 

  9. Jamshidi, P., Ahmad, A., Pahl, C.: Cloud migration research: a systematic review. IEEE Trans. Cloud Comput. 1(2), 142–157 (2013)

    Article  Google Scholar 

  10. Kandukuri, B.R., Paturi, V.R., Rakshit, A.: Cloud security issues. In: IEEE International Conference on Services Computing, SCC 2009, pp. 517–520 (2009)

    Google Scholar 

  11. King, R.P., Halim, N., Garcia-Molina, H., Polyzois, C.A.: Management of a remote backup copy for disaster recovery. ACM Trans. Database Syst. (TODS) 16(2), 338–368 (1991)

    Article  Google Scholar 

  12. Ladin, R., Liskov, B., Shrira, L., Ghemawat, S.: Providing high availability using lazy replication. ACM Trans. on Comput. Syst. (TOCS) 10(4), 360–391 (1992)

    Article  Google Scholar 

  13. Lewis, P.: A high-availability cluster for Linux. Linux J. 64 (1999)

    Google Scholar 

  14. Lumpp, T., Schneider, J., Holtz, J., Mueller, M., Lenz, N., Biazetti, A., Petersen, D.: From high availability and disaster recovery to business continuity solutions. IBM Syst. J. 47(4), 605–619 (2008)

    Article  Google Scholar 

  15. Microsoft: High availability and disaster recovery for SQL Server in Azure virtual machines (2014). http://msdn.microsoft.com/en-us/library/azure/jj870962.aspx. Accessed 12 June 2014

  16. MySQL: Replication with global transaction identifiers. http://dev.mysql.com/doc/refman/5.6/en/replication-gtids.html

  17. Openstack Wiki: Openstack disaster recovery solution. https://wiki.openstack.org/wiki/DisasterRecovery

  18. Openswan: Openswan official website. https://www.openswan.org/

  19. Pacitti, E., Özsu, M.T., Coulon, C.: Preventive multi-master replication in a cluster of autonomous databases. In: Kosch, H., Böszörményi, L., Hellwagner, H. (eds.) Euro-Par 2003. LNCS, vol. 2790, pp. 318–327. Springer, Heidelberg (2003)

    Chapter  Google Scholar 

  20. Pahl, C., Jamshidi, P.: Software architecture for the cloud – a roadmap towards control-theoretic, model-based cloud architecture. In: Weyns, D., Mirandola, R., Crnkovic, I. (eds.) ECSA 2015. LNCS, vol. 9278, pp. 212–220. Springer, Heidelberg (2015). doi:10.1007/978-3-319-23727-5_17

    Chapter  Google Scholar 

  21. Pahl, C., Xiong, H.: Migration to PaaS clouds - migration process and architectural concerns. In: IEEE International Symposium on the Maintenance and Evolution of Service-Oriented and Cloud-Based Systems (MESOCA 2013), pp. 86–91 (2013)

    Google Scholar 

  22. Pahl, C., Xiong, H., Walshe, R.: A comparison of on-premise to cloud migration approaches. In: Lau, K.-K., Lamersdorf, W., Pimentel, E. (eds.) ESOCC 2013. LNCS, vol. 8135, pp. 212–226. Springer, Heidelberg (2013)

    Chapter  Google Scholar 

  23. Rajagopalan, S., Cully, B., O’Connor, R., Warfield, A.: Secondsite: disaster tolerance as a service. In: ACM SIGPLAN Notices, vol. 47, pp. 97–108. ACM (2012)

    Google Scholar 

  24. Sapate, S., Ramteke, M.: Survey on comparative analysis of database replication techniques. Int. J. IT Eng. Appl. Sci. Res. (IJIEASR) 2(3), 72–80 (2013)

    Google Scholar 

  25. Schmidt, K.: High Availability and Disaster Recovery. Springer, Heidelberg (2006)

    Google Scholar 

  26. Severalnines: ClusterControl for MySql Galera tutorial. http://www.severalnines.com/clustercontrol-mysql-galera-tutorial

  27. Vmware: vCenter site recovery manager 5.5 (2014). http://www.vmware.com/files/pdf/products/SRM/VMware_vCenter_Site_Recovery_Manager_5.5.pdf

  28. Wiesmann, M., Pedone, F., Schiper, A., Kemme, B., Alonso, G.: Database replication techniques: a three parameter classification. In: Proceedings of the 19th IEEE Symposium on Reliable Distributed Systems, SRDS 2000, pp. 206–215 (2000)

    Google Scholar 

  29. Wikipedia: Business continuity planning. http://en.wikipedia.org/wiki/Business_continuity_planning#Business_impact_analysis_.28BIA.29

  30. Wikipedia: Virtual private network. http://en.wikipedia.org/wiki/Virtual_private_network

  31. Wood, T., Cecchet, E., Ramakrishnan, K., Shenoy, P., Van Der Merwe, J., Venkataramani, A.: Disaster recovery as a cloud service: Economic benefits & deployment challenges. In: Proceedings of the 2nd USENIX Conference on Hot Topics in Cloud Computing, p. 8 (2010)

    Google Scholar 

  32. Zerto: Zerto virtual replication. http://www.zerto.com/

  33. Zhang, W.: Linux virtual server for scalable network services. In: Ottawa Linux Symposium (2000)

    Google Scholar 

Download references

Acknowledgments

The research described here was supported by the Irish Centre for Cloud Computing and Commerce, an Irish national Technology Centre funded by Enterprise Ireland and the Irish Industrial Development Authority.

Author information

Authors and Affiliations

  1. IC4 - The Irish Centre for Cloud Computing and Commerce, Dublin City University, Dublin 9, Ireland

    Huanhuan Xiong, Frank Fowley & Claus Pahl

Authors
  1. Huanhuan Xiong
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Frank Fowley
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Claus Pahl
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Huanhuan Xiong .

Editor information

Editors and Affiliations

  1. DICIEAMA, University of Messina, Messina, Italy

    Antonio Celesti

  2. Software Evolution and Architecture Lab, University of Zürich Software Evolution and Architecture Lab, Zürich, Switzerland

    Philipp Leitner

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Xiong, H., Fowley, F., Pahl, C. (2016). A Database-Specific Pattern for Multi-cloud High Availability and Disaster Recovery. In: Celesti, A., Leitner, P. (eds) Advances in Service-Oriented and Cloud Computing. ESOCC 2015. Communications in Computer and Information Science, vol 567. Springer, Cham. https://doi.org/10.1007/978-3-319-33313-7_29

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-33313-7_29

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-33312-0

  • Online ISBN: 978-3-319-33313-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation