mysql cluster 备份_WaveCN.com - 站长手记 - 站长手记 - 解决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

备份成功执行了。