Intelligize – AWS Database Migration

Intelligize – AWS Database Migration

  • NorthBay Blogs

Intelligize – AWS Database Migration

Intelligize

Intelligize

Intelligize is the leading provider of best-in-class content, exclusive news collections, regulatory insights, and powerful analytical tools for compliance and transactional professionals.

Intelligize offers a web-based research platform that ensures law firms, accounting firms, corporations and other organizations stay compliant with government regulations, build stronger deals and agreements, and deliver value to their shareholders and clients.

Headquartered in the Washington, DC metro area, Intelligize serves Fortune 500 companies, including Starbucks, IBM, Microsoft, Verizon and Walmart, as well as many of the top global law and accounting firms.

In 2016, Intelligize became a wholly-owned subsidiary of LexisNexis®, a leading global provider of content-enabled workflow solutions designed specifically for professionals in the legal, risk management, corporate, government, law enforcement, accounting and academic markets.

Challenges

  1. Spending more time in managing infrastructure issues, high availbility and disaster recovery than the actual product development
  2. After aquisition, mandated from the parent company to migrated to Cloud

Solution Delivered to Meet Challenges

  1. MySQL was moved to RDS MySQL
  2. 18 TB documents stored in S3
  3. Multiple webservers in autoscaling groups and behind a load balancer
  4. Automated backups for DR

Architecture Diagram

AWS Services Used

  • AWS MySQL RDS
  • AWS DynamoDB
  • AWS EC2
  • AWS ALB
  • AWS ASG
  • AWS SFTP
  • AWS Cloud front
  • AWS S3
  • AWS Lambda (Python)
  • AWS Cloudformation
  • AWS Cloudwatch
  • AWS VPC
  • AWS SNS/SQS
  • AWS IAM
  • AWS Guard Duty
  • AWS Route53
  • AWS Code Deploy
  • AWS VPC

Database Workload Migration Details

  • Approx. 300GB of data
  • Over 1000+ tables
  • MySQL dumps restored on RDS and Replication setup to sync both
  • MySQL replication was used to sync on-premises and RDS till migration day
  • Source and Target:
    • MySQL -> RDS MySQL

Migration Patterns Used

N/A

Migration Tools Used

  • MySQL replication after restoring MySQL Dumps
  • Custom multip threaded utility for moving documents to S3, using cmd

Third-Party Tools Used

  • Jenkins
  • SOLR
  • MySQL
  • Sumologic
  • Aspose converter

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.