replicate data from one db to another db server using automated process I have an scenario,
I have two DB server running on two different machines.
I have to build an automated process by which the data will replicate from one DB to another DB server on every insertion happens in first one.
My application using spring- hibernate and mysql DB.
I can go for DB side or spring-hibernate side approach.
Is it possible to do this with rabbitMQ?
I have an option to call automated process on each insertion or as a batch process or using queue.Some of the answers mention in the following link, but it is not clear to me
 1. https://stackoverflow.com/questions/33130260/transforming-data-from-one-sql-server-db-to-another
2. https://stackoverflow.com/questions/3821897/replicating-data-from-one-db-to-another
Any help would be greatly appreciated
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.