replicate data from one db to another db server using automated process
Do not try to make it harder than it actually is. Replication mechanism build-in mySQL will be the best for that. There is a ton of tutorials in google, ex.:

https://fromdual.com/how_to_setup_mysql_master-slave_replication

Basically, You need master-slave configuration.