Client
Our client based in Kerala, provides Cloud based ERP applications for retail industry, serves clients primarily located in Kingdom of Saudi Arabia.
Pain Points
The ERP application was running slow and many customers were complaining most of the time. At times, while performing resource extensive reports, the application stopped working altogether. This became an intermittent issue and that’s when the client contacted TechBrein after getting a referral from one of our happy clients.
Analysis
The Client was hosting their ERP application on a single droplet but with high specs at Digital Ocean. Many issues were identified with their existing infrastructure. They were hosting all services on a single instance, the architecture was not scalable, the instance was hosted on Singapore causing latency, Web and Database servers were not tweaked etc.
Solution
TechBrein convinced the client to migrate to AWS with a tailor-made architecture. The solution involved
Separation of Services: Split the database and web server across two separate EC2 instances to optimize performance and manageability.
Geographical Optimization: Hosting the servers in the AWS Bahrain region to reduce latency and improve connectivity for Middle Eastern users.
Scalability Friendly: Planning for future client growth by configuring an Application Load Balancer (ALB) to distribute traffic efficiently.
Security and Backup: Moved the database server to private subnet for making it publicly accessible, configured IAM policies and also setup snapshot backups twice daily, with retention for a week.
Database Optimization: Identified numerous slow queries in their code, optimized the MySQL tables, improving database performance beyond what was achieved by merely increasing instance size. Working with the client to improve the architecture further such as keeping the static files in S3 bucket and utilizing Amazon Cloudfront. Such enhancements require restructuring the code and the client is working on it.
Outcome
The performance issues have been resolved completely and the client is completely satisfied with the outcome.