Slide 1

Slide 1 text

Turning off the LAMP Hunter Loftis Director of Technology Skookum Digital Works Wednesday, August 15, 12

Slide 2

Slide 2 text

Skookum who? Wednesday, August 15, 12

Slide 3

Slide 3 text

Wednesday, August 15, 12

Slide 4

Slide 4 text

Wednesday, August 15, 12

Slide 5

Slide 5 text

Project X Wednesday, August 15, 12

Slide 6

Slide 6 text

The Issues • 250 tables • $2,800/month to host • 5+ second page loads • “schema paralysis” Wednesday, August 15, 12

Slide 7

Slide 7 text

Wednesday, August 15, 12

Slide 8

Slide 8 text

Our Hypothesis Wednesday, August 15, 12

Slide 9

Slide 9 text

Documents • Faster • ...for cheaper hosting. • ...and shorter loadtimes. • Simpler • ...and easier to change. • ...without breaking stuff. Wednesday, August 15, 12

Slide 10

Slide 10 text

Results Wednesday, August 15, 12

Slide 11

Slide 11 text

(onload: 774ms, DOMContentLoaded: 694ms) Wednesday, August 15, 12

Slide 12

Slide 12 text

$24k/year (71%) projected hosting savings Wednesday, August 15, 12

Slide 13

Slide 13 text

Wednesday, August 15, 12

Slide 14

Slide 14 text

But... Wednesday, August 15, 12

Slide 15

Slide 15 text

“... they basically had no idea what MongoDB was and do not support it at all.” Wednesday, August 15, 12

Slide 16

Slide 16 text

“They've advised me that with MongoDB, the entire DB goes into RAM.” Wednesday, August 15, 12

Slide 17

Slide 17 text

Developers will try to use mongo like SQL (at first). Wednesday, August 15, 12

Slide 18

Slide 18 text

You will miss JOINs (sometimes). Wednesday, August 15, 12

Slide 19

Slide 19 text

Not all data makes sense as documents. Wednesday, August 15, 12

Slide 20

Slide 20 text

Keep it simple, and mongo will rock your world. Wednesday, August 15, 12

Slide 21

Slide 21 text

Thank you. • skookum.com • @skookum • @hunterloftis • github.com/Skookum Wednesday, August 15, 12