Are there any MySQL monitoring suites/tools built to use on systems such as Amazon RDS where you do not have system access? Looking for something beyond custom tools (nagios, zenoss, ganglia, hyperic) and more like MySQL Enterprise Monitor, MONyog, and DBTuna.
You could try MONyog MySQL Monitor and Advisor from http://www.webyog.com.
You could try appfirst with a mysql plugin. It's easy to do. You don't need nagios, but you get to use any of the nagios plugins. Lots of rich tools for mysql.