IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL Cluster(ndb):备份

    Adamhuan发表于 2017-02-16 09:39:08
    love 0

    管理节点执行:

    [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。



沪ICP备19023445号-2号
友情链接