Copying data and transactions to the slave-opracowanie

Copying data and transactions to the slave. Playing back the entire transaction history can
be time-consuming, and represents a major bottleneck when setting up a new replication slave. To
eliminate this requirement, we can take from the master a backup that includes, in addition to a dump
containing a snapshot of the data set, the binary logs and the global transaction information they
contain. Setting up the slave then consists of importing the snapshot, then playing back the binary
log, after which replication can be started, allowing the slave to become current with any remaining
transactions.
There are several variants of this method; these can be distinguished by the manner in which data
(dumps) and transactions (binary logs) are shipped to the new slave
... zobacz całą notatkę