课程概览

此培训专为希望学习Postgre SQL流复制以及如何使用pgpool-II实现自动故障转移和设置高可用性Postgre SQL Database群集的Database管理员和架构师而设计。

课程大纲

· Introduction

· Streaming Replication

o Streaming Replication

o Sync or Async

o Cascaded Replication

o Transaction Log Archiving 

o Base Backups

o Setup Streaming

o Monitoring Streaming

o Handling Conflicts

· High Availability Setup

o Connection Pooling and HA setup using pgpool-II

§ Installation

§ Configuration

§ Pool Setup

§ HA Setup

o Demos and Labs