We reduced the average report generation time of a healthcare company to 10 seconds, this a 90X performance improvement despite reducing the number of RDS instances by 20%.
To do this, we first identified the performance bottlenecks in the current system using AppDynamics. Then we re-architected the data replication strategy. We optimized encryption/decryption process without compromising on HIPAA compliance. We also made several improvements by implementing real-time data syncing using Kinesis, SQS & MySQL binlog reader.