Applied Sciences | Open Access | DOI: https://doi.org/10.37547/tajas/Volume07Issue08-13

Core Data-Management Strategies during Migration to Serverless Aurora Databases

Mykhaylo Kurtikov , Senior Software Developer Austin, United States

Abstract

The paper analyses core data-management strategies that ensure a consistent, scalable, and cost-efficient transition from on-premises or monolithic relational databases to Amazon Aurora Serverless. Drawing on recent peer-reviewed research and industry reports, the study first frames serverless Aurora within a microservice-centric architecture, emphasising the “database-per-service” pattern, CAP-theorem trade-offs, and the complementary roles of transactional stores, data lakes, and data warehouses. The second section evaluates mechanisms for maintaining data integrity during and after migration, contrasting ACID guarantees in Aurora with BASE-oriented eventual consistency at the system boundary, and detailing patterns such as sagas and event sourcing for cross-service coordination. The third part (retained in full) offers a practice-oriented synthesis of automation techniques: AWS Database Migration Service for zero-downtime change-data-capture, AWS Schema Conversion Tool for heterogeneous schema conversion, and Infrastructure-as-Code pipelines for repeatable cluster provisioning and continuous delivery. Empirical evidence from large-scale migrations—including multi-billion-row financial and media platforms—is used to quantify benefits (e.g., up to 40 % cost reduction and sub-minute fail-over times) and to highlight common pitfalls. The paper concludes with a set of actionable guidelines that align architectural decisions, consistency requirements, and automation practices, demonstrating that a properly orchestrated move to Aurora Serverless not only preserves, but often enhances enterprise data reliability and agility.

Keywords

Serverless databases, Amazon Aurora, data migration, data consistency, ACID vs BASE, CAP theorem, microservices architecture, AWS DMS, schema conversion

References

Gartner (2021). Gartner Says Cloud Will Be the Centerpiece of New Digital Experiences. Press Release. Retrieved from https://www.gartner.com/en/newsroom/press-releases/2021-11-10-gartner-says-cloud-will-be-the-centerpiece-of-new-digital-experiences

Deloitte & AWS (2021). Accelerating your Database Modernization journey with Deloitte on AWS. Retrieved from https://d1.awsstatic.com/partner-network/AWSDatabase_Modernization.pdf

AWS (2020). Samsung Migrates 1.1 Billion Users across Three Continents from Oracle to Amazon Aurora with AWS Database Migration Service. Retrieved from https://aws.amazon.com/ru/solutions/case-studies/samsung-migrates-off-oracle-to-amazon-aurora/

Lawton, G. (2020). How to carefully plan a database migration to the cloud. techtarget. Retrieved from https://www.techtarget.com/searchcloudcomputing/feature/How-to-carefully-plan-a-database-migration-to-the-cloud

Castro, P., Ishakian, V., Muthusamy, V., & Slominski, A. (2019). The rise of serverless computing. Communications of the ACM, 62(12), 44-54. DOI: 10.1145/3368454

Amazon Web Services. Database-per-service pattern. Retrieved from https://docs.aws.amazon.com/prescriptive-guidance/latest/modernization-data-persistence/database-per-service.html

Amazon Web Services. CAP theorem. Retrieved from https://docs.aws.amazon.com/whitepapers/latest/availability-and-beyond-improving-resilience/cap-theorem.html

Amazon Web Services. Amazon Aurora storage. Retrieved from https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html

Barnhart, B., Brooker, M., Chinenkov, D., Hooper, T., Im, J., Jha, P. C., ... & Yan, J. (2024). Resource Management in Aurora Serverless. Proceedings of the VLDB Endowment, 17(12), 4038-4050.

Amazon Web Services. Amazon Aurora DB clusters. Retrieved from https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html

Amazon Web Services. Amazon Aurora reduces cross-Region Global Database Switchover time to typically under 30 seconds. Retrieved from https://aws.amazon.com/ru/about-aws/whats-new/2025/05/amazon-aurora-cross-region-global-database-switchover-time-under-30-seconds/

Nambiar, A., & Mundra, D. (2022). An overview of data warehouse and data lake in modern enterprise data management. Big data and cognitive computing, 6(4), 132.

Amazon Web Services. What’s the Difference Between an ACID and a BASE Database?. Retrieved from https://aws.amazon.com/compare/the-difference-between-acid-and-base-database/?nc1=h_ls

Amazon Web Services. Migrating to Aurora Serverless v2. Retrieved from https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.upgrade.html

AWS Database Blog (2025). Srivastava, A. et al. Migrate a self-managed MySQL database to Amazon Aurora MySQL using AWS DMS homogeneous data migrations. Retrieved from https://aws.amazon.com/blogs/database/migrate-a-self-managed-mysql-database-to-amazon-aurora-mysql-using-aws-dms-homogeneous-data-migrations/

Article Statistics

Downloads

Download data is not yet available.

Copyright License

Download Citations

How to Cite

Mykhaylo Kurtikov. (2025). Core Data-Management Strategies during Migration to Serverless Aurora Databases. The American Journal of Applied Sciences, 7(8), 168–178. https://doi.org/10.37547/tajas/Volume07Issue08-13