Shulou(Shulou.com)05/31 Report--

How to choose the most stable version of MySQL, in view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

MySQL open source database has several important branches, which are MySQL Cluster, MySQL 5.1,5.5,5.5,6.2respectively. Each branch has the same MySQL database version: Development version, Alpha version, Beta version, RC version, and GA version.

Development version, Alpha version, and Beta version are generally not used in the project. Because they must have major problems or some functions are not fully implemented. In most cases, the RC version is not allowed in a production environment, after all, it is only a small version before the production version is released. Similarly, we should choose the GA version of the MySQL database carefully. After all, open source community products have not been strictly tested and may have defects such as less stability than commercial products.

The process of selecting the GA version of MySQL database:

Since Oracle acquired SUN and its wholly owned subsidiary MySQL AB, MySQL AB officials no longer contribute source code to the open source community. At the same time, with the departure of many founders and technicians, we must carefully select the new version launched by MySQL AB, and do not blindly trust the official test report given by MySQL AB. It is recommended that you refer to the following process for selecting the GA version of MySQL database, as described below:

Analyze whether the enterprise business needs to use those basic functions and features of MySQL. The key research directions are: MySQL replication, partition table, Plugin-innodb and so on.

The first GA version of the MySQL database product line will take at least 10 months to launch before considering using it in a production environment.

The latest GA version of the MySQL database product line is generally not the preferred target, but consider the GA version of the database 3 or 4 versions later than the latest version.

Read the GA version of the target database carefully and choose this GA version carefully if you have modified a large number of BUG based on the previous version.

Read carefully the information of the first version after the GA version of the target database. If the modified BUG information is very large, please directly abandon the target version and push forward a version number as the target version.

Choose as described in steps 4 and 5 until a version after the selected version has a small amount of BUG modification, very few serious BUG, and is not the latest version of GA.

Read the BUG repair information of 2 or 3 versions of the selected database GA version in detail, mainly related to the target GA version, and find ways to reproduce it, and find ways to avoid it.

The GA version selected after the above seven steps, combined with the functions that may be needed by the enterprise business, must be tested for functionality and performance.

The selected GA version of the database, as an internal development and test database environment, usually takes about 3-6 months to trial run.

Enterprise non-core business can consider adopting the new version of GA.

After the above 10 processes, if there are no important functional BUG or performance bottlenecks, you can start to consider as a back-end database for all business data services.

Full-time DBA in many enterprises may not have so much time, effort, or resources to choose a version, or they may not be willing to spend so much time at all. Some enterprises may urgently need to choose a version of database GA, while others may not have full-time DBA at all, but will be replaced by operation and maintenance or development engineers, but they may not have the ability to select database software versions. So do we have a shortcut to choose the GA version of the MySQL database? The answer is yes. You can pay more attention to the DBA of some large companies or the well-known DBA in the industry, and ask them for advice through various channels, or you can directly consult insiders to know what the version of their core business database is.

This is the answer to the question on how to choose the most stable version of MySQL. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.