RDS User Monitor for MyTutor

At MyTutor, we aimed to ensure that the application database was accessed only by authorised user accounts for legitimate reasons. This project involved analysing AWS CloudWatch logs for the AWS RDS instances to extract relevant information. A list of users and their executed queries was compiled, excluding certain allowed users. The accounts that did not meet the criteria were then posted to a Slack channel for review.

MySQL Slow Query monitor at MyTutor

Some of the SQL queries in the MyTutor application were taking a very long time to run. We already had the MySQL slow query log logging them to AWS CloudWatch, but we found they were left unnoticed there.

The Lesson Space monitoring at MyTutor

MyTutor relies extensively on an external SaaS service to deliver their online lessons. This project aimed to implement robust monitoring to quickly detect any service downtime or performance degradation.