Dual Master

[Tobin Harris]

Hi there,

I posted a message about a week ago, but I'm guessing it wasn't very clear since I didn't get a response. So, I'll try and be clearer 8-)

Is it possible to have 2 master servers, where each server is responsible for a set of tables?

For example, Server A might "own" tables T1, T2 and T3. Updates to these tables are made on Server A and should propogate to Server B.

Server B owns tables T4 and T5, and updates to these tables should propogate from Server B to Server A.

What is the topology here with regard to setting things up? Would we need to set up both servers as a slave *and* a master? Would we then use the "replicate-do-db" and "replicate-do-table" settings to indicate which server should propogate changes to which tables?

Any feedback welcome.

Thanks

Tobin