Panjaitan, Ade Rizky (2025) PEMBUATAN PENGUJIAN KINERJA DATABASE STANDAR TPC-H MENGGUNAKAN APACHE JMETER DENGAN ARSITEKTUR REPLIKASI PGPOOL-II. Project Report (Praktek Kerja Lapang dan Magang). UPN Veteran Jawa Timur.
![[img]](https://repository.upnjatim.ac.id/style/images/fileicons/text.png) |
Text (Cover)
22081010091-cover.pdf Download (506kB) |
|
Text (Bab 1)
22081010091-bab1.pdf Download (146kB) |
|
Text (Bab 2)
22081010091-bab2.pdf Download (242kB) |
|
Text (Bab 3)
22081010091-bab3.pdf Restricted to Repository staff only until 15 July 2028. Download (1MB) |
|
Text (Bab 4)
22081010091-bab4.pdf Restricted to Repository staff only until 15 July 2028. Download (1MB) |
|
Text (Bab 5)
22081010091-bab5.pdf Restricted to Repository staff only until 15 July 2028. Download (130kB) |
|
Text (Daftar Pustaka)
22081010091-daftarpustaka.pdf Download (124kB) |
|
Text (Lampiran)
22081010091-lampiran.pdf Restricted to Repository staff only Download (256kB) |
Abstract
The implementation of the Internship Program (PKL) at PT Tri UsahaBerkat is part of a student competency development initiative aimed at addressingreal-world challenges in the field of information technology. The project, titled“Performance Testing of TPC-H Standard Database Using Apache JMeter withPgpool-II Replication Architecture,” primarily aims to evaluate the performanceof a PostgreSQL database system under heavy workloads and to implement areplication scheme that ensures system stability and availability. The project implementation methods include installing the Ubuntu 22.04LTS operating system, setting up and configuring PostgreSQL 14, and deployingPgpool-II middleware to support features such as connection pooling, loadbalancing, automatic failover, and watchdog. The dataset was generated usingDBGEN based on the TPC-H schema. Testing was conducted using ApacheJMeter with a Test Plan structure consisting of Thread Groups, TransactionControllers, PreProcessors (JSR223), and JDBC Requests to execute the 22standard TPC-H queries. Each test scenario was designed to be deterministic yet realistic by utilizing parameterization and random seeds. The internship results show that the system successfully executedall queries with stable performance and supported automatic failover. In additiontotechnical outcomes, the project also enhanced professional skills suchasdocumentation, virtual collaboration, and time management, making it a valuablefoundation for a career in information systems and database architecture.
| Item Type: | Monograph (Project Report (Praktek Kerja Lapang dan Magang)) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Contributors: |
|
||||||||
| Subjects: | T Technology > TK Electrical engineering. Electronics Nuclear engineering > TK5105 Computer Network T Technology > TK Electrical engineering. Electronics Nuclear engineering > TK5105.882 Internet |
||||||||
| Divisions: | Faculty of Computer Science > Departemen of Informatics | ||||||||
| Depositing User: | Ade Rizky Panjaitan | ||||||||
| Date Deposited: | 07 Sep 2026 02:14 | ||||||||
| Last Modified: | 07 Sep 2026 02:14 | ||||||||
| URI: | https://repository.upnjatim.ac.id/id/eprint/59889 |
Actions (login required)
 |
View Item |