Performance Study of MySQL and MongoDB for IoT Data Processing and Storage
Tsvetelina Mladenova, Irena Valova · 2022
One of the most critical moments in the development of software development is the emergence and use of databases. With the emergence of the Internet and web applications, as well as with the entry of IoT devices into literally all spheres of our lives, the amount of data that is generated and processed increases many times. The popular SQL databases cannot meet the requirements of the new volumes of data, and this necessitates the search for other solutions and the emergence of NoSQL databases. It is challenging to compare and evaluate the two types when designing and developing software applications.This paper presents a study and performance comparison of the two types (SQL and NoSQL) databases for data from IoT devices and sensors. Two basic operations - Insert and Select - have been tested, in different technical variants. The results show that MySQL is a suitable choice when there is a need for multiple select queries and MongoDB is suitable when there are numerous insert queries that have to be processed by the DBMS. The experiments show that a combination of both databases is an optimal solution.