This blog post discusses the limitations of the MySQL Clone
The MySQL clone plugin significantly simplifies the process of
replica provisioning. All you need to do is:
- Ensure that the source server has binary logs enabled
- Grant appropriate permissions
- Execute the CLONE INSTANCE command on the recipient
This works extremely easily when you provision a new replica
that doesn’t have any data.
Due to its simplicity, you may want to use the clone plugin
instead of a backup to restore a server that survives data
inconsistency or corruption. E.g., after crash.
However, if you have data on your replica, you need to consider
how you will recover if the CLONE INSTANCE command fails
with an error.
CLONE INSTANCE command, by default, works as follows:
- Checks prerequisites on the replica
- Wipes out data …