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.
MySQL Master Master replication.