站长手记 - 站长手记
打印】【收藏此页
解决MySQL Cluster 备份总是失败,提示文件已存在的问题
作者:本站:苏信东  来源:WaveCN.com 世纪音频  发布日期:2010-11-04  最后修改日期:2010-11-04  

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

一套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

备份成功执行了。