Hi
is there any way to have a mysql server slave of more than one master ?
i create programs with PHP that are used intranet.
they access the DB locally, and a replication system makes the update to an internet mysql server, so when people goes to the site, the read from the slave and write to the master (if master is available).
the problem is that i have more than one application of this type.
and each has its own database to replicate on the same internet server.
is there any way for me to say that database1 must be replicated from server1, database2 from server2, and so on ?
Thanks
Regards