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