Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Performance comparison of distributed MySQL andMongoDB in a cloud environment
Blekinge Institute of Technology, Faculty of Computing, Department of Software Engineering.
2023 (English)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

Context: Comparing MongoDB and MySQL performance in the cloud is useful for developerswhen deciding which database to use based on cost, performance, workload size, and composition.As cloud computing becomes more popular, developers must consider the scalability, availability,and ease of use of these platforms when selecting a database. Evaluating the performance ofMongoDB and MySQL in the cloud can help developers determine the best database for theirneeds and workloads.

Objectives: The objectives of this study included examining AWS, MySQL, MongoDB, databasemetrics, and MongoDB Atlas. To compare the performance of MySQL and MongoDB databaseclusters on an EC2 instance within a VPC, a controlled experiment was conducted using YCSB.The runtime and latency of both databases were analyzed as performance metrics.

Methods: To understand cloud computing, AWS, MongoDB, MongoDB Atlas, MySQL, YCSB,and design an experiment addressing the research questions, a literature review was conducted. Acontrolled experiment was then conducted to compare the performance of MongoDB and AWSusing YCSB on an EC2 instance, with various workload sizes ranging from 100 to 100,000 andcompositions of CRUD requests. The latency and runtime for each test were analyzed to evaluatethe performance of MongoDB and MySQL.

Results: The comparison showed that MySQL performed better than MongoDB for smallerworkloads, but MongoDB outperformed MySQL as the workload increased in size. Previousresearch also found that MongoDB tends to perform better for larger workloads. The results alsoindicated that when deployed in a MongoDB Atlas cluster, MongoDB has high latency forworkloads ranging in size from 1 to 100. Another finding was that using database cluster replicassignificantly improved read operations for both databases.

Conclusions: This research compared the performance of MongoDB and MySQL in a cloudenvironment, using pre-defined workloads with varying CRUD compositions and sizes. The mainmetrics were latency and runtime. Methods used to achieve the result was an initial literature studyfollowed by a controlled experiment. Results showed that MySQL performed better with smallerworkloads and MongoDB performed better with larger workloads. Read replicas also had asignificant impact on performance for both databases. These findings suggest that developersshould consider workload size and composition, as well as scaling capacity and the availability ofread replicas, when choosing a database for a cloud-based application 

Place, publisher, year, edition, pages
2023. , p. 46
National Category
Computer Systems
Identifiers
URN: urn:nbn:se:bth-24301OAI: oai:DiVA.org:bth-24301DiVA, id: diva2:1738800
Subject / course
PA1445 Kandidatkurs i Programvaruteknik
Educational program
PAGPT Software Engineering
Supervisors
Examiners
Available from: 2023-02-23 Created: 2023-02-22 Last updated: 2023-02-23Bibliographically approved

Open Access in DiVA

Performance comparison of distributed MySQL andMongoDB in a cloud environment(2228 kB)1145 downloads
File information
File name FULLTEXT01.pdfFile size 2228 kBChecksum SHA-512
24ade0d491e495e96b3a5935c0d785dbffa850cc51cad9d2a6aa138069c4fefb95b60faf65e246f3c2f4b3a3833bae1835ac38e4ef4372e7a3948cffb1fbf14e
Type fulltextMimetype application/pdf

By organisation
Department of Software Engineering
Computer Systems

Search outside of DiVA

GoogleGoogle Scholar
Total: 1145 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 508 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf