Many businesses are moving their infrastructure to the cloud and may not fully understand the factors that can increase costs. With so many factors available to improve throughput in a database, it can be difficult for a database administrator to know which factors can provide the best efficiency to maintain lower costs. Grounded in Six Sigma theoretical framework, the purpose of this quantitative, quasi-experimental study was to evaluate the relationship between the time of day, the number of concurrent users, InnoDB buffer pool size, InnoDB Input/Output capacity, and MySQL transaction throughput to a MySQL database running on a cloud, virtual, database server. Data were collected from Debian Linux virtual machines (VMs) on Amazon Web Services, Google Cloud Platform, and Microsoft Azure using HammerDB database benchmarking software. The results of the one-way ANOVA were not significant. A key recommendation is to study further other factors and a more in-depth investigation into each cloud provider's performance. The implications for positive social change include the potential for database administrators to make informed decisions on how to configure MySQL to run in a VM and choose the best cloud provider so that nonprofits may serve their clients more efficiently.
|Advisor:||Case, Steven, Shao, Charlie|
|Department:||Information Systems and Technology|
|School Location:||United States -- Minnesota|
|Source:||DAI-B 82/7(E), Dissertation Abstracts International|
|Subjects:||Information Technology, Computer Engineering|
|Keywords:||Cloud, Database efficiency, Six sigma|
Copyright in each Dissertation and Thesis is retained by the author. All Rights Reserved
The supplemental file or files you are about to download were provided to ProQuest by the author as part of a
dissertation or thesis. The supplemental files are provided "AS IS" without warranty. ProQuest is not responsible for the
content, format or impact on the supplemental file(s) on our system. in some cases, the file type may be unknown or
may be a .exe file. We recommend caution as you open such files.
Copyright of the original materials contained in the supplemental file is retained by the author and your access to the
supplemental files is subject to the ProQuest Terms and Conditions of use.
Depending on the size of the file(s) you are downloading, the system may take some time to download them. Please be