Sync Records from one database to other with using different server or machine

I have two different database in different machine.Both the have same tables and i just want insert or update records from one machine to other. how can i do sa开发者_运维技巧me with using mysql database.

Suppose one of my system is on India.and other one is on USA.

It is not web based Application.

Sounds like you probably want to make one of the databases act as a slave to the other, that way any updates on the master will be automatically propagated to the slave. The MySQL documentation has quite a lot of detail on this.

If you wanted to be able to make updates to either database and have them replicated to the other I think it is also possible to configure MySQL to use multi-master replication.

You could use a separate replication tool such as SymmetricDS (http://symmetricds.codehaus.org/) which can sync 2 databases. But beware that you will surely face conflicts problems if you make modifications in both databases.