sagnik Posted February 4, 2018 Share Posted February 4, 2018 I'm trying to synchronize all of the databases in the local mysql server (localhost) with remote server (tommy.heliohost.org). I don't know anything about replication but I need to synchronize both servers when their data changes. Quote Link to comment Share on other sites More sharing options...
Krydos Posted February 4, 2018 Share Posted February 4, 2018 Why not just set up remote mysql, and then you can use the same database for both? Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted February 6, 2018 Share Posted February 6, 2018 Moved to Customer Service. Quote Link to comment Share on other sites More sharing options...
sagnik Posted February 10, 2018 Author Share Posted February 10, 2018 Sorry for late reply but my internet connection was inactive for 5 days.Anyway, I've setup remote MySQL but I don't want that. I want to synchronise both servers. Quote Link to comment Share on other sites More sharing options...
wolstech Posted February 10, 2018 Share Posted February 10, 2018 What we're trying to understand is...why? If you use the remote MySQL for the local applications, and get rid of the local MySQL server entirely, both local and hosted applications will work and share the database, eliminating the need to keep two copies on two servers. In the 7 years I've been here, we've never supported replication. Quote Link to comment Share on other sites More sharing options...
sagnik Posted February 10, 2018 Author Share Posted February 10, 2018 Because, if I drop a column of a MySQL table on remote(live) server and if the column is being used by any php scripts that script/page will not work. That's why I'm still using two servers. Quote Link to comment Share on other sites More sharing options...
Krydos Posted February 10, 2018 Share Posted February 10, 2018 Setting up mysql replication would require a lot of changes on Tommy's database. These changes would affect ALL of the users on Tommy. Your options are to either use remote mysql, which is considerably easier anyways, or purchase a vps where you can control the server side mysql database yourself. If you do decide to go with the vps we would appreciate it if you could use our referral link so HelioHost can benefit from your purchase. https://www.heliohost.org/partners/vps Quote Link to comment Share on other sites More sharing options...
sagnik Posted February 11, 2018 Author Share Posted February 11, 2018 Okay, I understand. Thanks for your help. 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.