The Development of High Availability Database Infrastructure for OSS Projects with Monitoring Systems in Cloud Computing Environments

Akmal Ikhsan (Telkom University)
Dana Kusumo (Telkom University)

IJoICT (International Journal on Information and Communication Technology)
Vol. 9 No. 2 (2023): Vol.9 No. 2 Dec 2023

This study addressed a critical problem in the Kominfo's Operation Support System (OSS) project, which significantly impacted business operations. The outage of the MongoDB database, a vital component of OSS, resulted in server crashes and data damage. To overcome this issue, the OSS team initiated a project to migrate to PostgreSQL for high availability and improved database performance. The implementation involved the use of HA PostgreSQL technology, with multiple connected servers sharing data in real-time. Through functional and performance testing, the study has demonstrated that the HA PostgreSQL system increased database availability, managed server failures, and facilitated effective cluster administration. The findings of this research can guide the development of the OSS project's IT infrastructure and serve as a reference for similar projects utilizing HA PostgreSQL technology.