An Analysis of the Performance and Configuration Features of MySQL Document Store and Elasticsearch as an Alternative Backend in a Data Replication Solution

Applied Sciences

Cristian I. Moisi¹  Doina R. Zmaranda²  Robert Ş. Győrödi²  Cornelia A. Győrödi²  Livia Bandici³ 

[1] Department of Computer Science and Information Technology, Faculty of Electrical Engineering and Information Technology, University of Oradea, 410087 Oradea, Romania;Department of Computers and Information Technology, University of Oradea, 410087 Oradea, Romania;Department of Electrical Engineering, University of Oradea, 410087 Oradea, Romania;

关键词: relational databases;    non-relational databases;    CRUD (create read update delete) operation;    databases replication;   

DOI  :  10.3390/app112411590

来源: DOAJ

【 摘 要 】

In recent years, with the increase in the volume and complexity of data, choosing a suitable database for storing huge amounts of data is not easy, because it must consider aspects such as manageability, scalability, and extensibility. Nowadays, the NoSQL databases have gained immense popularity for their efficiency in managing such datasets compared to relational databases. However, relational databases also exhibit some advantages in certain circumstances, therefore many applications use a combined approach: relational and non-relational. This paper performs a comparative evaluation of two popular open-source DBMSs: MySQL Document Store and Elasticsearch as non-relational DBMSs; this comparison is based on a detailed analysis of CRUD operations for different amounts of data showing how the databases could be modeled and used in an application. A case-study application was developed for this purpose in Java programming language and Spring framework using for data storage both relational MySQL and non-relational Elasticsearch and MySQL Document Store. To model the real situation encountered in several developed applications that use both relational and non-relational databases, a data replication solution that imports data from the primary relational MySQL database into Elasticsearch and MySQL Document Store as possible alternatives for more efficient data search was proposed and implemented.

【 授权许可】

Unknown