[prev] 71 [next]

PostgreSQL and Parallelism (cont)

High availability ...
  • updates occur on master, recorded in tx log
  • tx logs shipped/streamed from master to slave(s)
  • slave uses tx logs to maintain current state
  • configuration controls frequency of log shipping
  • bringing slave up-to-date is "fast" (~1-2secs)

    Note: small window for data loss (committed tx log records not sent)

    Load balancing ...

    • not provided built-in to PostgreSQL, 3rd-party tools exist