- 主库备份数据,拷贝至从节点
1.1 备份数据
sudo python /data/apps/xtrabackup/script/xtrabackup.py -m full
备份目录为:
/data/mysql_bakcup/<port>/<date>/full_<date>
例:/data/mysql_backup/13306/20231124/full_164044/
1.2 拷贝备份数据至从节点
scp -r /data/mysql_bakcup/<port>/<date>/full_<date> /data/
例:scp -r /data/mysql_backup/13306/20231124/full_164044/ kde-offline2:/data/