解决MySQL Cluster 备份总是失败，提示文件已存在的问题

不知为何文章内容没有了，重新发一次。

一套Mysql Cluster 7.0.13集群，尝试在控制台启动备份操作总是失败，记录如下：

      ndb_mgm> start backup wait completed
      Waiting for completed, this may take several minutes
      Node 3: Backup 185 started from 1 has been aborted. Error: 1350
      Backup failed
      *  3001: Could not start backup
      *        Backup failed: file already exists (use 'START BACKUP '): Temporary error: Temporary Resource error

经研究，估计是升级CLUSTER时（原来是MySQL 5.0.x）没有重新init cluster的DB，其内部可能记住了backup id，造成冲突。测试start backup指定较大的backup_id：

      ndb_mgm> start backup 900 wait completed
      Waiting for completed, this may take several minutes
      Node 3: Backup 900 started from node 1
      Node 3: Backup 900 started from node 1 completed
       StartGCP: 7836584 StopGCP: 7836587
       #Records: 14664 #LogRecords: 1
       Data: 20915648 bytes Log: 52 bytes

备份成功执行了。

本站微信订阅号：

本页网址二维码：