Case Study - Data Migration to RedShift

Data Migration to RedShift
Skybound Redshift Migration

Executive Summary

Skybound was experiencing increased traffic to their website and needed to stabilize its performance. Stratus10 created and implemented an automated solution that transformed their data so it could be uploaded into AWS Redshift. With the migration, Skybound was able to integrate their analytics application, enabling them to dedicate resources to core business services instead of manually managing environments.

About Skybound

Skybound is a multiplatform content company that works closely with creators and their intellectual properties, extending their stories to further platforms including comics, television, film, tabletop and video games, books, digital content, events, and beyond. The company is the home of notable properties including The Walking Dead, Invincible and Superfight

Website: https://skybound.com

The Challenge: 
Skybound was seeking to stabilize their website, which needed to handle growing traffic volume and to bring some of their applications to the cloud. Additionally, they wanted a solution that would enhance their analytics usage and needed assistance migrating their analytics data to a managed data warehouse solution.

Solution:
Stratus10 assisted in designing, automating, and implementing a process that allowed them to export their My-SQL data to CSV files, upload them to an intermediate S3 Buckets, and perform an Extract, Transform, and Load (ETL) process using AWS Glue - a service that prepares data for analysis through automated extract, transform and load (ETL) processes. This allowed us to prepare the data in order to match the client's database schemas and finally load the data into an AWS Redshift cluster.

Results and Benefits: 

Skybound achieved their goals of migrating to the cloud for improved site stability and integration with their analytics application. The solution enabled them to focus on their core business instead of spending resources to manually manage their environments. As the company continued to expand, they again tapped into Stratus10's expertise and signed on for managed services, which has driven their continued growth in terms of modernization, analytics, security, and performance. Read more about Skybound's Wordpress modernization with containers.

Use case: Data Warehouse Migration

Client:

Skybound

Date:

December 11th, 2019

Category:

RedShift / Migration