Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Teknologi Informasi dan Pendidikan
I Putu Suwidnyana Putra
Politeknik Negeri Bali
Computer Science & IT Control & Systems Engineering Education Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Performance Trade-offs of Synchronous and Asynchronous Replication in Patroni-based PostgreSQL Clusters I Putu Suwidnyana Putra; I Nyoman Gede Arya Astawa; Luh Gede Putri Suardani
Jurnal Teknologi Informasi dan Pendidikan Vol. 19 No. 2 (2026): Jurnal Teknologi Informasi dan Pendidikan
Publisher : Universitas Negeri Padang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24036/jtip.v19i2.1129

Abstract

This research aims to evaluate the effectiveness of High Availability (HA) architectures and analyze the performance trade-offs of database replication modes in critical environments. The study employs an experimental method using a distributed cluster consisting of four virtualized nodes. PostgreSQL is used as the core database, orchestrated by Patroni and Etcd for failover management, with HAProxy as the load balancer. Performance was measured using pgbench with TPC-B standards under varying concurrent loads (10, 50, and 100 clients). The results demonstrate that the Patroni cluster successfully performed auto-failover with an average Recovery Time Objective (RTO) of under 30 seconds in normal conditions, which increased to 75 seconds during peak workloads due to resource contention. Benchmarking reveals that Asynchronous replication achieved a peak throughput of 247 ops/s, while Synchronous replication guaranteed absolute data integrity (RPO=0) but incurred a significant latency increase, reaching 21.36 seconds under a 30-client load due to 99.5% CPU saturation. This study concludes that the proposed architecture effectively eliminates Single Point of Failure (SPOF), providing a critical reference for system architects in balancing transactional speed and data consistency.
Co-Authors I Nyoman Gede Arya Astawa Luh Gede Putri Suardani