Can a server be both Master and Slave ?

[Claudio Paganelli]

Hi All,

I'm trying to figure out if I can set-up a server as Master for DB1 and Slave for DB2.

Let me explain my scenario:

1) I have a server1 which contains DB2 with data that need to be spread in all over.
2) I have a server2 which contains DB1 with data that need to be transfer to a central 'read-only' DB (wich resides in a collecting server3).

now this is what I got:

1) server2 is the SLAVE of server1.
2) server2 is the MASTER of server3.

Is it possible ? How do I set-up the server-id in server2 ?

Many thanks,