In the first Scaling your Database screencast we learned how to scale our database if our website is read heavy, but how do we scale if our website is write heavy? Also, if you’re running MySQL do you know which database engine your website is using? and why? If you want the answers to these questions, or you just want to learn more about database scaling, it’s time to watch the 18th episode of the Scaling Rails screencast series.

Scaling Your Database – Part 2

Summary

In this screencast we first learn the difference between MyISAM and InnoDB storage engines. We then take a look at two strategies for scaling your database writes on a system, the first by using master master replication and the second by sharding your database. Along the way we’ll learn about some useful tools for scaling your database, and look at how some big websites like eBay and New Relic shard their database.

Don’t forget to subscribe to the screencast RSS feed or grab it on ITunes to avoid missing any of these episodes. FYI, These videos look great on an iPhone / iPod if you want something to watch on the go.