MySQL 6 is still in its alpha release stage. However, I’ve found that it takes me a long time before I am comfortable in migrating production databases to a major new database server release. And, moving from 5.x to 6.0 someday definitely qualifies as a major migration to me. So, when MySQL’s Director of Product Management, Robin Schumacher, writes to tell us that MySQL 6 has a new backup scheme, I think we MySQL users should pay attention.
Here’s the thing for Windows users. The article is based on testing using Fedora Linux on a relatively small machine (1GB RAM, single CPU). I never carried out serious MySQL on Windows vs. MySQL on Linux comparison tests with like-servers back when I ran a bunch of MySQL servers at my former job. But, my impression was that MySQL ran a lot, um, smoother (real technical term) on my Linux boxes than my Windows boxes. Now, it may have been that I had tuned my.cnf better for Linux or I did not adjust the Windows Server cache optimally. But, that was my impression.
I only ran into two major problems in the pre-virtualization days (both hardware failures). And, fortunately, my simple minded backup scheme worked as designed. But, since MySQL 6 seems to have such a different take on backup compared to version 3, 4, and 5, if I were still running MySQL servers, I would start reading about this now to get ready for it a year or two from now.