Analisis Kinerja MySQL Cluster Menggunakan Metode Load Balancing

Analisis Kinerja MySQL Cluster Menggunakan Metode Load Balancing

load balancing, MySQL Cluster, response time, threads, transactions per second

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.

Gani, Taufiq Abdul

Arafat, Aulia

Melinda, .

Jurnal Rekayasa Elektrika; Vol 11, No 4 (2015); 129-134

2252-620X

1412-4785

Universitas Syiah Kuala

2015-09-10

Copyright (c) 2015 Jurnal Rekayasa Elektrika

http://jurnal.unsyiah.ac.id/JRE/article/view/2358/11_4_2

application/pdf

eng

info:eu-repo/semantics/article

info:eu-repo/semantics/publishedVersion

Peer-reviewed Article

http://jurnal.unsyiah.ac.id/JRE/article/view/2358

10.17529/jre.v11i4.2358