What is replication ==
Replication means that data written on a master MySQL will be send to separate server and executed there.
* spread read access on multiple servers for scalability
Asynchronous replication (basic master /slave )
* Semi-asynchronous replication (asynchronous replication + enforce 1 slave replication before completing queries)
Replication configurations: ▲
* standard: master->slave
* dual master: master<->master
In Master-Master replication both hosts are masters and slaves at the same time. ServerA replicates to serverB which replicates to serevrA.
There are no consistency checks and even with auto_increment_increment/auto_increment_offset configured both servers should not be used
for concurrent writes.
== Asynchronous replication ==