We recently tested the PostgreSQL backup tool
pg_basebackup and were very impressed with its
remote backup functionality, which allows for both physical local
and physical remote backups.
This led us to wonder whether a physical remote backup is also possible using the “new” MySQL Server Clone feature, which was introduced in MySQL 8.0.17 (July 2019).
The MySQL Clone operation can be used to create both a local and a remote copy of the database. The original idea behind this feature was likely to automatically create nodes in an InnoDB Cluster (similar to Percona XtraDB Cluster SST).
Terminology used in the clone operation:
- Donor (source database)
- Recipient (destination database)
The clone operation is initiated from the recipient. The data can be cloned to the recipient’s own directory or, alternatively, to a different directory.
Preparations
…[Mehr]
