BACKUP DATABASE
and
RESTORE
statements are not written
to the binary log and therefore are not replicated to slaves. Nor
is any data backed up or restored logged or replicated. However,
for RESTORE
, an incident event is
logged unless SKIP_GAP_EVENT
is specified. This
event signals slaves that they should stop replicating because an
event has occurred on the master that results in loss of
master/slave synchrony.
For BACKUP DATABASE
, the binary log
coordinates comprising the backup validity point are written to
the backup image and recorded in the
backup_history
log. To determine the validity
point for a backup later, see
Section 7.3, “Determining the Validity Point Associated with a Backup Image”.
If binary logging is not enabled, the validity point does not
apply for BACKUP DATABASE
, so it is
not written to the backup image or
backup_history
. For
RESTORE
, no incident event is
written.