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

Sumit Pillai * and Vasudhar Sai Thokala

Independent Researcher, USA.
 
Research Article
International Journal of Science and Research Archive, 2023, 09(01), 779-793.
Article DOI: 10.30574/ijsra.2023.9.1.0349
Publication history: 
Received on 02 April 2023; revised on 17 May 2023; accepted on 28 June 2023
 
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.
 
Keywords: 
Distributed database; Data Synchronization; Distributed web apps; MySQL; MongoDB; AWS Aurora
 
Full text article in PDF: 
 
Copyright information: 

Copyright © 2023 Author(s) retain the copyright of this article. This article is published under the terms of the Creative Commons Attribution Liscense 4.0