Upload

Loading icon Loading...

This video is unavailable.

Migration From Oracle to MySQL : An NPR Case Study

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add tcation's video to your playlist.

Uploaded on Apr 16, 2010

Joanne Garlow (National Public Radio) speaks at the 2010 O'Reilly MySQL Conference & Expo.

Slides - http://assets.en.oreilly.com/1/event/...

From the official description at http://en.oreilly.com/mysql2010/publi...

This talk will cover what a few Oracle experts (but MySQL newbies) learned in a recent migration at NPR.org.

I will discuss how we separated our previously monolithic database into smaller, more functionally cohesive databases and some of the criteria we used to decide what tables ended up where. This architecture allowed for better load balancing and fault tolerance but it was outside our budget before we move to MySQL.

There will be a discussion of some specific differences in SQL to be aware of between Oracle and MySQL. My team put together a cheat sheet of changes in function names or signatures that I will share. We also found equivalents for sequences and Oracle Text indexes and other Oracle specific functionality in MySQL.

A few free tools we found helpful when writing code and debugging issues will be demoed and Ill explain some differences between how these tools work verses some of the Oracle tools you might be used to.

Finally Ill describe a few of the test cases we used that revealed issues with our MySQL server configuration and our own code. This will touch on some of the challenges we encountered with concurrency and encoding.

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Suggestions

Loading...
Working...
to add this to Watch Later

Add to