Scaling MySQL & PHP

Speaker Info (Who am I?)

Alternative Title

Outline

What was it?

What was it?

Browse Tiles by Location

Browse Tiles by Location

Browse Tiles by Location

Browse Tiles by Category

Search Tiles

Project Goals

Technology Selection

Design & Implementation

Database Cluster

Web Cluster

Design & Implementation

Testing

Going Live on the 10^th

Going Live on the 10^th

Handling the 11^th

Handling the 11^th

Handling the 11^th

Handling the 11^th

Postmortem Analysis

Final Statistics

Final Statistics

Specific Trouble Spots

No Query Optimization

Cool Tiles

PHP Cache Locking

Load Balancer Setup

Persistent Data

I Wasn’t Prepared to Scale

Poor Database Design

Replication Delays

No Connection Pooling

Not Enough People

Shameless Book Plug

Questions and Answers