Barefoot From MySQL to Cassandra and Back, and Where to Stub Your Toes
So you're trying to migrate your MySQL infrastructure to Cassandra. You've seen that Cassandra can use tables just like your favorite RDBMS, and even has a Query Language that looks functionally identical to SQL. In fact, almost everything during your initial evaluation hints at being able to dump a MySQL DB schema into a Cassandra setup and everything will be wonderful from that point on... Stop right there! You're going to stub your toe a few times! This talk discusses the similarities and differences between Cassandra and MySQL, and the trap of assuming that anything you can do in one system can be done in the other. We will explore the good and bad reasons of why organizations want to migrate, and compare the commitment and level of maintenance that gets dedicated to each platform. We will also look at RDB concepts that you will have to "unlearn" as one gets further into Cassandra.
MySQL DBA, Tivo
Solomon Chang is a fully certified MySQL DBA, working for Oracle ACS supporting Visa Inc.. He is a co-author of the MySQL Cluster Certification Study Guide and was a former president of LAMPSIG of Los Angeles. He exhibits an unnatural fondness for anything caffeinated.