Performance Evaluation of a Laravel-based Internship Website using MySQL Master–Slave Replication

Viona Mojang Pamungkas, Galura Muhammad Suranegara

Abstract


Single database architectures often experience performance degradation as user load increases because all read and write operations are processed centrally, causing bottlenecks and limiting the scalability of web systems. To address this issue, this study implements database replication using a MySQL Master–Slave architecture combined with the separation of read and write operations in a containerized Laravel-based web system. A quantitative experimental method was applied by comparing the Single Database and Master–Slave Replication configurations implemented in a Docker environment on Windows Subsystem for Linux 2 (WSL2). Performance evaluation was conducted using Apache JMeter at three workload levels low (10 users), medium (50 users), and high (100 users) based on response time, throughput analysis, latency analysis, and error rate. The results show that the Master–Slave configuration provides more stable performance at medium to high workloads, with latency between 0.20 and 0.26 seconds and an error rate of 0% in all test scenarios. Additionally, the highest throughput of 2.01 requests per second was achieved at medium workload, indicating effective read-write separation and better workload distribution through database replication.

Keywords


database replication; latency analysis; read-write separation; throughput analysis; web system scalability

Full Text:

PDF

References


Sasmoko, Y. Indrianti, S. R. Manalu, and J. Danaristo, “Analyzing Database Optimization Strategies in Laravel for an Enhanced Learning Management,” Procedia Comput. SCI., Vol. 245, No. C, pp. 799–804, 2024, DOI: 10.1016/j.procs.2024.10.306.

A. F. Rizana, I. I. Wiratmadja, and M. Akbar, “Exploring Capabilities for Digital Transformation in the Business Context: Insight from a Systematic Literature Review,” Sustain., Vol. 17, No. 9, 2025, DOI: 10.3390/su17094222.

H. Fa’iqoh and D. F. Suyatno, “Evaluasi User Experience Aplikasi Indonesia Pustaka Nasional ( IPUSNAS ) menggunakan Metode Heart Metrics,” J. Emerg. Inf. Syst. Bus. Intell., Vol. 05, No. 02, pp. 126–135, 2024, DOI: 10.26740/jeisbi.v5i2.60419.

L. Setiawati, A. Hadiapurwa, B. Santoso, H. Nugraha, and P. Rusli, “Importance-Performance Analysis of SINERGI UPI Website User Satisfaction,” J. Edutech Undiksha, Vol. 12, No. 1, pp. 20–27, 2024, DOI: 10.23887/jeu.v12i1.64450.

F. Islamiah and R. Wijaya, “Penilaian Kepuasan Pengguna Website Sistem Informasi Akademik menggunakan Metode Website Quality,” METIK (Media Teknologi Informasi dan Komputer Jurnal)., Vol. 6, No. 2, pp. 133–139, 2022, DOI: 10.47002/metik.v6i2.381.

S. Muna, Nurdin, and Taufiq, “Comparative Analysis of State Universities on Website Performance in Aceh using the PIECES Method,” JITE (Journal of Informatics Telecommunication Engineering)., Vol. 7, No. July, pp. 71–83, 2023, DOI: 10.31289/jite.v7i1.9167.

S. A. Fadillah, N. Chandra, and C. Rivatunisa, “Implementasi Agile Scrum pada Pembuatan Website Sistem Informasi Manajemen Kuliner,” Decod. J. Pendidik. Teknol. Inf., Vol. 4, No. 1, pp. 301–315, 2024, DOI: 10.51454/decode.v4i1.357.

L. M. Diana and E. M. Stefany, “Pengembangan Website Administrasi Skripsi Program Studi Pendidikan Informatika,” Decod. J. Pendidik. Teknol. Inf. ISSN, Vol. 3, No. 2, pp. 229–235, 2023, DOI: 10.51454/decode.v3i2.167.

A. G. Karyn, P. Pahrudin, and A. A. Khair, “Design of the Management Information System for Interns at the Communication and Information Service of East Kalimantan Province,” Int. J. Inf. Technol., Vol. 9, No. 158, pp. 93–106, 2025, DOI: 10.30645/ijistech.v9i1.401.

E. C. Foster and S. V. Godbole, Database Systems: A Pragmatic Approach, 3rd edition. Boca Raton, FL, USA: Auerbach Publications, 2022.

E. Firmansyah, H. Firdaus, and Samidi, “Optimasi Performa Query Subsidi Debitur dengan Index and Table Partition, Subquery and Indexing, dan Parallel Query Execution,” J. Pendidik. dan Teknol. Indones., Vol. 5, No. 6, pp. 1769–1785, 2025, DOI: 10.52436/1.jpti.824.

M. A. Georgiou, M. Panayiotou, M. Sirivianos, and H. Herodotou, “Attaining Workload Scalability and Strong Consistency for Replicated Databases with Hihooi,” No. June, 2021, DOI: 10.1145/3448016.3452746.

S. Ramanathan, G. Gautam, V. Srinivasan, and P. Parag, “Latency-Redundancy Tradeoff in Distributed Read-Write Systems,” 2022 14th Int. Conf. Commun. Syst. NETworkS, COMSNETS 2022, pp. 172–180, 2022, DOI: 10.1109/COMSNETS53615.2022.9668414.

S. P. Kane and K. Mathhias, Docker: Up & Running: Shipping Reliable Containers in Production. O’Reilly Media, 2023.

M. R. Fachrudin and A. R. Muslikh, “Optimization of Application Deployment Architecture in Container Orchestration,” J. Appl. Informatics Comput., Vol. 9, No. 2, pp. 383–392, 2025, DOI: 10.30871/jaic.v9i2.8972.

T. Abdillah and I. P. E. Prismana, “Analisis Performansi Web Server menggunakan Load Balancing pada Virtualisasi Docker Container,” J. Informatics Comput. SCI., Vol. 03, No. 04, pp. 526–533, 2022, DOI: 10.26740/jinacs.v3n04.p526-533.

D. K. Wibowo, A. Darmawan, and D. A. Nawangnugraeni, “A Comparative Study of Multi-Master Replication of NOSQL Database Server with Varying Data Formats,” J. Tek. Inform., Vol. 6, No. 1, pp. 411–418, 2025, DOI: 10.52436/1.jutif.2025.6.1.4371.

I. Sholihah and C. Darujati, “Sistem Replikasi basis Data berdasarkan MySQL menggunakan Container Docker [Database Replication System based on MySQL using Docker Containers],” Maj. Ilm. Teknol. Elektro, Vol. 21, No. 2, p. 209, 2022, DOI: 10.24843/mite.2022.v21i02.p08.

I. S. Haryoto, G. Firmansyah, B. Tjahjono, and A. M. Widodo, “Evaluation and Optimization of MySQL Master-Slave Performance with Quantitative Methods on the Database of Psychology Test Applicants SIM PT XYZ at Polda Metro Jaya,” LOCUS, Vol. 4, No. 9, pp. 8896–8905, 2025, DOI: 10.58344/locus.v4i9.4685.

T. Pohanka and V. Pechanec, “Evaluation of Replication Mechanisms on Selected Database Systems,” ISPRS Int. J. Geo-Information, Vol. 9, No. 4, 2020, DOI: 10.3390/ijgi9040249.

R. Wati, N. Andriyani, T. Susilowati, S. Informasi, F. Teknologi, and I. B. Nusantara, “Rancang Bangun Sistem Informasi Akademik berbasis Microservices,” J. Artif. Intell. Digit. Bus., Vol. 4, No. 4, pp. 4906–4912, 2025, DOI: 10.31004/riggs.v4i4.4006.

T. Gkamas, V. Karaiskos, and S. Kontogiannis, “Performance Evaluation of Distributed Database Strategies using Docker as a Service for Industrial IoT Data: Application to Industry 4.0,” Inf., Vol. 13, No. 4, 2022, DOI: 10.3390/info13040190.




DOI: https://doi.org/10.32520/stmsi.v15i4.6152

Article Metrics

Abstract view : 1 times
PDF - 0 times

Refbacks

  • There are currently no refbacks.


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