Impact of Database Migration on Application Performance : A Case Study of Database Migration from AWS to GCP
Oluwafemi Oloruntoba, Samuel O. Fakunle, Bolaji Wahab, Boluwaji L. Ogunsanmi · International Journal of Scientific Research in Science Engineering and Technology · 2023
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.