GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-osc with Amazon AWS RDS

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-osc with Amazon AWS RDS

    Hello,
    I am trying to use pt-osc with an Amazon AWS RDS. I think the issue is similar to the topic in: http://www.percona.com/forums/questi...-on-amazon-rds.

    I have no issues using pt-osc on our main site implementation where we have Linux root and MySQL root access. However, we have another app that runs in an Amazon AWS environment. I have Percona Toolkit 2.2.8 installed on an EC2 instance and am trying to run the following command (I've substituted 2 character shortcuts for the sensitive stuff):

    [ec2-user@nn ~]$ perl /home/percona/tools/pt-online-schema-change --alter 'ENGINE=InnoDB' D=aa,t=bb,h=cc.us-east-1.rds.amazonaws.com,P=3306,u=dd,p=ee --execute --no-drop-old-table
    DBD::mysql::db selectall_arrayref failed: Access denied; you need (at least one of) the REPLICATION SLAVE privilege(s) for this operation [for Statement "SHOW SLAVE HOSTS"] at /home/percona/tools/pt-online-schema-change line 4127.

    I tried adding all privileges then missing privileges using MySQL GRANT, for example like below but it seems Amazon RDS doesn't allow as implied in the post I referenced regarding pt-table-sync. However I have to believe there must be users who were able to get percona toolkit (e.g. pt-osc) to work in an AWS environment. What am I missing? I also tried explicitly adding "SUPER" in the GRANT but still get the same MySQL 1045 error.
    GRANT ALL ON *.* TO 'someuser'@'somehost';
Working...
X