Say I have database1 on server1, database2 on server2, etc. I'd like to set up one server where I can *look* at all of these databases, without modifying them - a read-only aggregator.
What I'd like to do is, have the aggregator have local copies of database1, database2, database3, etc., and replication each one of them from its corresponding master server. Is there a way to replicate databases with different names from different masters to one common slave, or must you run multiple MySQL instances and have each one slave from one master? I'm having a hard time finding this addressed directly in the documentation. That *may* be because it can't be done, but it may also be because it's not a common thing to do and I'm just missing something that would help me figure out how to do it. -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
