Lab
A Cloud Guru

Migrating BLOB Data in a MySQL Database to S3

In this lab, we will migrate BLOB data stored in a relational database table to S3. We will then update that table, replacing the binary data with references to the location of the files in S3.

Try for free Contact sales

Path Info

Level

Intermediate

Duration

2h 0m

Published

Aug 06, 2020

Challenge

Extract BLOB Data from MySQL Database

Either using the script provided in the helper/ directory or with your preferred method, extract the BLOB data from the file_data column and save the data into the appropriately named files from the file_name column of the johnselfie.selfies table.
Challenge

Move Extracted Files to S3

Move the extracted files to the media/ prefix of the S3 bucket provided in the environment.
Challenge

Update Database or Code with S3 URIs
Drop the file_data column from the johnselfie.selfies tables, and either:
- Replace it with a new file_data column, and add the appropriate data to this column.
- Update the application code to deterministically generate the correct URI for each file referenced in the database.

Author

A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.