Data synchronisation strategies for distributed web applications using MySQL, MongoDB and AWS Aurora

Abstract

A very important part that must be addressed when developing web applications with a distributed approach is data synchronisation. The data can be used across multiple platforms, services, and business locations and remains constant in value. This review paper focuses on the various synchronisation techniques used with MySQL, MongoDB, and AWS Aurora databases which are some of the most popular ones in web-oriented architectures of the present day. It starts with explaining the three basic types of databases and their architectural models since these two factors play a role in the synchronisation process and different synchronisation techniques. It considers the trade-off between eventual and strong consistency models and their impact on application performance and user experience. Other hybrid synchronisation strategies that combine several databases are also considered for their potential value in improving data accuracy and resilience. It suggests development practices that would be useful to website developers and designers focused on achieving integrated data synchronisation across platforms and adding, the debate of how best practices in data management can be advanced in the context of global networks.