Solomon Chang, MySQL DBA, Tivo delivers his talk, "Barefoot From MySQL to Cassandra and Back, and Where to Stub Your Toes", on DAY 3 of the Percona Live Open Source Database Conference 2017, 4/27, at Santa Clara, CA.
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.
Google Cloud Platform: MySQL at Scale with Reliable HA
NoSQL Endgame - PLO October 2020
Analytical Queries in MySQL - PLO October 2020
MySQL Ecosystem on ARM - Krunal Bauskar - Percona Live ONLINE 2020
How Does Geo-Replication Work in TiDB? - Jay Lee - Percona Live ONLINE
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020