Migration From Oracle to MySQL : An NPR Case Study

Location: Ballroom B Level: Novice

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 I’ll explain some differences between how these tools work verses some of the Oracle tools you might be used to.

Finally I’ll 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.

Joanne Garlow

National Public Radio

With over 20 years experience in computer programming, I have worked at places as varied as NASA, NCI as well as NPR.org doing everything from embedded C++ to supply chain algorithms to website development to Oracle DBA. I am currently working mostly in Java, JSP, Struts and PHP all with way too much Javascript running on Debian and MySQL.

Comments on this page are now closed.


Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/16/2010 9:57am PDT

The video for this presentation is online at www.youtube.com/watch?v=V3X...

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.