Loading half a billion rows into MySQL

derwiki – Loading half a billion rows into MySQL.

Wow, I’ve never worked with databases as big as the one mentioned in the article, but I’m fascinated by the updates that were made to optimize 500 million table sharded records into a single table all the while increasing performance.

Over time I’ve struggled with large CMS database migrations so it’s of particular interest to me to check out the descriptions behind the decisions the author made, really interesting stuff.