# Sharding Pinterest: How we scaled our MySQL fleet

- **期号**: SRE Weekly Issue #40（2016-09-18）
- **作者**: —
- **链接**: https://engineering.pinterest.com/blog/sharding-pinterest-how-we-scaled-our-mysql-fleet

## 简介

Pinterest explains how they broke their datastore up into 4096(!) shards on 4 pairs of MySQL servers (later 8192 on 8 pairs). It’s an interesting approach, although in essence it treats MySQL as a glorified key-value store for JSON documents.

## 正文

![a person with tattoos on their arm](https://engineering.pinterest.com/media/s3vjn4i0/simyiqing-73.jpg?cc=0,0.04350605852464718,0,0.11274394147535272&width=1600&height=900&rnd=133561067168630000&width=1600&height=900&rmode=crop&quality=85)

# Engineering

Building the platform where people around the world come to search, save and shop

![a man holding a cup](https://engineering.pinterest.com/media/q1zpqxun/portellajon-74.jpg?rxy=0.4896324548651738,0.19535412374795766&width=600&height=450&rnd=133561114053170000&width=600&height=450&rmode=crop&quality=85)

## Engineering at Pinterest

Our Engineering team is at the heart of bringing Pinterest to life for hundreds of millions of users around the world. Together, we tackle ambitious challenges at massive scale, using advanced AI and infrastructure to build industry-leading products, platforms and experiences. By bringing together cutting-edge research and bold innovation, our engineers push boundaries, explore what’s next, and turn big ideas into reality.

![a man sitting in a chair with a camera](https://engineering.pinterest.com/media/0hnguzcf/trivediaditya-121-1.jpeg?rxy=0.49177052757756917,0.38426487819013344&width=600&height=450&rnd=133561124623170000&width=600&height=450&rmode=crop&quality=85)

## The Pinterest Engineering Blog

Explore articles about building features, improving processes and overcoming challenges from the people behind the product.