Episode #17 - Scaling Your Database - Part 1

If the bottleneck of your application is your database even after caching as much as possible, what can you do? This is the first of two screencasts where we’re going to learn about techniques for increasing the power of your Database. In this first video we learn how to grow our database step by step using both vertical and horizontal scaling.

Play Video (26.3 MB, 11:20, MP4)

Episode #18 - Scaling Your Database - Part 2

In this second screencast we start out by learning the differences between the myISAM and InnoDB database engines for MySQL.  Next we learn how to scale a write heavy database by using Master Master replication, and how we might configure this to work with our Rails application.  Lastly we’ll figure out how to shard our database by spliting our tables between multiple databases and show how both New Relic and eBay take advantage of this technique.

Play Video (31 MB, 14:20, MP4)

Jesse Proudman, Blue Box Group - pt. 2

Listen to Jesse Proudman of Blue Box Group offer insights and advice for companies deciding whether to move to a Cloud-computing environment. Topics include:

• To Cloud or Not to Cloud
• Top 3 considerations for moving to the cloud
• Key security and compliance concerns
• Managing performance SLAs
• Scaling rails applications
• The importance of memcache

Planning and Scaling Rails Deployments
Play Video (97.6 MB, 15:20, QuickTime MOV)
Play Video (185.6 MB, 15:20, MPEG-4 Video)

Jesse Proudman, Blue Box Group - pt. 1

Listen to Jesse Proudman of Blue Box Group offer insights and advice for companies deciding whether to move to a Cloud-computing environment. Topics include:

• To Cloud or Not to Cloud
• Top 3 considerations for moving to the cloud
• Key security and compliance concerns
• Managing performance SLAs
• Scaling rails applications
• The importance of memcache

Choosing the Right Hosting Environment
Play Video (68.9 MB, 10:51, QuickTime MOV)
Play Video (130.2 MB, 10:51, MPEG-4 Video)

Episode #19 - On The Edge - Part 1

This is the first of three screencasts where we begin to look at a few new Rails libraries to help you scale your Rails applications. In this first episode we take a look at Bullet, which will help you optimize your SQL queries by giving you growl notifications when you’re not using eager loading properly or should be using a counter cache. Then there’s Rails Indexes which provides Rake tasks to find missing indexes in your database. Finally the last library we’ll learn about is Scrooge, a SQL query optimizer which can reduce the amount of data getting sent from your database to your Rails application.

All of these libraries I learned about from the Ruby5 Podcast, a twice weekly audio podcast covering the latest news in the Ruby and Rails Community.

Play Video (41.4 MB, 8:49, MP4)