As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth. One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier. However, in many cases, this is in no way a trivial undertaking.
Another approach that has been gaining interest is the use of MyRocks as an alternative storage engine to the traditional InnoDB. While not for everyone, in certain use cases it could be a potential solution. As with so many things open source, the next standard questions are: which version should I use? Any differences with the engine if I use MyRocks with MySQL 5.7 vs 8.0?
In this post, I wanted to touch on this and give some high-level thoughts on MyRocks when it comes to the version of MySQL.
…
[Read more]