I'm researching a specific network design and have some questions that may involve 2-way replication.
I have one master mysql server doing 1 way replication to a large number of remotely located slaves. Each slave serves a number of proprietary software clients running inside a private network. These proprietary software clients do not have Internet access but of course the local slave does. These proprietary software clients enter data into 2 tables on the local slave. We now have the need to get these remote slaves to send the data in these 2 tables back to the master and merge it in 2 central tables. The amount of data that needs to be sent back is not terribly large and only needs to happen maybe once or twice a day. What is the most logical and efficient way to accomplish this? Is 2-way replication a candidate here with the master server also acting as a slave to each of the remote slaves? I was under the initial impression that any slave can only have one master and if so it would seem that 2 way replication would only work with 2 servers. What method would work if I had 1 master with 100 slaves and each of these slaves needed to merge 2 tables back into the single master? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
