Shulou(Shulou.com)06/01 Report--

How to choose the version of MySQL database? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

Point one:

MySQL8.0 is not a stable version at the moment because its distribution model has changed and each small version has "new features".

Take the latest MySQL8.0.20, for example, which changed the format of redo log, resulting in incompatibility of the physical backup tool xtrabackup.

Because each version has new features, it is possible to trigger an unknown bug.

No one just said, I use MySQL8.0, but I don't need his new features, okay?

The answer is: NO, he all changed the format of redo log, changed the optimizer, this kind of basic code modification.

Point two:

Triggering an unknown bug is not a terrible thing. The terrible thing is that you can not repair, at present, domestic experts with repair MySQL source code level are basically gathered in the head of the Internet in the big factory.

It is important that second-and third-tier Internet vendors basically do not have the experts to repair MySQL source-level bug. Because modifying the source code of MySQL is not something one person can do, even if you can read the source code. But I can't fix the source code bug. I really dare to fix bug, but do I really dare to go online?

Fixed this problem and successfully solved the bug, but it is possible that the modified code triggered a new bug, which then had an impact on the online business, and the performance was cool this month. # in other words, if a big head factory dares to join MySQL8.0, they do have some technical reserves. Do you know what efforts people have made to get into MySQL8.0?

So which version should you choose?

MySQL5.7 or MySQL5.6, of course.

MySQL5.7 and MySQL5.6 are used a lot, everyone is using them, and they have experienced large-scale use. Basically does not trigger a deadly bug. The life cycle of MySQL5.6 and MySQL5.7 is approaching, and I personally think it's a good thing to upgrade the existing MySQL to the latest MySQL5.6 and 5.7 subversions. When you encounter bug, you can tell your boss that MySQL5.6 and 5.7officially do not update the sub-version. As a matter of fact, it is impossible to fix it, but I can tell you how to avoid it and make do with it. If you have to fix it, you can sell the enterprise version of MySQL or use Oracle. In fact, the biggest problem now is that 1.MySQL8.0 is unstable and each version has new features. two。 Few people use it, and there is no large-scale application yet. 3. The surrounding components may not be compatible enough. 4.MySQL8.0 hop version. This version of MySQL8.0.5-MySQL8.0.10 has been skipped, in fact, the current MySQL8.0.20 is MySQL8.0.15. Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.