Vector Solutions – AWS Database Migration

Vector Solutions – AWS Database Migration

  • NorthBay Blogs

Vector Solutions – AWS Database Migration

Vector Solutions

Vector Solutions

Vector Solutions serves a broad range of industries with award-winning online education, safety, compliance, and performance optimization solution suites. It offers industry-focused, innovative products to solve their clients’ needs, helping them improve outcomes, optimize performance and reduce risk. Vector Solutions offers number of brands for different streams.

Challenges

  1. Consolidation of infrastructure and tools across acquisitons and subsidiaries
  2. Migration of applications from Rackspace to AWS
  3. Automate the existing manual processes for provisioning and configuring applications

Solution Delivered to Meet Challenges

  1. Greenfield approach was choosen for this solutioning
  2. Different environments have to share common data for that VPC peering was called upon as recommendation
  3. Different environments and modules were deployed, some in warm and other in cold

Architecture Diagram

AWS Services Used

  • AWS Oracle RDS
  • AWS EC2
  • AWS ALB
  • AWS ASG
  • AWS KMS
  • AWS FSx
  • AWS Directory Service
  • AWS SFTP
  • AWS API Gateway
  • AWS S3
  • AWS Lambda (Python)
  • AWS Cloudformation
  • AWS Cloudwatch
  • AWS VPC
  • AWS SNS/SQS
  • AWS SSM Parameter Store
  • AWS Secrets Manager
  • AWS IAM
  • AWS ACM

Database Workload Migration Details

  • Source DB: 1 Oracle on Rackspace
  • Target DB: 1 RDS Oracle on AWS
  • Number of Schemas Migrated: 500+
  • Size of Migrated Data: 500+ GB
  • Oracle on Rackspace VM -> Oracle on RDS

Migration Patterns Used

By and Large re-platform pattern was used for server (application servers, utility servers, reporting servers, email servers, compile/rebuild servers and database servers) making some changes to enable these for cloud agnostics.

Migration Tools Used

  • Oracle Data pump
  • Standby Database using RMAN

Third-Party Tools Used

  • Robocopy
  • Powershell
  • Terraform
  • Chef

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.