Upgrade to Pro — share decks privately, control downloads, hide ads and more …

PostgreSQL HA

Avatar for bjreath bjreath
November 21, 2012
Programming
0
210

PostgreSQL HA

Avatar for bjreath

bjreath

November 21, 2012
Tweet

More Decks by bjreath

See All by bjreath
Object-Oriented Design
Avatar for bjreath bjreath
2
140
The Rails View
Avatar for bjreath bjreath
1
130

Other Decks in Programming

See All in Programming
大規模アプリのDIフレームワーク刷新戦略 ～過去最大規模の並行開発を止めずにアプリ全体に導入するまで～
Avatar for GO Inc. dev mot_techtalk
0
210
(Extension DC 2025) Actor境界を越える技術
Avatar for Himeshi teamhimeh
1
100
iOSアプリの信頼性を向上させる取り組み/ios-app-improve-reliability
Avatar for yuki shinohara shino8rayu9
0
120
Conquering Massive Traffic Spikes in Ruby Applications with Pitchfork
Avatar for Shia riseshia
0
130
ABEMAモバイルアプリが
Kotlin Multiplatformと歩んだ5年 ─ 導入と運用、成功と課題 / iOSDC 2025
Avatar for Akio Yasui akkyie
0
300
Swift Concurrency - 状態監視の罠
Avatar for Yuki Yasoshima objectiveaudio
2
280
uniqueパッケージの内部実装を支えるweak pointerの話
Avatar for magavel magavel
0
820
ポスターセッション: 「まっすぐ行って、右！」って言ってラズパイカーを動かしたい 〜生成AI × Raspberry Pi Pico × Gradioの試作メモ〜
Avatar for komo_fr komofr
0
810
Чего вы не знали о строках в Python – Василий Рябов, PythoNN
Avatar for Sobolev Nikita sobolevn
0
150
Serena MCPのすすめ
Avatar for wadakatu wadakatu
4
820
高度なUI/UXこそHotwireで作ろう Kaigi on Rails 2025
Avatar for Naofumi Kagami naofumi
4
2.5k
Web Components で実現する Hotwire とフロントエンドフレームワークの橋渡し / Bridging with Web Components
Avatar for Daichi KUDO da1chi
2
1.3k

Featured

See All Featured
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
28
4k
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
697
190k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
Avatar for Tammy Everts tammyeverts
8
560
What's in a price? How to price your products and services
Avatar for Michael Herold michaelherold
246
12k
Measuring & Analyzing Core Web Vitals
Avatar for Philip Tellis bluesmoon
9
600
Making the Leap to Tech Lead
Avatar for Ryan Cromwell cromwellryan
135
9.5k
Gamification - CAS2011
Avatar for David Bonilla davidbonilla
81
5.4k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
248
1.3M
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
237
140k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
36
6.9k
Easily Structure & Communicate Ideas using Wireframe
Avatar for Afnizar Nur Ghifari afnizarnur
194
16k
Building an army of robots
Avatar for Kyle Neath kneath
306
46k

Transcript

  1. PostgreSQL Log Shipping Brian Reath CCI Systems, Inc. Wednesday, November

    21, 12

  2. HA Techniques • Shared Disk • File System Replication (DRBD)

    • Transaction Log Shipping (WAL) Wednesday, November 21, 12

  3. Log Shipping • Master - continuous archive mode • Slave(s)

    - continuous recovery mode • warm standby • File-based versus streaming Wednesday, November 21, 12

  4. Hot Standby • Allows standby servers to service read queries

    • Useful for distributing read load across database servers • Asynchronous behavior may cause inconsistency across nodes Wednesday, November 21, 12

  5. Node Promotion • pg_ctl promote • Virtual IPs • Heartbeat

    / Pacemaker • keepalived Wednesday, November 21, 12

  6. Master-Slave with Rails • Master services all reads & writes

    • Master writes & slaves read • Octopus gem • Round-robin read query assignment • Introduces complexities Wednesday, November 21, 12

  7. References • PostgreSQL 9.2 Docs • Backup and Restore •

    High Availability, Load Balancing, and Replication Wednesday, November 21, 12