Impact of Database Migration on Application Performance : A Case Study of Database Migration from AWS to GCP

Authors

  • Oluwafemi Oloruntoba  Management Information Systems, Lamar University, Beaumont, USA
  • Samuel O. Fakunle  Information Security & Systems, University of East London. United Kingdom
  • Bolaji Wahab  Database Engineering, N26 Product and Tech GmbH Berlin, Germany
  • Boluwaji L. Ogunsanmi  Database Engineering, Deriv , Malaysia

DOI:

https://doi.org/10.32628/IJSRSET25122168

Keywords:

Cloud Migration, Database Performance, Amazon Web Services, Google Cloud Platform, Query Optimization, Latency, Throughput

Abstract

This study investigates the impact of database migration from Amazon Web Services to Google Cloud Platform on application performance. The research problem addresses the need for in-depth case studies evaluating the specific performance impacts of database migration between different cloud providers, an area where current literature is lacking. A case study approach was employed, using a sample application initially deployed on an AWS-hosted database and subsequently migrated to a GCP-hosted database. The findings of this research provide valuable insights into the challenges and best practices associated with database migration, which can inform decision-making for organizations considering similar migration projects. Performance was evaluated in both environments, measuring query execution time, latency, throughput, and resource utilization before and after the migration. The results demonstrate a significant impact on application performance, with the GCP environment showing a 15% faster average query execution time, a 20% reduction in average latency, and a 25% higher throughput. Resource utilization was also lower on the GCP database instance. These findings suggest organizations should carefully evaluate the potential performance benefits of migrating their databases to different cloud platforms. Key recommendations include conducting thorough performance evaluations of existing database environments and assessing the capabilities of target cloud platforms. The implications of this study highlight the tangible improvements in application performance that can be achieved through strategic database migration, especially for applications sensitive to database performance. Future work may explore AI-driven automation in migration processes and long-term post-migration performance monitoring. The findings contribute to the broader understanding of database migration best practices in cloud computing environments.

References

  1. nCube, "AWS vs. MS Azure vs. Google Cloud: Feature Overview, Pros and Cons." [Online]. Available: https://ncube.com/aws-vs-ms-azure-vs-google-cloud-feature-overview-pros-and-cons
  2. M. Fahmideh, F. Daneshgar, G. Beydoun, and F. Rabhi, "Challenges in migrating legacy software systems to the cloud — an empirical study," Information Systems, vol. 67, p. 100, 2017. [Online]. Available: https://doi.org/10.1016/j.is.2017.03.008
  3. J. Jangid and S. Malhotra, "Optimizing Software Upgrades in Optical Transport Networks: Challenges and Best Practices," Nanotechnology Perceptions, vol. 18, no. 2, pp. 194–206, 2022. https://nano-ntp.com/index.php/nano/article/view/5169
  4. P. Jamshidi, A. Ahmad, and C. Pahl, "Cloud Migration Research: A Systematic Review," IEEE Trans. Cloud Comput., vol. 1, no. 2, pp. 142–157, 2013. [Online]. Available: https://doi.org/10.1109/tcc.2013.10
  5.  M., "Empirical Performance Metrics Study of Execution of Database Queries in Implementation of Web Services," J. Comput. Sci., vol. 8, no. 8, pp. 1346–1352, 2012. [Online]. Available: https://doi.org/10.3844/jcssp.2012.1346.1352
  6. A. Mahgoub et al., "OPTIMUSCLOUD: Heterogeneous Configuration Optimization for Distributed Databases in the Cloud," in Proc. USENIX Annu. Tech. Conf., 2020, pp. 189–202. [Online]. Available: https://www.usenix.org/system/files/atc20-mahgoub.pdf
  7. O. Oloruntoba, T. Ekundayo, and T. Aladebumoye, "Optimizing Investments with Cloud-Based Data Mining Frameworks," Int. Res. J. Mod. Eng. Technol. Sci., vol. 4, no. 12, p. 2172, 2022, doi: 10.56726/IRJMETS32232.
  8. A. Prytulenets, "How to Migrate from AWS to GCP: a Step-by-Step Guide," 2024.
  9. Sachin Dixit "AI-Powered Risk Modeling in Quantum Finance : Redefining Enterprise Decision Systems " International Journal of Scientific Research in Science, Engineering and Technology (IJSRSET), Print ISSN : 2395-1990, Online ISSN : 2394-4099, Volume 9, Issue 4, pp.547-572, July-August-2022. Available at doi : https://doi.org/10.32628/IJSRSET221656
  10. R. Rai, G. Sahoo, and S. Mehfuz, "Exploring the factors influencing the cloud computing adoption: a systematic study on cloud migration," SpringerPlus, vol. 4, no. 1, 2015. [Online]. Available: https://doi.org/10.1186/s40064-015-0962-2
  11. Srikanth Yerra, “Reducing Shipping Delays through Automated ETL Processing and Real-Time Data Insights,” International Journal of Scientific Research in Computer Science Engineering and Information Technology, pp. 419–426, Oct. 2023, doi: https://doi.org/10.32628/cseit239075
  12. J. Schad, J. Dittrich, and J.-A. Quiané-Ruiz, "Runtime measurements in the cloud," Proc. VLDB Endow., vol. 3, pp. 460–471, 2010. [Online]. Available: https://doi.org/10.14778/1920841.1920902
  13. A. A. El-Moursy, S. Abdallah, M. Saad, and K. Alnajjar, "Parallel Two-Way Relay Channel Estimation in Cloud-Based 5G Radio Access Networks," IEEE Access, vol. 8, pp. 144077–144091, 2020. [Online]. Available: https://doi.org/10.1109/access.2020.3014507
  14. J. Tuttle et al., "Multi-tenancy Cloud Access and Preservation," in Proc. ACM/IEEE Joint Conf. Digit. Libr., 2020, pp. 557–558. [Online]. Available: https://doi.org/10.1145/3383583.3398624
  15. C. Li and J. Gu, "An integration approach of hybrid databases based on SQL in cloud computing environment," Softw. Pract. Exp., vol. 49, no. 3, pp. 401–422, 2018. [Online]. Available: https://doi.org/10.1002/spe.2666
  16. S. Strauch et al., "Migrating enterprise applications to the cloud: methodology and evaluation," Int. J. Big Data Intell., vol. 1, no. 3, p. 127, 2014. [Online]. Available: https://doi.org/10.1504/ijbdi.2014.066319
  17. Y. Zhai, M. Liu, J. Zhai, X. Ma, and W. Chen, "Cloud versus in-house cluster," 2011. [Online]. Available: https://doi.org/10.1145/2063348.2063363
  18.  X. Zhou, H. Liu, R. Urata, and S. Zebian, "Scaling large data center interconnects: Challenges and solutions," Opt. Fiber Technol., vol. 44, p. 61, 2017. [Online]. Available: https://doi.org/10.1016/j.yofte.2017.10.002
  19. F. Ahmad et al., "Efficient Workload Allocation and Scheduling Strategies for AI-Intensive Tasks in Cloud Infrastructures," Power Syst. Technol., vol. 47, no. 4, pp. 82–102, 2023. [Online]. Available: https://doi.org/10.52783/pst.160

International Journal of Scientific Research in Science, Engineering and Technology

Downloads

Published

2023-11-16

Issue

Volume 10, Issue 6, November-December-2023

Section

Research Articles

License

Copyright (c) IJSRSET

Creative Commons License

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

How to Cite

[1]
Oluwafemi Oloruntoba, Samuel O. Fakunle, Bolaji Wahab, Boluwaji L. Ogunsanmi "Impact of Database Migration on Application Performance : A Case Study of Database Migration from AWS to GCP" International Journal of Scientific Research in Science, Engineering and Technology (IJSRSET), Print ISSN : 2395-1990, Online ISSN : 2394-4099, Volume 10, Issue 6, pp.424-436, November-December-2023. Available at doi : https://doi.org/10.32628/IJSRSET25122168