Engineering Leadership for the Zombie Horde

Industry

Entertainment

Size

Medium

Years Serviced

< 2

Skybound Entertainment - Data Warehouse

Overview

One of our first projects we took on when we started engaging with Skybound was to rebuild and migrate their existing Data Warehouse from Rackspace to AWS. Skybound’s Data Warehouse is a giant database where one single table has over 430 million rows that stores data from multiple sources and is integrated with Tableau for advanced data visualization and reporting.

Challenges

The original Data Warehouse code was a mess of scripts and cron jobs scattered across a server. We had to not only manage migrating database tables with millions of rows of records from one cloud provider to another (the database was so big that the traditional AWS migration tool failed and we had to script the entire thing by hand table by table), but we also had to reverse engineer all of the existing scripts and rebuild them with best practice PHP in Laravel.

Solution

The solution was to migrate Skybound to a modern API application built with Laravel hosted on AWS

  • Migrated from Rackspace DynamoDB to AWS Redshift
  • Rebuilt hodgepodge scripts into modern API system leveraging Laravel
  • Ecommerce integrations with AWS, Ebay, and Shopify
  • Social integrations with Facebook, Youtube, Instagram, Twitch, and Twitter
  • CRM Integration with Sendlane
  • Custom Subscriber integration with the Insiders Laravel Application
  • Game Sales Integrations (in progress)

Technologies

An open source PHP framework designed for rapid prototyping.

Learn more about Laravel

Amazon Web Services offers reliable, scalable, and inexpensive cloud computing services.

Learn more about AWS

Results

The result of this massive project is a scalable data infrastructure which we help to maintain and further scale. The previous solution required constant maintenance and management to keep all of the scripts and crons running properly. Now we have a scalable API system that we can continue to grow with new data and integrations.

Don't let your project turn into a tragedy.