Thread: Replication by schema
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?
Rgds,
-ar
On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch <armin@reschab.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.
On Wed, Feb 16, 2011 at 1:33 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote: > On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch <armin@reschab.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. OK, it can't change schemas, but if you named them something unique in both places it will work.