Table of Contents

Setting up a new AWS RDS database

1. Connect to the AWS Management console (https://console.aws.amazon.com/rds)
2. Click "Launch DB Instances"
3. 
4. 
5. 
6. 
7. Click "Launch DB Instance"Launch DB Instance and wait for it to start.
8. Create a disk space alarm and all other Alarms from the table blow.  Here is an example:
9. Image Added

Setting Up User Permissions

Setting up user permission on an AWS RDS instances is tricky.  For example, the following GRANT statement will not work of an AWS RDS instances:

GRANT ALL ON *.* TO 'hudsonrelease'@'%';

Results in :

Error Code: 1045
Access denied for user 'platform'@'%' (using password: YES)

The problem is the super users created on our behalf does not have permission to grant access to the 'mysql' database schema.  Therefore, we must run a modified version of the above GRANT statement:

GRANT ALL ON `%`.* TO 'hudsonrelease'@'%';

For a better explanation as to what is going on here see the following: http://www.fidian.com/problems-only-tyler-has/using-grant-all-with-amazons-mysql-rds/

Setting up Alarms

The following are the current alarms we have setup: