3 ms·
MySQL does not have any kind of native snapshotting capability, no. It is becoming somewhat common to run large MySQL deployments on filesystems which do (like
by sethhochberg 8y ago
MySQL does not have any kind of native snapshotting capability, no.
It is becoming somewhat common to run large MySQL deployments on filesystems which do (like ZFS) to get a similar effect, albeit without the ability to restore a snapshot on a host while that database host is online. There is even some experimental work going on in the community to use ZFS snapshots as a state-transfer mechanism for laggy nodes in a Galera MySQL cluster, which seems promising.