There are additional considerations when monitoring a MySQL instance in an cloud environment, such as the Amazon Relational Database Service (Amazon RDS).
Remote monitoring is used when monitoring on a cloud. You may use any MySQL Enterprise Monitor Agent to monitor MySQL instances remotely, including the bundled Agent that is automatically installed and started with the MySQL Enterprise Service Manager.
When configuring a MySQL instance to monitor from the MySQL Instances Dashboard, be sure to:
Do not configure MySQL Enterprise Monitor to auto-create the less privileged
accounts, and instead use the Admin account for all
This is set in the Connection Settings
tab when adding (or editing) a MySQL instance to be monitored.
This Auto-Create Less Privileged Users
setting defaults to
Yes, so toggle it to
Also under Connection Settings is the Instance Address parameter. Set this to your endpoint, which is the entry point for your MySQL Server web service.
Change the inventory table schema for MySQL Enterprise Monitor Agent from
mysql" to an alternative (and existing)
This is set in the Advanced Settings tab
when adding (or editing) a MySQL instance to be monitored. The
Inventory Table Schema setting defaults
mysql, which is typically not accessible
to the Agent user in a cloud (or shared) environment. Change
it to a schema you created.
Your MySQL instance should now be remotely monitored, and it will now be listed in the MySQL Instances Dashboard.