For MySQL, this is one of many things handled by excellent Percona Toolkit: pt-kill