Hello,
I'm experienced PHP developer and have experience building scripts to do MySQL synchronizing or tables transfers. I'll make a cron job to do the required task and will make an admin interface to select source database, then choose tables then select target servers. Additionally I'll implement the ability to filter by any field in the table.
I have just once question and I hope it is not too much reading for you.
How will the target servers info. be entered at first. I have several ideas that we can implement one depending on your preferences. First is to have a predefined list in configuration file and you select from them with checkboxes , second idea is to write them down by your self each time you need to reset in text boxes. Last idea which I personally prefer is to allow you either to write down a new server or choose a server from the servers previously used.
Thanks,
John