Excluding transactions with gtid-opracowanie

Excluding transactions with gtid_purged. The master's global gtid_purged [2061] variable
contains the set of all transactions that have been purged from the master's binary log. As with
the method discussed previously (see Injecting empty transactions), you can record the value of
gtid_executed [2059] on the server from which the snapshot was taken (in place of copying
the binary logs to the new server). Unlike the previous method, there is no need to commit empty
transactions (or to issue PURGE BINARY LOGS); instead, you can set gtid_purged [2061] on the
slave directly, based on the value of gtid_executed [2059] on the server from which the backup or
snapshot was taken.
... zobacz całą notatkę