PGCon2016 - 20180510
PGCon 2016
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Sean Chittenden |
| Schedule | |
|---|---|
| Day | Talks - Day 1 - 2016-05-19 |
| Room | DMS 1160 |
| Start time | 15:00 |
| Duration | 00:45 |
| Info | |
| 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.