Philippe Ferreira phil.f
Tue Nov 1 17:46:10 PST 2005
>A way around this "explosion" of replication management would be to
>join databases together.
>
>Rather than having 50 databases, each with one schema/namespace, you
>might put them into one database with 50 schemas/namespaces.  That
>would not require many clusters/slon processes.
>  
>

Hi Chistopher,

My goal was to isolate to the maximum each database, for :
  - security (because these database are for public web sites, and 
should be isolated from each other)
  - error tolerance/independance (to not put all my eggs in the same 
basket, or "in the same cluster" !)
  - scalability (for example, if I want to migrate *one* database from 
one server to another...)

Is it possible to achieve this with several schemas/namespaces into one 
only big database ?


Thank you,
Philippe Ferreira.


More information about the Slony1-general mailing list