Jason Flatt jason
Mon Sep 6 20:44:44 PDT 2004
Hello folks.

I've got a couple of general newbie questions regarding Slony-I and 
replication.  I understand the basics of replication (from what I've read 
this weekend) and I've read through some of the Slony-I docs on the GBorg Web 
site, but I still have questions that I did not see answered in the docs.

1.  In the overview doc, there is the phrase, "...a reasonably limited number 
of slave systems."  Does that mean 1 or 2, or 10, or 100...  Is there some 
number that "reasonably limited" correlates to?

2.  In thinking about the previous question, another came to mind, WRT 
distances.  Are there "reasonably limited" distances as well.  Should the 
different systems be in the same room, building, city, country?

I realize that for both the previous questions, if I want any sort of speed, 
the smaller the number and the smaller the distance the better, but what 
about in terms of Slony-I/PostgreSQL's capabilities?

3.  I understand that Slony-I is a "master-slave system", where the slaves are 
read-only.  Is there some sort of mechanism for allowing a user who is 
viewing a slave database to be redirected to the master if they need to make 
edits?

-- 
Jason Flatt (jason @ flattfamily . com)
Father of five (http://www.flattfamily.com/)
Linux user (http://www.sourcemage.org/)
IRC Nick: Oadae  Channels: #sourcemage, #lvlug  Server: irc.freenode.net

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCS/IT d(-) s+:- a>++++ C++$(+++) UL++++ P(+) L+++ E- W++ N+@ o? K? w-- O? 
M-- V PS- PE+ Y+ PGP@ t 5+ X R tv--() b+@ DI+@ D+++ G e h---- r+++ y++++
------END GEEK CODE BLOCK------


More information about the Slony1-general mailing list