patternsqlMinor
Creating High Availability Cluster with PostgreSQL
Viewed 0 times
postgresqlcreatingwithhighavailabilitycluster
Problem
I am new to database design. I have a task to create a high-availability cluster. I Googled a lot, however I haven't found any good way to do this on PostgreSQL.
Where should I start and what are the steps involved in creating a high-availability cluster?
Where should I start and what are the steps involved in creating a high-availability cluster?
Solution
There are many ways to set up an HA cluster for PostgreSQL. Some ways are big and tough.
The easiest method is the following:
This method is the easiest method to build a HA cluster with graceful degradation .
The easiest method is the following:
- sync your db to a standby server
- Install heartbeat and do a asymmetric clustering
This method is the easiest method to build a HA cluster with graceful degradation .
Context
StackExchange Database Administrators Q#27121, answer score: 2
Revisions (0)
No revisions yet.