Tag Info

New answers tagged

0

Sounds like a bug from a year ago (mysqldump creates useless metadata locks) This bug was fixed for MySQL 5.5 and I see you are using MySQL 5.6.21 SUGGESTIONS Don't use --lock-tables=false with --single-transaction because MySQL Documentation says "The --single-transaction option and the --lock-tables option are mutually exclusive because LOCK TABLES ...


2

You can't do it with minimal downtime, or not easily anyway. RDS doesn't support importing base backups and doing streaming replication to/from outside servers. See Getting WAL from AWS RDS and Moving a standalone DB to Amazon RDS. You'll have to dump and reload. If you're keen, you could instead set up Londiste or a similar tool to stream changes from ...



Top 50 recent answers are included