pt-kill should support "CALL mysql.rds_kill"

Registered by elliot on 2015-02-24

When using pt-kill against an RDS database you cannot kill queries that do not belong to you as the master user.
While you can kill procs with the same user of the running query, to kill procs running as other users a stored procedure must be called.

AWS state:
To allow management of the DB instance, the standard kill and kill_query commands have been restricted.
The Amazon RDS commands rds_kill and rds_kill_query are provided to allow you to terminate user sessions or queries on DB instances.

eg: CALL mysql.rds_kill_query(1299);

I would like an --rds option to pt-kill which simply wraps the prepare statements with the stored procedure.

eg: 'CALL mysql.rds_kill(?)'

We monkey patch pt-kill to do this ourselves - so it does work - we would like it to be officially supported in a future release.

feel like this is a bug - but its not pt-kill's fault - so therefore it's a feature request ;-)

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
elliot
Direction:
Approved
Assignee:
None
Definition:
Approved
Series goal:
Accepted for 2.2
Implementation:
Implemented
Milestone target:
None
Started by
Frank Cizmich
Completed by
Frank Cizmich

Related branches

Sprints

Whiteboard

implemented and merged on github using this external pull request:

 https://github.com/percona/percona-toolkit/pull/20

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.