Getting started with MySQL database

1. MySQLDatabase Classification and Version upgrade

As with most open-source products, the two-license policy is divided into community and commercial editions, which are released in turn in 4 different versions of the two editions. These 4 versions are:Alpha ,Beta ,RC ,GA .

2. MySQLDifferences between the business and Community editions of the database2.1. MySQLIntroduction to the commercial release of the database

The MySQL Business Edition is developed and maintained by a dedicated person within MySQL , but it also absorbs the excellent code and algorithms written by the community and is rigorously tested by a dedicated person in accordance with the software testing process. No more issues to publish. To put it simply, theMySQL Business Edition is published internally by MySQL company, while referencing the community version of the advanced code features and algorithms. is the MySQL Company's profitable products, need to pay to use and provide service support, stability and reliability is the best.

2.2. MySQLIntroduction to the database Community release

MySQL Community Edition is distributed by MySQL developers, enthusiasts and users around the world to participate in the development and testing, and to complete the management of software code, testing work, the community will also set up a BUG reporting mechanism, collect users use encountered The BUG situation is less stringent than the commercial version, the development of the Community edition, and the test environment.

2.3. MySQLthe difference between business and Community editions

The difference is:

R commercial version organization management and testing links more stringent control, stability will be more stable than the community version.

R MySQL is a mature product, and there is little difference in performance between commercial and community editions.

R commercial version does not comply with the GPL Agreement, Community Edition to comply with the GPL agreement can be free trial!

the r Business Edition needs to purchase related services, enjoy 24x7 technical support and regular patching services, but users must pay for the service.

The maintenance of R Community Edition can only be provided by the community, not like the commercial version of the failure and patch resolution services, but the community version is completely free of charge, the community version of the quality of service and timeliness and other aspects can not be compared with the commercial version.

3. MySQLDatabase4Description of the release version

The descriptions and differences between the 4 release versions are as follows:

( 1 ) Alpha version:

The Alpha version is generally only run within the company that is being developed and not publicly available. It is mainly the developers themselves to test the product, check whether the product is defective, error, verify the product features and instructions, the user manual is consistent. MySQL is an open source product that requires developers, enthusiasts, and users around the world to participate in software development, testing, and manual writing. Therefore, this version of the source code and products will be released, so that anyone can participate in the development or testing work, or even write and modify the user manual.

( 2 ) Beta version:

The beta version is generally completed after the development of the function and all the products after the test work, there will be no major features or performance bugs, and invite or provide user experience and testing, in order to more comprehensive testing software deficiencies or problems.

( 3 ) RC version:

RC version belongs to a production environment before the release of a small version, is based on the Betav version of the test results, received the bug or defect of the collected information, to repair and improve the product after the release.

( 4 ) GA version

GA version is a software PRODUCT is released products, also known as the production version of the product. In general the case. The GA version is selected for the production environment of the enterprise.

4. MySQLProduct line

5. MySQLIntroduction to naming database software

The MySQL database software name is a version number consisting of 3 digits and a suffix. For example: The version number like mysql-5.0.56.tar.gz explains:

(1) The first number (5) is the major version number, which describes the file format, and all version 5 distributions have the same file format.

(2) The first 2 digits (0) are the release level, and the major and release levels are combined to form the release sequence number

(3) The number of the first 3 digits, which is incremented for each new release, usually requires the latest version of the selected release.

' after each update, the last digit of the version string is incremented, and the second digit of the string is incremented if there is a new feature added to the previous version or there is a slight incompatibility. If the file format changes, the first number increments.

(4) suffix displays the stability level of the release. Shows how to improve stability with a series of suffixes. The possible suffixes are:

Alpha version

indicates that the release package contains a large number of new code that has not been thoroughly tested. Known flaws should be documented in the news summary, and in most of this release there are new commands and extensions, and this version may also have major code changes such as development.

Beta version

means that the version functionality is complete, and all new code is tested without adding important new features, and there should be no known flaws. When the Alpha version has not reported a fatal vulnerability for at least one months, and there is no plan to increase the new functionality that is causing the new features that have been implemented to be unstable, the version changes from Alpha to beta , and in the future Beta version, release, or product release, all APIs, external visual structures, and SQL command columns can no longer be changed.

RC version

It's a release rep; it's a beta release that's been released for a while, just adding a little bit of a fix.

No suffix

This means that the version has been running in many places for some time, and there are no non-platform-specific bug reports, which is what we call a product or a " generic " version.

6. MySQLVersion Selection final recommendation

Enterprise Production Scenarios Select MySQL Database recommendations:

R (1) Stable: Select the stable version (GA) of the Open source Community Edition.

< Span style= "font-family:wingdings" lang= "en-US" >r&NBSP;&NBSP; ( 2 ) product line: You can choose 5.1 or 5.5 . Internet company mainstream 5.5 , followed by 5.1 or 5.6 .

< Span style= "font-family:wingdings" lang= "en-US" >r&NBSP;&NBSP; ( 3 ) Select MySQL database ga after release 6 more than ga version.

R (4) to select a version that does not have a large bug fix in the months and weeks, rather than a centralized version that fixes the bug a lot.

R (5) It is best not to update the published version for a longer period of time.

R (6) consider whether the version used by the developer developer is compatible with the version you choose.

R (7) as an in-house development Test Database environment, run for about 3~6 months.

R (8) Priority Enterprise Non-core business adoption of a new version of the database GA version software.

R (9) to the experts, using the use of good GA version produced

From for notes (Wiz)

Getting started with MySQL database