0

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second.

I am hosting the public site on another Digital ocean server which is only reading information from the database.

How can I Sync the database tables on public site with data-entry-site database tables. I am looking for one way Sync only. ( data-entry-site --> public site )

Thanks

Improve this question
7
  • Use replication. then chose a moment and switch between DBs. Some instand downtime is imminent, though. Commented Feb 24, 2016 at 16:43
  • can you please elaborate "downtime". I need this to be automatic, every minute or second . Commented Feb 25, 2016 at 9:07
  • I thought you are about to switch installations. If not, why don;'t you just connect the second installation to the original database ? Commented Feb 25, 2016 at 9:41
  • yes that's an alternate solution, but i wanted to have two seperate databases, because if the public site is down for some reason, i don't want the data entry team to relax by doing nothing. :) Commented Feb 25, 2016 at 11:55
  • Then a replication definitely. No downtime. Commented Feb 25, 2016 at 11:56

0

Reset to default

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.