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

Editor to share with you what is the difference between the various versions of MySQL, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Download address of MySQL's official website: http://www.mysql.com/downloads/

There are several versions to choose from in this download interface.

1. MySQL Community Server community version, open source and free, but does not provide official technical support.

2. MySQL Enterprise Edition enterprise version, you need to pay for it, and you can try it for 30 days.

3. MySQL Cluster cluster version, open source and free. Several MySQL Server can be encapsulated into a Server.

4. MySQL Cluster CGE Advanced Cluster Edition, you need to pay for it.

5. MySQL Workbench (GUI TOOL) is an ER/ database modeling tool specially designed for MySQL. It is the successor to the famous database design tool DBDesigner4. MySQL Workbench is divided into two versions, namely the community version (MySQL Workbench OSS) and the commercial version (MySQL Workbench SE).

MySQL Community Server is open source and free, and this is the version of MySQL that we usually use. According to the different operating system platform is subdivided into multiple versions, let's take the windows platform as an example.

For example, the interface for downloading mysql 5.5.19 is as follows:

Description:

We choose Generally Available (GA) Release to download. GA refers to the general version of the software, which generally refers to the officially released version.

Mysql-5.5.19-win32.msi,windows installation package, msi installation package is installed with msiexec. Double-click under windows according to the wizard to install, simple and convenient.

Mysql-5.5.19.zip, which is the windows source file, needs to be compiled.

Mysql-5.5.19-win32.zip, which can be used after unpacking, is the compiled windows32 bit MySQL. Manual configuration is required.

The one with "winx64" is the corresponding 64-bit version, which is used on 64-bit operating systems.

Usually do background development, we will download mysql-5.5.19-win32.msi.

For example, the interface for downloading mysql 5.1.60 is as follows:

Description:

Select Generally Available (GA) Release to download. GA refers to the general version of the software, which generally refers to the officially released version.

"essentials" refers to the stripped-down version, which does not include embedded server and benchmark suite, has an automatic installer and configuration wizard, and has no MySQL documentation.

"noinstall" refers to a compressed package that is not installed. Contains embedded server and benchmark suite, there is no automatic installer and configuration wizard, need to install the configuration manually, there is MySQL documentation.

Mysql-essential-5.1.60-win32.msi is a stripped-down version, so choose this version if only mysql services are needed.

Mysql-5.1.60-win32.msi is the full version, including the installer and configuration wizard, as well as MySQL documentation.

Mysql-noinstall-5.1.60-win32.zip is a non-installed zip package, there is no automatic installer and configuration wizard, you need to install the configuration manually, there is MySQL documentation.

Mysql-5.1.60.zip is a Mysql source code compression package for windows

The one with "winx64" is the corresponding 64-bit version, which is used on 64-bit operating systems.

Generally do background development, we can download mysql-essential-5.1.60-win32.msi.

What is MySQL Enterprise Edition (MySQL Enterprise)?

MySQL Enterprise Edition is a proven and trusted platform that includes MySQL enterprise database software, monitoring and consulting services, and technical support to ensure the highest level of reliability, security and real-time performance of your business.

MySQL Enterprise Edition includes:

MySQL enterprise server, which is the most reliable and secure version of the world's most popular open source database.

MySQL enterprise system monitoring tool, which can provide monitoring and automatic consulting services to help you eliminate security risks, improve replication, optimize performance, and so on.

MySQL technical support enables you to quickly answer your thorniest technical questions.

MySQL Consulting support, which is available only to customers who have purchased MySQL enterprise silver or gold services. The MySQL technical support team will provide targeted advice to your system on how to properly design and adjust your MySQL server, planning, query, and replication settings for better performance.

What is the MySQL Community Edition (MySQL Community Server)?

MySQL has been focused on releasing the world's most popular open source database, MySQL Community Server, to the open source community.

It can be used freely under the open source GPL license.

What is the difference between MySQL Enterprise Edition and Community Edition?

At the end of 2006, MySQL began to release MySQL Enterprise, which includes a series of more robust services to improve the reliability, security and performance of MySQL server.

To better understand the difference between MySQL Enterprise Edition and Community Edition, you can get the information in the following table:

If your business meets any of the following requirements, it is recommended that you use the MySQL Enterprise Edition solution:

Other answers:

MySQL Community Edition is an open source GPL license that is available free of charge.

MySQL Network Edition is a license certified by MySQL and costs money to buy.

MySQL Web Edition is not available in MySQL Community Edition in terms of network and enterprise deployment features, debugging capabilities, technical and product support, upgrades, access to MySQL knowledge base, and direct guidance from MySQL developers.

The first MySQL Community Server, this is free!

The second MySQL Enterprise costs money, but you can call to consult the question, that is, telephone technical support.

The third MySQL Cluster, which cannot be used alone, should be used on the basis of 1 or 2. Of course, it's used to balance multiple databases.

The fourth MySQL Workbench, which is a good thing, is used to design databases. Does erwin know? That's what he does.

The MySQL Community Server community version should not provide official technical support

MySQL Enterprise Server MySQL Enterprise Edition Server

The software is the most reliable, secure and updated version of MySQL enterprise server database. It can provide e-commerce, online transaction processing (OLTP) and gigabit data warehouse applications with high performance-to-price ratio. It supports ACID transactions and provides complete commit, rollback, crash recovery, and row-level locking capabilities. MySQL database has become the most popular open source database in the world because of its ease of use, scalability and high performance.

MySQL Cluster has more than 2 mysql cluster servers

There are two versions of MySQL Workbench:

MySQL Workbench Community Edition (also known as MySQL Workbench OSS, Community Edition) and MySQL Workbench Standard Edition (also known as MySQL Workbench SE, Business Edition). MySQL Workbench OSS is an open source community version released under a GPL certificate, while MySQL Workbench SE is an annual commercial version. There are differences in functionality (it has to be said that database / model synchronization, an important feature that is only available in paid MySQL Workbench SE, is basic in DBDesigner4, and this "succession" approach is disgusting. )

MySQL-3.23.39-1.i386.rpm: contains all the files needed to run the MySQL server, including client programs

MySQL-3.23.39-1.src.rpm: contains all the source code of MySQL

MySQL-bench-3.23.39-1.i386.rpm: contains programs for testing MySQL performance, which require a master release file and Perl

MySQL-client-3.23.39-1.i386.rpm: contains only client programs

MySQL-devel-3.23.39-1.i386.rpm ": contains the libraries and header files needed to compile the client program

MySQL-shared-3.23.39-1.i386.rpm: contains shared libraries for client programs

About the system version:

Windows Essentials (x86) 6.0.7: Essentials Lite, Lite version-instance files removed

Windows ZIP/Setup.EXE (x86) 6.0.7: automatic installation version, downloaded is a zip package, decompressed with a setup.exe, you can directly run the installation

Without installer (unzip in C:\) 6.0.7:installer compressed version-Green installation-free version, unzipped will result in program files, or even equivalent to the appearance of running setup.exe, and need to be manually configured.

MySQL GUI Tools a visual interface of the MySQL database management console, provides four very easy to use graphical applications to facilitate database management and data query. These graphical management tools can greatly improve the efficiency of database management, backup, migration and query, even if users do not have a rich foundation of SQL language. They are:

MySQL Migration Toolkit: database migration

MySQL Administrator:MySQL Manager

MySQL Query Browser: a graphical client for data query

MySQL Workbench:DB Design tool

The above is all the content of what is the difference between the various versions of MySQL. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.