Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

In other words, can I have a single central database, that gets data from remote databases, but that does not know which remote databases exist until data from the remote database arrives?

This does not sound like "replication" to me. Is there another term I should use for this, or is it a type of replication?

share|improve this question

2 Answers 2

No. replicate-do-db specifies the databases to be replicated.

However, I'd say the performance you're describing is better aligned with "clustering." You might take a look at MySQL cluster (the NDB engine), as it may meet part of your expectations.

share|improve this answer
    
Thanks. As you could tell by the wording of the question, I strongly suspected this was not feasible. Is there a specific name for what I want to do? –  MJB May 10 '10 at 0:39
    
Take a look at my update. –  Warner May 10 '10 at 1:03
    
I looked at your update and don't understand it. It appears that clustering is intended to decrease downtime and improve redundancy. In this case, to add a new site, it seems you need to modify config files and reboot the whole cluster. I don't think that will be acceptable, since I could have many remote databases that will need to sync, and would not want to have to reboot repeatedly. It seems that if I want to allow updates from unexpected sites (with proper authentication somehow), I will have to roll my own. Or did I miss something? –  MJB May 10 '10 at 14:09

No. MySQL replication is one-to-many. A slave can only replicate from one master database, but a master can replicate to many slaves.

To do what you want, you will have to craft your own solution on top of MySQL.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.