What happens when you pick the wrong data store? A few years ago, open source web application Diaspora did just that. We started out on MongoDB, and then after eight months in production, switched to MySQL.
With eight months of production data to convert, it was not a switch we made lightly. I'll talk about the mechanics of how it was done, as well as the motivations for the original choice, and how we knew when it was time.