3 ms·
This is missing one huge point of the [uber engineer post](https://eng.uber.com/mysql-migration/ https://eng.uber.com/mysql-migration/). They did not switch fr
by charlesetc 9y ago
This is missing one huge point of the [uber engineer post](https://eng.uber.com/mysql-migration/ https://eng.uber.com/mysql-migration/).
They did not switch from a postgres instance to put all their data in a mysql instance. They switched from a single postgres instance to shard their data across many mysql instances. This an entire reworking of the architecture that is completely ignored in this powerpoint.
- merb 9y ago> switched from a single postgres instance did you even read the post?
- charlesetc 9y agoThere's replication, but I mean that all the data is in one pg instance, whereas there isn't a single mysql instance with all the data.
- SEJeff 9y agoHonestly I think Uber switching was more of a business decision as their employees had trouble figuring out how to properly use Postgres. Instagram definitely has different data needs, but is probably much bigger than Uber wrt data. They use Postgres successfully via Django no less! https://engineering.instagram.com/sharding-ids-at-instagram-1cf5a71e5a5c https://engineering.instagram.com/sharding-ids-at-instagram-...
- pkkim 9y agoAs someone who participated in this transition, I don't think that was a part of it. The new database layer took quite a bit of instruction to use properly as well, and there were plenty of people misusing it.
- deleted 9y ago[deleted]