Kaplan – AWS Database Migration

Kaplan – AWS Database Migration

  • NorthBay Blogs

Kaplan – AWS Database Migration

Kaplan

Kaplan

Kaplan is a professional educational services provider. It provides a wide range of training and educational services to corporate customers, businesses, colleges and universities across the globe.

Challenges

  1. Kaplan needed to comply with Disaster Recovery requirements from their customers and their existing setup was not sufficient to meet the customer’s SLA’s
  2. Highly dependent integrated applications are impediment for any sort of modernizing the applications

Solution Delivered to Meet Challenges

  1. Northbay provided a robust AWS cloud architecture that addresses the customer’s pain points like security, disaster recovery, high availability etc.
  2. Disaster Recovery Solutions evolved into a migration opportunity
  3. Approach was to migrate the applications with minimal refactoring and incorporate any low hanging fruit (RDS, Autoscaling etc) following well-architected framework and best practices

Architecture Diagram

AWS Services Used

  • AWS Aurora
  • AWS EC2 for Microsoft Windows
  • AWS EC2 for Linux
  • AWS API Gateway
  • Auto Scaling for EC2
  • AWS Certificate Manager
  • AWS KMS
  • AWS Lambda
  • AWS RDS for PostgreSQL
  • AWS CloudTrail
  • AWS CloudWatch
  • AWSEC2 Container
  • AWS S3
  • AWS Glacier
  • VPC Peering
  • Transit VPC setup

Database Workload Migration Details

  • Source and target DBs were a match:
    • PostgreSQL -> RDS PostgreSQL
    • MS SQL -> MS SQL
    • MySQL -> Aurora MySQL
  • Client migrated their data on their own into these instances, we guided and provisioned.

Migration Patterns Used

  • List & Shift for applications
  • Lift & Shift for MS SQL
  • Lift, Shift, Optimize for MySQL and PostgreSQL to Aurora and RDS respectively at instance level

Migration Tools Used

  • AWS CloudFormation
  • AWS CodeCommit
  • AWS Code Deploy
  • Directory Service

Third-Party Tools Used

  • MS SQL server
  • Ansible (with CloudFormation)
  • Redis

About NorthBay – We are a fast-growing, 100% AWS focused onshore/offshore AWS Premier Consulting Partner, supporting our customers to accelerate the reinvention of their applications and data for a Cloud-native world. Our >350 AWS Certified Employees excel in developing and deploying Database & Application Migrations, Data Lakes and Analytics, Machine Learning/AI, DevOps and Application and Data Modernization/Development that drive measurable business impact.