使用dm备份阿里云rds报错:Couldn’t acquire LOCK TABLES FOR BACKUP, snapshots will not be consistent: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Couldn’t acquire LOCK TABLES FOR BACKUP, snapshots will not be consistent: Access denied; you need (at least one of) the SUPER privilege(s) for this operation。 请问阿里云的rds在用mydumper或者dm备份的时候报错。用什么方法能够解决获取一致性的视图。 账号已经是阿里云的高权账号了。

你好,

  • Mydumper 操作对象为 RDS 时,可以添加 --no-locks 参数,避免申请 reload 权限。

./tidb-enterprise-tools-nightly-linux-amd64/bin/mydumper --help|grep no-locks

请问下,如果添加了no-locks的参数,可保证最终数据一致性吗?

–help 中有说明,
-k, --no-locks Do not execute the temporary shared read lock. WARNING: This will cause inconsistent backups

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。