Evaluasi dan Optimasi Kinerja MySQL Master-Slave dengan Metode Kuantitatif pada Database Pemohon Tes Psikologi SIM PT XYZ pada POLDA METRO JAYA

Authors

  • Iin Sahuri Haryoto Universitas Esa Unggul
  • Gerry Firmansyah Universitas Esa Unggul
  • Budi Tjahjono Universitas Esa Unggul
  • Agung Mulyo Widodo Universitas Esa Unggul
  • Habibullah Akbar Universitas Esa Unggul
  • Nenden Siti Fatonah Universitas Esa Unggul

DOI:

https://doi.org/10.58344/locus.v4i9.4685

Keywords:

MySQL, master-slave replication, database optimization, system performance, cloud computin

Abstract

The development of information technology and cloud computing has enabled organizations to manage large-scale data efficiently. PT XYZ, which is engaged in psychological testing for Driving Licenses (SIM), uses a web-based system with a MySQL database that has implemented master-slave replication. However, as the data volume increases to 4,000-5,000 entries per day, the system experiences performance constraints, especially in the speed of read and write queries. This study aims to optimize the performance of the MySQL database by adjusting the server configuration and specifications to improve system efficiency. The test results show that server specification settings, including processor speed, memory size, and replication configuration, play an important role in improving system performance. By adjusting the master and slave server configurations, the system shows a significant increase in database response time and operational efficiency. This optimization is expected to be a reference in the implementation and management of large-scale databases using MySQL replication.

Downloads

Published

2025-09-12

Issue

Vol. 4 No. 9 (2025): : JURNAL LOCUS: Penelitian dan Pengabdian

Section

Articles

License

Copyright (c) 2025 Iin Sahuri Haryoto, Gerry Firmansyah, Budi Tjahjono, Agung Mulyo Widodo, Habibullah Akbar, Nenden Siti Fatonah

Creative Commons License

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

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International (CC-BY-SA). that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.