In every DBA's life, there is a point where data needs to be copied over great distances. This can be the other coast, or it can be another continent. It can be because of implementing a disaster recovery system, it can be because distant read replicas are needed for the application.
In this talk, we use examples with MySQL and xtrabackup to discuss the issues of long-distance copies and the potential performance tuning opportunities. I
n this talk, we will:
- Examine the characteristics of transferring a large amount of data over WAN links.
- Discuss compression and encryption options.
- Check out options for copying an already existing backup.
- Check out options for streaming backups on the y.