Meetings:2006-04

From GTALUG

Date

Tuesday April 11, 2006

Time

7:30 pm

Special Feature

We'll also be having a short talk on TCCP, a non-profit colocation project in the GTA.

Main Topic

Slony-I Replication for PostgreSQL

Speakers

Christopher Browne

Description

Slony-I is an asynchronous replication system for PostgreSQL supporting multiple replicas "fed" by a single master. Special capabilities include the ability to shift the master node (to support maintenance), to abandon the master in favor of a replica in case of failure, as well as to add additional replica nodes.

Essential topics covered include:

  • What is Slony-I?
  • What are the sorts of use cases where it works well? Where is its use contraindicated?
  • How Slony-I works
  • Slony-I Concepts - Clusters, Nodes, Replication Sets
  • Installing Slony-I
  • Configuring a first Slony-I Node
  • Adding Nodes to a Cluster
  • Adding Tables to a Cluster
  • Manipulating Replication Sets
  • Failover and Moving Set Origins

Copy of presentation available at TechDocs site

Location 

   Room GB244, Galbraith Building, University of Toronto
   Toronto, Ontario M5S 3G8 
   University of Toronto

Map

http://oracle.osm.utoronto.ca/map/ http://maps.google.ca/maps?q=35+St+George+St,+Toronto,+ON&hl=en

Retrieved from "http://tlug.ss.org/wiki/Meetings:2006-04"
Customize