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