High Availability with Postgres Plus Advanced Server

High Availability with Postgres Plus Advanced Server
An EnterpriseDB White Paper
For DBAs, Database Architects & IT Directors December 2013

Table of Contents
Introduction 3
Active/Passive Clustering 4
Standby Database 6
Replication 7
The Critical Link: EDB Failover Manager 8
Choosing an HA System Design 10
Conclusion 11
About EnterpriseDB 12
© 2013 EnterpriseDB Corporation. All rights reserved.

Introduction
High Availability (HA) refers to an overall system design for achieving a pre-arranged Service Level Agreement (SLA) and is defined by some number of 9’s referring to a percentage of uptime. For example, a system designed to be available to its users 99 percent of a calendar year has two 9’s of availability. A system with five 9’s of High Availability means the system is down, due to disruptions or service updates, no more than 5.26 minutes per year so that it’s available 99.999 percent of a calendar year.
When referring to High Availability for any database server, it is important to understand that this refers to the uptime of the overall system, and not just the database server. The database server, for example, cannot be more available than the hardware it runs on or the datacenter where the system resides.

DOWNLOAD WHITE PAPER (.PDF):Whitepapers_High_Availability_with_Postgres_Plus_Advanced_Server