11 Steps to choose the most stable version of MySQL Source:CSDNNetworkPosted in:2012-07-18 08:36Click: MySQL open source database has several important branches, currently has the following branches: MySQL Cluster, MySQL 5.1, MySQL 5.5, MySQL 6.2. Each branch has the same version of MySQL database: Development version, alpha version, beta version, RC version, and GA version. The development version, alpha version, and beta MySQL open source database have several important branches, currently with the following branches: MySQL Cluster, MySQL 5.1, MySQL 5.5, MySQL 6.2. Each branch has the same version of MySQL database: Development version, alpha version, beta version, RC version, and GA version.
Development versions, alpha versions, and beta versions are generally not used in projects. Because they must have significant problems or some features are not fully implemented. In most cases, the RC version is not allowed in the production environment, after all, it is only a small version of the production version before the release. Similarly, for the GA version of MySQL database, we also have to choose carefully. After all, the open source Community products are not rigorously tested and may have weaknesses that are weaker than the stability of commercial products.
MySQL Database GA version selection process:
MySQL AB officially no longer contributes source code to the open source community since Oracle acquires Sun and its wholly owned subsidiary, MySQL AB. At the same time, with a number of founders and technical personnel to run away, everyone to MySQL AB company launched a new version must be carefully selected, do not blindly believe that MySQL AB official test report. We recommend that you refer to the following procedures for selecting the MySQL database GA version as follows:
- Analyze whether the enterprise business needs to use the basic functions and features of MySQL, the characteristics of the main research direction is: MySQL replication, partition table, Plugin-innodb and so on.
- MySQL database product line the first GA release time, at least more than 10 months, and then consider the use of the production environment.
- MySQL database product line of the latest GA version, generally do not as a preferred target, you can consider the latest version of the version of the GA version of the database.
- Carefully read the information of the target database GA version, and if a large number of bugs have been modified on the basis of the previous version, this GA version is carefully chosen.
- Carefully read the first version of the target database after the GA version of the information, if the modified bug is very informative, please discard the target version directly, push forward a version number as the target version.
- Choose from the approach described in step IV, until a version after the selected version, bug modification is small, serious bugs are rare, and not the latest GA version.
- Read more about two or three versions of bug fixes after the selected database GA version, mostly related to the target GA version, and try to reproduce it, and find a way to circumvent it.
- For the GA version selected in the seven steps above, functional testing and performance testing are required in conjunction with the functionality that the enterprise business may require.
- The selected database GA version, as an in-house development test database environment, typically runs for approximately 3-6 months.
- The non-core business of the enterprise may consider adopting the new GA version.
- After the above 10 operations, if there are no significant feature bugs or performance bottlenecks, you can begin to consider the backend database as all of the business data Services.
Many enterprise DBAs may not have the time, effort, or resources to choose a version, or they may not be willing to spend so much time. While some enterprises may need to choose a database GA version, and some enterprises do not have full-time DBA, but by operations or development engineers to replace this role, but they may not have the ability to select the database software version. So do we have a shortcut to the MySQL database GA version selection? The answer is yes. You can focus more on the DBA of a large company or a well-known DBA in the industry, ask them through multiple channels, or you can consult insiders directly to find out how many of their core business database versions are.
11 Steps to choose the most stable MySQL version
