2 masters send diff dbs --> many ro slaves

[Erin ONeill]

Hey all -
I have a master database that replicates a number of databases to a number of slaves. The slaves are all read only. Master is primarily write only (some reads). This has been working great (4.1.18).

Now we are trying to merge two apps into one. This will be done in stages. On another legacy server there is a standard read/write mysql instance (4.1.14 can be upgraded). My new app needs to be able to read a database from that host that is combined with the data from the slaves.

The app could do all the selects on the slaves and have access to the data from both masters.

is it possible? I've got a week to find an answer! Then I'll have to add the other legacy server's data over to the slaves! so I'll end up with 3 masters and 3 slaves. Each master will replicate different databases.

Is this doable with 4.1.18?

thanks,
erin