《MySQL Clone Plugin备份同步原理与实践》由会员分享,可在线阅读,更多相关《MySQL Clone Plugin备份同步原理与实践(12页珍藏版)》请在金锄头文库上搜索。
1、MySQL备份及同步利器-Clone Plugin的原理与实践,PXC与MGR节点加入集群对比,Clone Plugin实现逻辑与监控 Clone Plugin使用注意事项,Clone Plugin,01ClonePlugin功能介绍,MySQL clone instance from userhost:port identified by ” password” ;,MySQL clone instance from userhost:port identified by password data directory =“ $clone_dir” ;,Local Clone,Remote
2、Clone,02ClonePlugin使用场景,Master-Slave,easy,easy BACKUP,easy SQL,MGR,easy,02ClonePlugin使用场景-BACKUP,Recipient,Donor,不需要安装备份工具 不需要安装rsync/scp 不需要开通ssh权限,不需要安装nc/pv 锁更轻量 备份有效性更容易验证,SQL,02ClonePlugin使用场景-添加slave/member,VS,流程:,初始化新节点; 将新节点data目录下的所有数据删除; xtrabackup备份; scp/rsync/stream等方式发送到从库; apply redo &
3、 chown mysql.mysql; cat/less/grep获取binlog坐标; SQL reset master & set global gtid_purged; SQL change & start slave/start group_replication;,流程:,初始化节点; SQL clone instance from xxxxxx; SQL change & start slave/group_replication;,Slave Member,Master Primary,xtrabackup,Slave Member,Master Primary,clone,03PXC与MGR节点加入集群对比,04ClonePlugin实现逻辑,04ClonePlugin监控,1. Recipient-performance_schema.clone_progress,2. Recipient:performance_schema.clone_status,04ClonePlugin监控,Recipient/Donor-performance_schema.events_stages_current,05ClonePlugin注意事项,,,