Article Per Year (5 Year)
p-Index From 2021 - 2026
0
P-Index
This Author published in this journals
All Journal Jurnal Rekayasa elektrika
Aulia Arafat
Jurusan Teknik Elektro, Fakultas Teknik, Universitas Syiah Kuala
Computer Science & IT Control & Systems Engineering Electrical & Electronics Engineering Energy Engineering

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

 1 
Analisis Kinerja MySQL Cluster Menggunakan Metode Load Balancing Taufiq Abdul Gani; Aulia Arafat; . 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.
Analisis Kinerja MySQL Cluster Menggunakan Metode Load Balancing Taufiq Abdul Gani; Aulia Arafat; . Melinda
Jurnal Rekayasa Elektrika Vol 11, No 4 (2015)
Publisher : Universitas Syiah Kuala

Show Abstract | Download Original | Original Source | Check in Google Scholar | 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.
Co-Authors Melinda Melinda Taufiq Abdul Gani