mysql备份恢复与容灾文档验证详细过程

《mysql备份恢复与容灾文档验证详细过程》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、一、备份与恢复验证这部分测试由于环境因素，在两个B200的物理节点上创建的7节点ndb集群下做的测试，其中每个物理节点启动两个数据节点，一个mysqld节点，一个管理节点。数据量受内存现在只做了几十个g的备份、恢复操作。下面描述详细验证过程。1ndb物理备份测试恢复drop的表1.1准备环境主备份窗口:[mysql@sicloud-b200-3my_cluster]$ndb_mgm--NDBCluster--ManagementClient--ndb_mgm>showConnectedtoMan

2、agementServerat:localhost:1186ClusterConfiguration---------------------[ndbd(NDB)]4node(s)id=21@192.168.180.202(mysql-5.5.29ndb-7.2.10,Nodegroup:0,Master)id=22@192.168.180.203(mysql-5.5.29ndb-7.2.10,Nodegroup:1)id=23@192.168.180.209(mysql-5.5.29ndb-7

3、.2.10,Nodegroup:2)id=24@192.168.180.210(mysql-5.5.29ndb-7.2.10,Nodegroup:3)[ndb_mgmd(MGM)]1node(s)id=11@192.168.180.202(mysql-5.5.29ndb-7.2.10)[mysqld(API)]6node(s)id=31@192.168.180.202(mysql-5.5.29ndb-7.2.10)id=32(notconnected,acceptingconnectfrom19

4、2.168.180.203)id=33(notconnected,acceptingconnectfrom192.168.180.209)id=34(notconnected,acceptingconnectfrom192.168.180.210)id=35(notconnected,acceptingconnectfromanyhost)id=36(notconnected,acceptingconnectfromanyhost)进入单用户方式：db_mgm>ENTERSINGLEUSERMO

5、DE31SingleusermodeenteredAccessisgrantedforAPInode31only.ndb_mgm>startbackupWaitingforcompleted,thismaytakeseveralminutesNode21:Backup1startedfromnode11ndb_mgm>Node21:Backup1startedfromnode11completedStartGCP:257415StopGCP:257443#Records:8102118#LogR

6、ecords:0Data:2365678260bytesLog:0bytes耗时45秒退出单用户方式：Mgm》exitsingleusermode查看各节点备份文件:[mysql@sicloud-b200-3BACKUP-1]$pwd/home/mysql/my_cluster/ndb_data/BACKUP/BACKUP-1[mysql@sicloud-b200-3BACKUP-1]$ls-ltotal595672-rw-rw-r--.1mysqlmysql609828624Apr2209:1

7、3BACKUP-1-0.21.Data-rw-rw-r--.1mysqlmysql126996Apr2209:13BACKUP-1.21.ctl-rw-rw-r--.1mysqlmysql52Apr2209:13BACKUP-1.21.log[mysql@sicloud-b200-4BACKUP-1]$pwd/home/mysql/my_cluster/ndb_data/BACKUP/BACKUP-1[mysql@sicloud-b200-4BACKUP-1]$ls-ltotal577448-r

8、w-rw-r--.1mysqlmysql591166636Apr2209:13BACKUP-1-0.22.Data-rw-rw-r--.1mysqlmysql126996Apr2209:13BACKUP-1.22.ctl-rw-rw-r--.1mysqlmysql52Apr2209:13BACKUP-1.22.log/home/mysql/my_cluster/ndb_data/BACKUP/BACKUP-1[mysql@sicloud-b200-1BACKUP-1]$ls-ltotal5604