News for hackers. Stuff that matters.
Re:Sharding and IDs at Instagram by mncaudill on Friday September 30, 2011 @08:01PM (#3058957)
I work at Flickr and I see they mentioned Flickr's ticket server idea, (ab)using MySQL's autoincrement and "REPLACE INTO" trick and mentioned that a con was the write bottleneck.

We're generating more GUIDs than ever with this system and those boxes are more or less idle on every metric. They're right in that we don't meet their time-ordered requirement, but I just wanted to say that writing (or reading) is not a bottleneck.

Re:Sharding and IDs at Instagram by mikeyk on Friday September 30, 2011 @08:08PM (#3058978)
Thanks for the info, I updated the post to mention that the write bottleneck isn't an issue at Flickr.
Re:Sharding and IDs at Instagram by mncaudill on Friday September 30, 2011 @08:11PM (#3058981)
Thanks!

I like that you guys are using your database's stock features to accomplish this. Most of the time you don't need complicated systems to get things done. Reducing that mental overload of YET another system is huge.