Rancang Bangun Server HAproxy Load Balancing Master to Master MySQL (Replication) Berbasis Cloud Computing

Eka Pandu Cynthia, iwan iskandar, Anwar Alfaruqi Sipayung

Abstract


At present, the development of cloud computing technology is experiencing rapid development. Also in line with the increase in the need and use of cloud computing technology itself. This rapid and high increase can cause an increase in load for the existing server so that it can result in overload on the connection path traffic. To avoid and optimize management on the server, it is necessary to share network load using various solutions available in the load balancing method. One solution is to use HAProxy software. HAProxy bridges at least 2 servers to apply load balancing and use the Round Robin scheduling algorithm. In the database management of two servers, replication Master to Master can be used by using MySQL as an existing database management media. From the results of tests conducted in this study, the HAProxy server is considered capable of handling problems compared to a single server. A replication that was tested was also considered to be a solution to bridge changes in existing data on the HAProxy server.

Full Text:

PDF

References


CISCO (2010). An Introduction to the Cisco Lifecycle Services Approach. Retrieved from https://www.cisco.com/web/partners/services/promos/accelerate/downloads/lifecycle_services_sg.pdf

ERNAWATI, T., & ZULFIAJI, A. H. (2013). Analisis dan Pembangunan Infrastruktur Cloud Computing, 1(2), 17–23.

EUROPEAN TELECOMMUNICATIONS STANDARDS INSTITUTE (ETSI). (2012). ETSI Technical Committee Speech and multimedia Transmission Quality (STQ). In ETSI EG 203 165 Speech and multimedia Transmission Quality (STQ); Throughput Measurement Guidelines (Vol. 1, pp. 1–30).

IDCLOUDHOST.COM. (2016). Mengenal Virtual Private Server atau VPS. Retrieved February 5, 2019, from https://idcloudhost.com/mengenal-virtual-private-server-atau-vps/

LUKITASARI, D., & OKLILAS, A. F. (2010). Analisis Perbandingan Load Balancing Web Server Tunggal Dengan Web server Cluster Menggunakan Linux Virtual Server, 5(2), 31–34.

MELL, P., & GRANCE, T. (2011). The NIST Definition of Cloud Computing Recommendations of the National Institute of Standards and Technology. Nist Special Publication, 145, 7. https://doi.org/10.1136/emj.2010.096966

MOLYNEAUX, I. (2014). The Art of Application Performance Testing From Strategy to Tools.

MSN, F., & RAHMATULLOH, A. (2017). Implementasi Load Balancing Web Server menggunakan Haproxy dan Sinkronisasi File pada Sistem Informasi Akademik Universitas Siliwangi, 2, 241–248.

MULIYANTORO, H. S. (2013). Penerapan Metode Load-Balancing Clusters Pada Database Server Guna Peningkatan Kinerja Pengaksesan Data, IX(1), 97–108.

NASSER, H., & WITONO, T. (2016). ANALISIS ALGORITMA ROUND ROBIN , LEAST CONNECTION , DAN RATIO PADA LOAD BALANCNG, 12(1), 25–32.

NUGROHO, A., YAHYA, W., & AMRON, K. (2017). Analisis Perbandingan Performa Algoritma Round Robin dan Least Connection untuk Load Balancing pada Software Defined Network, 1(12), 1568–1577.

OKTAVIANUS, Y. L. (2013). Membangun Sistem Cloud Computing Dengan Implementasi Load Balancing Dan Pengujian Algoritma Penjadwalan Linux Virtual Server Pada, (1), 25–30.

ORACLE. (2019a). General Information. Retrieved February 4, 2019, from https://dev.mysql.com/doc/refman/8.0/en/introduction.html

ORACLE. (2019b). MySQL. Retrieved April 20, 2019, from https://dev.mysql.com/doc/refman/5.7/en/replication.html

PURBO, O. W. (2011). Petunjuk Praktis Cloud Computing Mengunakan Open Source, 1–48.

RABUR, J. A., PURWADI, J., & RAHARJO, W. S. (2012). Implementasi Load Balancing Web Server Menggunakan Metode LVS-NAT, 8(2).

RACHMAWAN, D., IRWAN, D., & ARGYAWATI, H. (2016). Penerapan Teknik Load Balancing Pada Web Server Lokal Dengan Metode Nth Menggunakan, 4(2), 98–108.

SAM, J. (2009). No Title. Retrieved from https://commons.wikimedia.org/wiki/File:Cloud_computing.svg#/media/File:Cloud_computing.s vg

SAMAL, P., & MISHRA, P. (2013). Analysis of variants in Round Robin Algorithms for load balancing in Cloud Computing, 4(3), 416–419.

SONY, T., ANDONO., & PRATAMA, P. N. (2013). Visualisasi Pembelajaran Algoritma Round Robin Pada Load Balancing. Retrieved from http://eprints.dinus.ac.id/id/eprint/4802

SUMARNO, E., & HASMORO, H. P. (2011). Implementasi Metode Load Balancing Dengan Dua Jalur (Study Kasus Jaringan Internet Smp Negeri 2 Karanganyar ), 28–34.

SYAPUTRA, A. W., & ASSEGAFF, S. (2017). Analisis Dan Implementasi Load Balancing Dengan Metode Nth Pada Jaringan Dinas Pendidikan Provinsi Jambi, 2(4).

YEAGER, N. J., & MCGRATH, R. E. (1996). Web Server Technology. Morgan Kaufmann.




DOI: http://dx.doi.org/10.30829/algoritma.v4i1.7275

Refbacks

  • There are currently no refbacks.


Indexing:

    

 

 

Creative Commons License

Algoritma: Jurnal Ilmu Komputer dan Informatika

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.