Author Archives: Taufik Mulyadi

Comparing Modern SQL Databases: PostgreSQL vs MySQL vs OceanBase and Beyond

1. Introduction In today’s data-driven landscape, choosing the right database system can significantly impact application performance, scalability, and maintainability. Whether you are building a small web application, a financial system, or a globally distributed service, the database plays a central … Read More

Designing a Highly Available PostgreSQL Architecture Using HAProxy, Patroni, and etcd

Background In modern applications, database availability is critical. Downtime means not just a loss in revenue but also user trust. This article outlines our journey in designing a highly available PostgreSQL architecture using: – 5 PostgreSQL nodes (1 leader + … Read More