Become a member
Sign in
Jason Wei
Jason Wei

Jason Wei

19 Following
3 Followers
·
  • Profile
  • Claps
  • Highlights

Highlighted by Jason Wei

See more

From Sharding Pinterest: How we scaled our MySQL fleet by Pinterest Engineering

All data needed to be replicated to a slave machine for backup, with high availability and dumping to S3 for MapReduce. We only interact with the master in production. You never want to read/write to a slave in production. Slaves lag, which causes strange bugs. Once you’re sharded, there’s generally no advantage to interacting with a slave in production.

From Sharding Pinterest: How we scaled our MySQL fleet by Pinterest Engineering

Aside: I still recommend startups avoid the fancy new stuff — try really hard to just use MySQL. Trust me. I have the scars to prove it.

Claps from Jason Wei

See more

Sharding Pinterest: How we scaled our MySQL fleet

Pinterest Engineering