PostgreSQL HA Database Clusters through Containment
Presented by:
QUAN-HA LE
Le Quan Ha is a PostgreSQL Database Administrator of IPG Database, BlackBerry Company in Ontario, Canada since 2015. From 2010 until 2015, he was working through Anvy Digital, Canwrx and Hire Ground Software companies for IT Manager on PostgreSQL, over 7 years of PostgreSQL experience. In 2005, he graduated PhD in Queen's University Belfast, UK. From 1999 to 2000, he was a Research Assistant of Queen's University Belfast. Since 2016, Ha is a member of the United States PostgreSQL Association in New York.
No video of the event yet, sorry!
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. High-availability 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 presentation is an attempt to set a benchmark of PostgreSQL high-availability databases in comparing the performance of same-containment keepalived-repmgr 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.
- Date:
- Duration:
- 30 min
- Room:
- Conference:
- PGConf US 2016 [PgConf.US]
- Language:
- Track:
- Use Cases
- Difficulty:
- Medium