Mydumper global lock problem on a Amazon RDS

Asked by Sergio D. Rodríguez Inclan on 2013-09-24

Hi,

I have a problem when executing mydumper on a RDS instance I got the message "(mydumper:30181): CRITICAL **: Couldn't acquire global lock, snapshots will not be consistent: Access denied for user..." why is that? I completed it tough, is there a valid why to perform the dump without the problem mentioned?

Thanks.

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Data Dumper Edit question
Assignee:
No assignee Edit question
Last query:
2013-09-24
Last reply:
2015-09-07
Domas Mituzas (domas-mituzas) said : #1

RDS does not give you possibility to grab a global snapshot, so parallel consistent snapshots are not possible.
Either use single thread dump or standard mysqldump --single-transaction

Max Bubenick (max-bubenick) said : #2

You can use --lock-all-tables, it will use lock table ... read; instead of FTWRL which is not allowed on RDS.

And for clarification the lock is only at the beginning to coordinate threads. And of course you also use --no-locks but the snapshot will not be consistent.

Can you help with this problem?

Provide an answer of your own, or ask Sergio D. Rodríguez Inclan for more information if necessary.

To post a message you must log in.