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

PostgreSQL HA

Avatar for bjreath bjreath
November 21, 2012
Programming
0
220

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
「抽象に依存せよ」が分からなかった新卒1年目の私が Goのインターフェースと和解するまで
Avatar for Genki-Miyakawa kurogenki
0
110
どんと来い、データベース信頼性エンジニアリング / Introduction to DBRE
Avatar for nnaka2992 nnaka2992
1
270
Go1.26 go fixをプロダクトに適用して困ったこと
Avatar for Hiroki Kurasawa kurakura0916
0
360
The Ralph Wiggum Loop: First Principles of Autonomous Development
Avatar for Ryuichiro Semba sembayui
0
3.7k
nilとは何か 〜interfaceの構造とnil!=nilから理解する〜
Avatar for kuro kuro_kurorrr
3
1.9k
Fundamentals of Software Engineering In the Age of AI
Avatar for Dan Vega therealdanvega
1
240
メタプログラミングで実現する「コードを仕様にする」仕組み/nikkei-tech-talk43
Avatar for 日本経済新聞社 エンジニア採用事務局 nikkei_engineer_recruiting
0
170
What Spring Developers Should Know About Jakarta EE
Avatar for ivargrimstad ivargrimstad
0
390
Claude Code の Skill で複雑な既存仕様をすっきり整理しよう
Avatar for yuichiro_takahashi yuichirokato
1
360
Windows on Ryzen and I
Avatar for 瀬尾佳隆 seosoft
0
250
文字コードの話
Avatar for Masaki Hara qnighy
44
17k
Railsの気持ちを考えながらコントローラとビューを整頓する/tidying-rails-controllers-and-views-as-rails-think
Avatar for MOROHASHI Kyosuke moro
5
390

Featured

See All Featured
svc-hook: hooking system calls on ARM64 by binary rewriting
Avatar for Akira Moroo retrage
2
160
Jamie Indigo - Trashchat’s Guide to Black Boxes: Technical SEO Tactics for LLMs
Avatar for Tech SEO Connect techseoconnect
PRO
0
82
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
141
7.4k
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
0
440
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
6k
Put a Button on it: Removing Barriers to Going Fast.
Avatar for kastner kastner
60
4.2k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
174
15k
Leo the Paperboy
Avatar for Maya Tellez mayatellez
4
1.5k
Paper Plane (Part 1)
Avatar for Katie Cordina Lindsey katiecoart
PRO
0
5.5k
The #1 spot is gone: here's how to win anyway
Avatar for Tamara Novitovic tamaranovitovic
2
980
Why Your Marketing Sucks and What You Can Do About It - Sophie Logan
Avatar for Sophie Logan marketingsoph
0
110
Building the Perfect Custom Keyboard
Avatar for Naoto Takai takai
2
710

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