Re: Replication by schema

On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch <armin(at)reschab(dot)net> wrote:
> Hi there,
>
> what options do exist to replicate from a master by schema?
>
> What I'm really after is this scenario:
>
> Say, I have 100 databases out in the field. All of them have the same schema
> and are autonomous masters. Now, at a central location, I want to replicate
> from all masters to a central slave (which would have the combined data
> footprint from all masters). Now, if schema-based replication was possible,
> I would configure the slave to replicate the first master's schema 'A' to
> the central slave's schema 'Master01', the second master's schema 'A' to the
> central slave's schema 'Master02', etc.
>
> Making sense? Is there appetite by anyone else for something like that?
> Would there be insurmountable architectural hurdles to make this a built-in
> replication option?

Slony can already do all of this.