管理节点执行:
[root@ndb-manager mysql-cluster]# ndb_mgm -- NDB Cluster -- Management Client -- ndb_mgm> ndb_mgm> start backup 2017021601 Connected to Management Server at: 10.158.1.98:1186 Waiting for completed, this may take several minutes Node 2: Backup 2017021601 started from node 1 Node 2: Backup 2017021601 started from node 1 completed StartGCP: 1357 StopGCP: 1360 #Records: 2055 #LogRecords: 0 Data: 50812 bytes Log: 0 bytes ndb_mgm>
备份数据会被自动存放在【数据节点】的MySQL数据目录下的【BACKUP】中(该目录如果不存在,会自动创建)。
具体如下:
[root@ndb-node1 ~]# ls -ltr /var/lib/mysql/ total 68 drwxr-xr-x 2 root root 6 Feb 16 14:53 ndb_data drwxr-xr-x 2 root root 6 Feb 16 14:58 database_data -rw-r----- 1 mysql mysql 3092 Feb 16 14:58 mysql-error.log drwxr-x--- 9 root root 72 Feb 16 15:33 ndb_2_fs -rw-r--r-- 1 root root 5 Feb 16 16:25 ndb_2.pid drwxr-x--- 3 root root 30 Feb 16 16:30 BACKUP -rw-r--r-- 1 root root 60012 Feb 16 16:30 ndb_2_out.log [root@ndb-node1 ~]# [root@ndb-node1 ~]# ls -ltr /var/lib/mysql/BACKUP/ total 0 drwxr-x--- 2 root root 99 Feb 16 16:30 BACKUP-2017021601 [root@ndb-node1 ~]# [root@ndb-node1 ~]# ls -ltr /var/lib/mysql/BACKUP/BACKUP-2017021601/ total 56 -rw-r--r-- 1 root root 52 Feb 16 16:30 BACKUP-2017021601.2.log -rw-r--r-- 1 root root 20720 Feb 16 16:30 BACKUP-2017021601.2.ctl -rw-r--r-- 1 root root 26020 Feb 16 16:30 BACKUP-2017021601-0.2.Data [root@ndb-node1 ~]#
——————————
Done。