Hybrid Database System of MySQL and MongoDB in Web Application Development

Abstract

The increasing amount of data that need to be processed in a company are affecting the performances of the database system. Relational Database Management System (RDBMS) is a commonly used database system, but also known to having a decreased performance when handling high amount of data. N oSQL is an alternative storage option that is different than RDBMS and known for faster performance when handling high amount of data. In this contribution, we compare the performances between RDBMS MySQL and a hybrid model of MySQL and NoSQL MongoDB when being used on a web application. We implemented a simple social media website to evaluate the performance of using different database models. The website is equipped with chat and profile view features. Experiments are performed using randomly generated user profiles and chat data. Based on our evaluations, the hybrid database of MySQL and MongoDB achieves higher read and write performances than the MySQL alone. Meanwhile MySQL can handle more sensitive data and maintaining data consistency. The hybrid model database MySQL and MongoDB uses less disk space than MySQL alone, but uses more RAM. We also observed that there is not much difference in CPU usage for both database models.