Ignoramus32732 <ignoramus32732@NOSPAM.32732.invalid> wrote:

> Let's say that I have two servers, server M with database "foo" and
> server S with database "bar", with full control over them. Can I set
> up replication so that "foo" is replicated into "bar".

There is limited support for that by using the --replicate-rewrite-db
option on the slave. For details, see:

http://dev.mysql.com/doc/refman/5.0/...n-options.html


> (the issue is that I have many masters with the same database name foo,
> and I want to have one slave server with databases like foo-1, foo-2
> etc, replicated from all those masters)

This is impossible. A replication slave can listen to one single
master only.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/