This blog post discusses the limitations of the MySQL Clone plugin.
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 …