2

I have two same database on two different server, and I want to synchronize both database.

For example, If I do any process like Insert, Update, Delete, Alter, Drop, etc it also reflect on other database automatically.

I had tried it on my local server, but every time I have to do it manually.

Is there any way to do it automatically, suppose I Insert a record and it automatically inserted into other database.

1
  • 1
    Search for MySQL Master Master replication. Commented Sep 5, 2014 at 11:47

2 Answers 2

3

The "synchronisation" feature you are looking for is called Replication.

A replication can be set up between a master and a slave machine.

It does not rely on a constant connection, but stores all changes on the master and replays all those changes on the slave once a connection is established.

Tuturial for you

Sign up to request clarification or add additional context in comments.

Comments

2

What you're talking about is called 'Replication'.

If you are going to be making changes to both databases and expect it to show up in the other, you need a Master/Master pair.

Have a read about it here: https://dba.stackexchange.com/questions/9424/best-way-to-setup-master-to-multi-master-replication

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.