Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
PostgreSQL HA
Search
bjreath
November 21, 2012
Programming
220
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
PostgreSQL HA
bjreath
November 21, 2012
Transcript
7 slides
PostgreSQL Log Shipping Brian Reath CCI Systems, Inc. Wednesday, November
21, 12
HA Techniques • Shared Disk • File System Replication (DRBD)
• Transaction Log Shipping (WAL) Wednesday, November 21, 12
Log Shipping • Master - continuous archive mode • Slave(s)
- continuous recovery mode • warm standby • File-based versus streaming Wednesday, November 21, 12
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
Node Promotion • pg_ctl promote • Virtual IPs • Heartbeat
/ Pacemaker • keepalived Wednesday, November 21, 12
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
References • PostgreSQL 9.2 Docs • Backup and Restore •
High Availability, Load Balancing, and Replication Wednesday, November 21, 12
More Decks by bjreath
See All by bjreath
Object-Oriented Design
bjreath
2
150
The Rails View
bjreath
1
140
Other Decks in Programming
See All in Programming
baseline으로 마이그레이션, 리팩토링 안전하게 맡기기
fornewid
1
1.1k
複数ドメインを一つのアプリに統合するFlutterの設計と運用_FlutterKaigi2026登壇資料(須永高弘)
takahirosunaga
0
210
Engineering Biometric UX Across Android Versions | DroidKnights 2026
ryunen344
1
220
Kotlin Fest 2026: Kotlin コンパイラに Contribute してみよう! - Kotlin/Wasm で深い再帰を書けるようにした話
ternbusty
1
420
クラウドエージェントは、 何がそんなに便利なのか / what makes cloud agents so useful
rkaga
5
980
動画プレイヤーはなぜカクつくのか 〜Flutterのレンダリングとネイティブの境界を解剖する〜
naruogram
0
340
Getting Started with Vibe Coding
miccheng
0
250
SODA - FACT BOOK(JP)
sodainc
1
40k
地方こそサーバーレス — 10年続けた、顔が見えるチームで確かな基盤を / Serverless Matters Most in Regional Areas — 10 Years of Building Reliable Foundations with Close-Knit Teams
seike460
PRO
2
510
JavaScriptはシングルバイナリの夢を見るか / Does JavaScript Dream of a Single Binary?
ssssota
0
130
エラーチャンネルのボールを拾い続けて鍛えるエンジニアの地力 / phpcon-niigata2026
meihei3
1
500
Growing PicoRuby's Ecosystem on ESP32
yuuu
2
150
Featured
See All Featured
Highjacked: Video Game Concept Design
rkendrick25
PRO
2
590
Gemini Prompt Engineering: Practical Techniques for Tangible AI Outcomes
mfonobong
2
650
Fashionably flexible responsive web design (full day workshop)
malarkey
409
67k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
250
1.3M
Effective software design: The role of men in debugging patriarchy in IT @ Voxxed Days AMS
baasie
1
630
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
chikuwait
0
970
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
230
23k
Designing Powerful Visuals for Engaging Learning
tmiket
1
660
Collaborative Software Design: How to facilitate domain modelling decisions
baasie
1
390
Color Theory Basics | Prateek | Gurzu
gurzu
1
530
Getting science done with accelerated Python computing platforms
jacobtomlinson
2
580
Code Review Best Practice
trishagee
74
20k