cid 28f3f99b225182f5edad9e0a6edcfc5619b396c8dfb0efad82b05c10a97a4b25 · original · open access · via openalex
Title: Comparative Performance Analysis of PostgreSQL High Availability Database Clusters through Containment Authors: Le Quan Ha; Jeff Xie; Darrell Millington; Amgad Waniss Venue: IJARCCE Year: 2015 Canonical: doi:10.17148/ijarcce.2015.412150 URL: https://doi.org/10.17148/ijarcce.2015.412150 Collector: openalex OA: true ABSTRACT The enormous amount of data flow has made Relation Database Management System the most important and popular tools for persistence of data.While open-source RDBMS systems are not as widely used as proprietary systems like Oracle databases, but over the years, systems like PostgreSQL have gained massive popularity.Highavailability database clusters (also known as HA clusters or failover clusters) are groups of computers that support server applications that can be reliably utilized with a minimum of down-time.This article is an attempt to set a benchmark of PostgreSQL high-availability databases in comparing the performance of same-containment keepalivedrepmgr clusters against cross-containment HAProxy-PgBouncer clusters.The result shows that our cross-containment HAProxy-PgBouncer is still a significantly better performer with load balancing, healthcheck and its throughputs are improved from 0.346% to 9.454% in compared to keepalived-repmgr.Also we would like to present I/O activities and CPU usage percentages between the two kinds of PostgreSQL HA clusters.