Jurnal Sisfotek Global
Vol 12, No 1 (2022): JURNAL SISFOTEK GLOBAL

Implementation of Database Distributed Sharding Horizontal Partition in MySQL. Case Study of Application of Food Serving On Kemkes

Samidi Samidi (Universitas Budi Luhur)
Ronal Yulyanto Suladi (Universitas Budi Luhur)
Ario Bambang Lesmana (Universitas Budi Luhur)



Article Info

Publish Date
30 Mar 2022

Abstract

In today's digital era, database systems are becoming a mandatory thing that is used in every industry field to improve the performance of the industry, over time with the increasing need for databases, single databases and single servers are considered less capable in handling data that continues to increase in number, so it often leads to a decline in performance. Therefore came the idea of centralized data storage that can be modified to accommodate the availability, scalability, reliability, and management of data. One way that can be done is to apply Distribute Database using Sharding Horizontal Partition technique and experimental methods using mariadb and spider engine. The test was carried out on the database of food processing sites (TPP) in the TPP application at the ministry of health. The test results prove that although in some journals about Sharding, more sharding is implemented on NoSQL DBMS such as MongoDB, influx dB. In this study it can be proven that sharding can also be done in relational DBMS such as MariaDB and MySQL, data can be distribute and load process too, test result successful although the performance of time query response is still better single database than distribute database.

Copyrights © 2022






Journal Info

Abbrev

sisfotek

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management Education Electrical & Electronics Engineering

Description

Jurnal Sisfotek Global is a peer-reviewed open access journal published twice a year (March and September), a scientific journal published by Institut Teknologi dan Bisnis Bina Sarana Global. Jurnal Global Sisfotek aims to provide a national forum for researchers and professionals to share their ...