PostgreSQL Cookbook by Chauhan Chitij;
Author:Chauhan, Chitij;
Language: eng
Format: epub
Publisher: Packt Publishing
Chapter 7. High Availability and Replication
In this chapter, we will cover the following recipes:
Setting up hot streaming replication
Replication using Slony-I
Replication using Londiste
Replication using Bucardo
Replication using DRBD
Setting up the Postgres-XC cluster
Introduction
The important components for any production database is to achieve fault tolerance, 24/7 availability, and redundancy. It is for this purpose that we have different high availability and replication solutions available for PostgreSQL.
From a business perspective, it is important to ensure 24/7 data availability in the event of a disaster situation or a database crash due to disk or hardware failure. In such situations, it becomes critical to ensure that a duplicate copy of the data is available on a different server or a different database, so that seamless failover can be achieved even when the primary server/database is unavailable.
In this chapter, we will talk about various high availability and replication solutions, including some popular third-party replication tools such as Slony-I, Londiste, and Bucardo. We will also discuss block-level replication using DRBD, and finally, set up a PostgreSQL extensible cluster, that is, Postgres-XC.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
What's Done in Darkness by Kayla Perrin(25493)
Shot Through the Heart: DI Grace Fisher 2 by Isabelle Grey(18209)
Shot Through the Heart by Mercy Celeste(18153)
The Fifty Shades Trilogy & Grey by E L James(17768)
The 3rd Cycle of the Betrayed Series Collection: Extremely Controversial Historical Thrillers (Betrayed Series Boxed set) by McCray Carolyn(13182)
The Subtle Art of Not Giving a F*ck by Mark Manson(12898)
Scorched Earth by Nick Kyme(11823)
Stepbrother Stories 2 - 21 Taboo Story Collection (Brother Sister Stepbrother Stepsister Taboo Pseudo Incest Family Virgin Creampie Pregnant Forced Pregnancy Breeding) by Roxi Harding(11019)
Drei Generationen auf dem Jakobsweg by Stein Pia(10211)
Suna by Ziefle Pia(10179)
Scythe by Neal Shusterman(9251)
International Relations from the Global South; Worlds of Difference; First Edition by Arlene B. Tickner & Karen Smith(8600)
Successful Proposal Strategies for Small Businesses: Using Knowledge Management ot Win Govenment, Private Sector, and International Contracts 3rd Edition by Robert Frey(8407)
This is Going to Hurt by Adam Kay(7682)
Dirty Filthy Fix: A Fixed Trilogy Novella by Laurelin Paige(6445)
He Loves Me...KNOT by RC Boldt(5798)
How to Make Love to a Negro Without Getting Tired by Dany LaFerrière(5369)
Interdimensional Brothel by F4U(5299)
Thankful For Her by Alexa Riley(5149)