MySql phpMyAdmin: Replicating/Synchronizng two Dat

Question

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.

Answer 1

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

Answer 2

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