Aulia Arafat, Aulia
Unknown Affiliation

Published : 1 Documents
Articles

Found 1 Documents
Search

Analisis Kinerja MySQL Cluster Menggunakan Metode Load Balancing Gani, Taufiq Abdul; Arafat, Aulia; Melinda, .
Jurnal Rekayasa Elektrika Vol 11, No 4 (2015)
Publisher : Universitas Syiah Kuala

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (843.766 KB) | DOI: 10.17529/jre.v11i4.2358

Abstract

Information system and data is a very important thing nowadays. An information system especially a database is designed with a high data availability. One of the database systems is MySQL cluster. Sometimes, its performance decreased because of the system’s incapablity to handle the data. To overcome this problem, the research of load balancing systems for MySQL cluster is needed. This research is intended to analyze the effect of load balancing clustering methods on MySQL cluster which by default has been set as failover clustering. The analysis is done through data collection and database transactions test to get the number of Transactions per second (TPS) and response time parameter using SysBench. The test is divided into two main scenarios, the simple and complex-mode that running on 4 computers. The tests were conducted by giving workloads from 8 up to 128 threads respectively to the server through a client on default conditions and load balancing. The test results showed the number of TPS at MySQL cluster default is 536.61. In contrast, number of TPS at load balancing is better at 2261.22. Likewise, the response time at MySQL cluster load balancing is 147.55 ms faster than that of the default one at 335.00 ms.