3 ms·
You can definitely access the binary log on RDS: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html#USER_LogAccess.MySQL.B
by 33degrees 10y ago
You can definitely access the binary log on RDS: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html#USER_LogAccess.MySQL.Binarylog http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_L...
- mgkimsal 10y agothank you - still not sure if this tool could use it as it needs (perhaps 'streaming' the binlog?). I'm wrestling with making changes on a large RDS table, but I also don't actually have total permission on the account as it belongs to a client so I have to keep trying things, then seeing what breaks, then asking for a change, then trying again.
- 33degrees 10y agoApparently gh-ost won't work, but there are other tools that work fine on RDS: I've been using https://github.com/soundcloud/lhm https://github.com/soundcloud/lhm On some fairly large tables (30 million + rows) without any problems
- mgkimsal 10y agothanks - will look at this if I can't get the pt stuff working (already have used that in the past, so would rather keep new tools to minimum). This particular table is ... 200 million rows, give or take, and is a bugger to deal with).