MENU
Replication
Replication is the process by which selected data from one database server (the master) is replicated to one or more database servers (the slaves). It is asynchronous by default, which means that the slaves need not be connected permanently to receive updates.Normally, all writes and updates must occur at the root master. Reads, however, can take place on the slaves.
Replication spreads the load among multiple slaves to improve performance. It can be used to run backup services. It can also distribute data over long distances, thus reducing transmission overhead.
During the replication process, the slaves read the binary log from the master, and execute selected events in the binary log on the local database.
A slave can be the master of another slave. Thus a replication setup may use various arbitrary topologies, including the tree, linear, and circular topologies.