Experimentell jämförelse av Cassandra, MongoDB och MySQL

Sammanfattning: Context. Performance and resource usage is often an important factor for database driven services. Depending on the purpose of the application, choosing the wrong type of database may require unnecessary hardware upgrades or replacements. Objectives. This study investigates the differences in performance and resource usage between different SQL- and NoSQL-databases. The study is a comparison that focuses on how the databases perform in different applications. The purpose is to give a hint of which database may be the most appropriate depending on the application. Methods. The different databases are compared using experiments, executed with the help of a testing tool developed to measure the performance and resource usage for the different databases. Results. Several tests have been executed on Cassandra, MongoDB and MySQL that are the databases used in this study. Where the performance is measured as operations per second and the resource usage is measured as the activity of CPU, RAM and harddrive. Conclusions. We conclude that the databases perform differently well dependning on the application. In some of the cases MongoDB performed the best, while MySQL performed best in others. The resource usage also differs a lot, like the performance, dependning on the application. As a conclusion it’s recommended to test what database may suit the specific situation depending on the application.