theScore Tech Blog

Things We Learn While Building the Ultimate, Personalized Mobile Sports Experience

All Posts Tagged “aws”

Migrating PostgreSQL to Aurora with near Zero-Downtime

The goal here is to migrate an Amazon Web Services Relational Database Service PostgreSQL Database to Aurora with as little downtime as possible. The following documents the initial strategy that was considered using read replica promotion, followed by the end result using AWS's Database Migration Service.

19 min read
databaseaurorapostgresqlaws

Analyzing S3 and CloudFront Access Logs with AWS RedShift

The S3 and CloudFront logs for us are easily terabytes of data per year, and traditional log parsers tend to not handle that size of data. Find out how we use AWS RedShift for log analysis.

14 min read
awsredshift