Setting up AWS RDS (MySQL) for Synapse
Setting up a new AWS RDS database
Connect to the AWS Management console (https://console.aws.amazon.com/rds)
Click "Launch DB Instances"
Click Launch DB Instance and wait for it to start.
Create a disk space alarm and all other Alarms from the table blow. Here is an example:
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:
Send a notification to: | With these recipients: | Whenever: | Is: | For at least: | Name this alarm: |
|---|---|---|---|---|---|
RDS-Alert (platform@sagebaes.org) | Average Write Latency | >= 0.100 seconds/op | 1 consecutive period(s) of 5 Minutes | awsrds-synapse-repo-2-High-Write-Latency | |
RDS-Alert (platform@sagebaes.org) | Average of CUP Utilization | >= 90% | 2 consecutive period(s) of 5 Minutes | awsrds-synapse-repo-2-High-CPU-Utilization | |
RDS-Alert (platform@sagebaes.org) | Average of Free Storage Space | < 1.0E9 Bytes | 1 consecutive period(s) of 5 Minutes | awsrds-synapse-repo-2-Low-Free-Storage-Space | |
RDS-Alert (platform@sagebaes.org) | Average of Free-able Memory | < 1.0E9 Bytes | 1 consecutive period(s) of 5 Minutes | awsrds-synapse-repo-2-Low-Freeable-Memory |