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".

(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)

i

On 14 Aug, 22:55, Ignoramus32732 <ignoramus32...@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".
>
> (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)
>
> i

If you serach in mySQL handbook there is a artikel how to do it,, with
mySQL 5 and above

15.4. How to Set Up Replication
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

// Anders

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/en/replication-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/