PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Sean Chittenden
Day Talks - Day 1 - 2016-05-19
Room DMS 1160
Start time 15:00
Duration 00:45
ID 974
Event type Lecture
Track Scaling Out
Language used for presentation English

PostgreSQL High-Availability and Geographic Locality using consul...

The website may be down, but the database is not.

Virtual IPs or floating IPs have long been the workhorse mechanism for providing high-availability for database systems, however floating IP addresses have several limitations that make it problematic in modern data centers and cloud environments, notably that it requires all members be in the same Layer-2 domain. consul is a strongly consistent way of providing high-availability services in Layer-3 environments and provides fail-over across different geographic regions. In this talk we will discuss the benefits, setup, and use of consul for fail-over of PostgreSQL, both in a local data center scenario and a geographic redundancy scenario where databases are split across multiple data centers.

Provide an introduction and setup for consul as the means of providing highly available PostgreSQL in local and geographically disparate data centers or cloud providers. This talk will include:

) Introduction to consul and its architecture ) Setup of a single consul cluster ) Setup for a few sample database instances (OLAP and OLTP) ) Firewall requirements ) Integration with bind, djbdns, and dnsmasq ) Setup geographic failover to two different data centers and cloud providers ) Various Best Practices tips and suggestions ) Q&A

Ideally this talk will be completed as a live-demo, either local in VMs, or remote in the cloud. All material will include configuration snippets in the slides for use by administrators.