Vyapar: ReArchitect for High Availability, Migrating Databases from On-Prem Servers to RDS-MySQL
Challenges
Vyapar is a business accounting software built for small businesses that deals with invoicing, inventory, accounting needs, and much more!
Vyapar team wanted to address the latency issues faced by their clients on priority and ensure they have a business continuity plan in place . Vyapaar team had sought Searce team’s assistance to rebuild their existing architecture for High Availability and DR while migrating their databases On-prem to RDS-Mysql.
The current setup of Vyapar environment is based on legacy monolithic application architecture where the Application code, DB and all other components are hosted in a single server.
The Vyapar team wanted to Re-Architect, Replatform, then migrate their applications, databases to support their clients in India. Below are the list of high priority items the client is looking for support on.
- Adhere to 99% SLA on database availability
- Ensure the data is Encrypted in transit and at rest
- Looking for ease in handling and Managing Databases
- Build automated Patching and upgrades
- Load balance using Vertical Scaling out and Scaling In based on load
- Create Read Replicas for reporting
Searce Solution
Searce expert Team worked with Vyapar’s IT team to gather all the requirements through deepdive sessions to understand the underlying functionality and its features. Based on the workshops we had with the Vyapar team, Searce listed out the current challenges faced by the customers and proposed the use of AWS Managed Services RDS instances and migrated the databases following Highly Available, Secure & robust architecture.
The high level architecture and implementation is as follows:
- Configured Multi-AZ for High Availability
- Encrypted Data at Rest using AWS CMK
- Encrypted Data in Transit by using SSL
- Migrated using Backup and Restore Approach (mysqldump)
- Configured Read-Replicas for Read Intensive queries and Reporting
- Enabled Automated Snapshots with 15 days retention
- Chosen Maintenance Window for automated Patching and upgrades
- Created Cross region read replicas to minimize latency
Business Impact
- Enhanced Database Security
- Reduced the burden of managing the databases
- Achieved 99.99% availability of databases
- Redesigned the architecture helped the team to handle the peak load without any timeout errors
- Minimize latency issues
AWS services leveraged in this deployment
- AWS RDS
- AWS Ec2 for the application hosting
- KMS
- VPC Peering
- Application Load Balancer
- VPC Private endpoints
- AWS Certificate manager for SSL certificates
- CloudTrail
- CloudWatch