4 ms·
given that this needs access to the binary log, am I out of luck if I want to use this with amazon rds? (I don't see a way to see/access the binlog at rds)
by mgkimsal 10y ago
given that this needs access to the binary log, am I out of luck if I want to use this with amazon rds? (I don't see a way to see/access the binlog at rds)
- 33degrees 10y agoYou 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).
- jzelinskie 10y agoI really want this to work on RDS. However, according to the docs[0]: Amazon RDS and Google Cloud SQL are probably not supported (due to SUPER requirement) [0]: https://github.com/github/gh-ost/blob/master/doc/requirements-and-limitations.md https://github.com/github/gh-ost/blob/master/doc/requirement...
- 33degrees 10y agoAh indeed it won't work on RDS as they explicitly test for SUPER or ALL privileges. But it's possible that the tool could be made to work without it in the future.