rubing Posted July 15, 2008 Share Posted July 15, 2008 How do I synchronize between a local and remote table. Remote tables would be on partner sites who agree to use my service. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 15, 2008 Share Posted July 15, 2008 You mean like replication? Quote Link to comment Share on other sites More sharing options...
rubing Posted July 15, 2008 Author Share Posted July 15, 2008 I guess. Is it easy to implement between tables on different servers? Quote Link to comment Share on other sites More sharing options...
rubing Posted July 16, 2008 Author Share Posted July 16, 2008 How difficult would it be to transfer my data as a backup (e.g.): mysqldump --host=remote_ip_address Would the remote site's firewall prohibit this? Quote Link to comment Share on other sites More sharing options...
fenway Posted July 16, 2008 Share Posted July 16, 2008 The mysql site has plenty of dev articles on this subject. As for remote IPs, yes, you have to make sure you can connect non-localhost on the given port. Quote Link to comment Share on other sites More sharing options...
rubing Posted July 16, 2008 Author Share Posted July 16, 2008 Afiliate sites will not give me that access. I guess I'll just set them up with a php script that accepts my POST variables. And then report back a success message to my server. Do you know how php can obtain this success message? I've seen it on phpMyadmin. Or would I just check to see that there were no errrors? thx again fenway! Quote Link to comment Share on other sites More sharing options...
fenway Posted July 16, 2008 Share Posted July 16, 2008 No idea about the php stuff. Quote Link to comment Share on other sites More sharing options...
lampstax Posted July 18, 2008 Share Posted July 18, 2008 What about federated tables ? Its meant for this kind of stuff. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 What about federated tables ? Its meant for this kind of stuff. Yeah, but they're leaving federated in/out of certain production builds, so you have to be careful. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.