Follow Us

Follow nosqldatabases on Twitter Follow nosqldatabases on Facebook Follow nosqldatabases on Google Buzz Follow nosqldatabases on LinkedIn Follow nosqldatabases on FeedBurner NoSQL presentations on slideshare


Become a sponsor of Contact us to find out how.

Featured Jobs


Follow On Facebook
Recent NoSQL News

« Indexing documents in MongoDB | Main | The Graph Traversal Programming Pattern (Part 3) - Graph Traversal »

From MySQL to MongoDB at Wordnik

Tony Tam from Wordnik describes their migration from MySQL to MongoDB. So why migrate from MySQL? Inserts on their MyISAMTables had approached 10 seconds an insert. They continued to produce workarounds. However, this led to an increase in system babysitting. Nothing than a fragile system to make those weeknights and weekends extra fun, right?

What are the results?

  • Moved 5 Billion rows from MySQL to MongoDB
    • Sustained 100,000 inserts/second
    • Migration tool was the bottleneck (CPU Bound)
  • Wordnik now reads from MongoDB very fast
    • Read + create java objects @ 250,000/second

What about the advice of going live with MongoDB?

  • Choose your use case carefully if migrating incrementally
  • Scary no matter what
  • Test your perf monitoring system first!
  • Use your DAOs from migration
  • Turn on MongoDB on one server, monitor, tune (rollback, repeat)
  • Full switch over when comfortable

As a follow-up Wordnik discussed in a post that they are now hosting 9 billion documents. Read more at B is for Billion

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>