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 same with using mysql database.

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

It is not web based Application.

Answers


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.


Need Your Help

Using Fay in a cabal sandbox

haskell cabal fay

I've just started using both cabal sandboxes and Fay. However, Fay seems unable to find the packages automatically, presumably as they are not in the 'global' cabal package database. I tried

How to solve “Batch update returned unexpected row count from update; actual row count: 0; expected: 1” problem?

nhibernate fluent-nhibernate automapping

Getting this everytime I attempt to CREATE a particular entity ... just want to know how I should go about figuring out the cause.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.