Implementasi External Table Cache Berbasis Redis pada MySQL Database Menggunakan Karakteristik Operasi Read pada Moodle Learning Management System

Rachmadi, Aurelia Fairuz (2022) Implementasi External Table Cache Berbasis Redis pada MySQL Database Menggunakan Karakteristik Operasi Read pada Moodle Learning Management System. Other thesis, Institut Teknologi Sepuluh Nopember.

[thumbnail of 05111740000141_Undergraduate_Thesis.pdf] Text
05111740000141_Undergraduate_Thesis.pdf - Accepted Version
Restricted to Repository staff only until 1 April 2024.

Download (17MB) | Request a copy

Abstract

Platform pembelajaran moodle menjadi salah satu software
berbasis web yang banyak digunakan di berbagai universitas
termasuk di Institut Teknologi Sepuluh Nopember, yaitu aplikasi myITS Classroom yang merupakan platform perkuliahan
mahasiswanya. Platform moodle ini memiliki karakteristik
dalam tiap operasinya banyak terjadi proses write sehingga
operasi read dan write bercampur menyebabkan CPU terkadang
menjadi terbebani oleh process lock.
Untuk mencoba menyelesaikan permasalahan dalam platform moodle tersebut, digunakan Redis yang berperan sebagai external table cache yang digunakan untuk memisahkan operasi read dan write pada moodle. Beberapa operasi read akan di cache ke dalam Redis dengan beberapa pengecualian pada data yang dinamis pada sistem moodle. Sehingga nantinya operasi read dan write akan dibedakan, dimana operasi read pada moodle terutama query yang repetitif akan mengambil data dari cache Redis alih-alih ke database. Sedangkan operasi write akan tetap mengarah langsung ke database. Dengan demikian server tidak terbebani oleh proses lock akibat banyaknya proses write dan read pada database.
Dari hasil uji coba, pengimplementasian pemisahan operasi read dan write menggunakan Redis ini dapat membagi akses sumber data yang menggunakan operasi read ke database dan ke redis.
================================================================================================
The Moodle learning platform is one of the web-based software that is widely used in various universities, including at the Sepuluh Nopember Institute of Technology, namely the myITS Classroom which is their learning platform. This Moodle platform has characteristics that in each operation there are many write processes so that read and write operations are mixed causing the CPU to sometimes become burdened by process locks.
To try to solve the problem in the Moodle platform, Redis is used which acts as an external table cache which is used to separate read and write operations on Moodle. Some read operations are cached into Redis with the exception of dynamic data on the Moodle system.
So that later the read and write operations will be distinguished, where read operations on moodle, especially repetitive queries, will retrieve data from the Redis cache instead of the database. While the write operation will still directly goes to the database. Thus the server is not burdened by the lock process due to the many write and read processes in the database.
From the test results, implementing the separation of read and write operations using Redis can divide access data sources that use read operations to the database and to redis.

Item Type: Thesis (Other)
Uncontrolled Keywords: Redis, Moodle, Learning Management System
Subjects: T Technology > T Technology (General) > T57.5 Data Processing
T Technology > T Technology (General) > T58.6 Management information systems
T Technology > T Technology (General) > T58.8 Productivity. Efficiency
Divisions: Faculty of Intelligent Electrical and Informatics Technology (ELECTICS) > Informatics Engineering > 55201-(S1) Undergraduate Thesis
Depositing User: Aurelia Fairuz Rachmadi
Date Deposited: 28 Jan 2022 04:40
Last Modified: 02 Nov 2022 00:51
URI: http://repository.its.ac.id/id/eprint/92542

Actions (login required)

View Item View Item