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

MySQL (pronounced "my ess cue el") is an open source relational database management system. Because it is open source, it can be modified according to its own needs after download. Because of its small size, high speed and low total cost of ownership, especially open source, many small and medium-sized websites choose MySQL as the website database in order to reduce the total cost of ownership.

In fact, the original starting point of MySQL is to use mSQL and their own fast low-level routines (ISAM) to join tables. In any case, after some testing, the developer concluded that mSQL is not fast or flexible enough. This leads to a new SQL interface for the database, so that the API is designed to allow third-party code written for mSQL to be more portable to MySQL. Most agree that MySQL is the best choice for managing content without the need for transactional processing.

MySQL's dolphin logo, named "sakila", was selected by the founder of MySQL AB from a large list of names suggested by users in the "dolphin naming" competition. The winning name was provided by Ambrose Twebaze, an open source software developer from Eswatini in Africa. According to Ambrose, Sakila comes from an Eswatini dialect called SiSwati, and the feminized name Sakila comes from SiSwati. Sakila is also the name of a town in Arusha, Tanzania, near Uganda, the home country of Ambrose.

The origin of the MySQL name is unknown. For a long time, our basic catalog as well as a large number of libraries and tools have adopted the prefix "my". However, the daughter of co-founder Monty Widenius is also named "My". To this day, the origin of the MySQL name is still a mystery, even to us.

The development process of MySQL

1. The history of MySQL can be traced back to 1979, when a programmer named Monty Widenius worked for a small company of TcX and designed a report tool with BASIC so that it could run on computers with 4MHz host frequency and 16KB memory. At that time, it was just a very low-level and report-only storage engine called Unireg.

2. In 1990, some of TcX's customers began to request SQL support for his API. Monty integrates it into its own storage engine directly with the help of mSQL code. Disappointingly, the effect was not very satisfactory and I was determined to rewrite a SQL support myself.

3. In 1996, MySQL 1.0 was released, which is only for a small group of people, which is equivalent to an internal release. In October 1996, MySQL 3.11.1 was released (MySQL does not have version 2.x), and at first only the binary version under Solaris was available. A month later, the Linux version appeared. Over the next two years, MySQL was ported to each platform in turn.

4. From 1999 to 2000, MySQL AB was established in Sweden. Monty hired several people to work with Sleepycat to develop the Berkeley DB engine, and since BDB supports transactions, MySQL has started to support transactions.

5. 2000 MySQL not only publishes its own source code, but also uses the GPL (GNU General Public License) license agreement to officially enter the open source world. In April of the same year, MySQL tidied up the old storage engine ISAM and named it MyISAM.

6. In 2001, InnoDB, a storage engine integrated with Heikki Tuuri, not only holds transactions, but also supports row-level locks. Later, the engine proved to be the most successful MySQL transaction storage engine. The official combined version of MySQL and InnoDB is 4.0

7. In December 2003, MySQL version 5.0 was released, which provides functions such as views, stored procedures and so on.

8. In August 2006, MySQL AB and Beijing Wanli Open Source Software Co., Ltd. jointly established MySQL China R & D Center, and the main contribution core code modules are Replication and NDB Cluster, which also marks Wanli Open Source as one of the earliest domestic companies to enter the core code research and development of international mainstream databases.

9. In January 2008, MySQL AB was acquired by Sun for $1 billion, and MySQL database entered the Sun era. In the era of Sun, Sun has done a lot of work on its promotion, optimization, Bug repair and so on.

MySQL 5.1 was released in November 2008, which provides partitioning, event management, and row-based replication and disk-based NDB cluster systems, while fixing a large number of Bug.

Oracle acquired Sun for $7.4 billion in April 2009. since then, MySQL database has entered the Oracle era, while its third-party storage engine InnoDB was acquired by Oracle as early as 2005.

MySQL 5.5 was released in December 2010. its main new features include semi-synchronous replication and support for exception handling of SIGNAL/RESIGNAL, and most importantly, the InnoDB storage engine has finally become the default storage engine of the current MySQL. MySQL 5.5 is not a simple version update after two years, but strengthens all aspects of MySQL at the enterprise level. Oracle also promises that MySQL 5.5 and future versions will remain open source products licensed by GPL.

MySQL has been widely spread because of its open source, which also makes more people know about this database. Its history is also legendary. Here only as a story to explain the history of the development of MySQL, many versions will be different on the Internet. As more and more technical developers join the development of MySQL, the development will be better and better.

-

Copyright notice: this article is the original article of CSDN blogger "zyj66666", in accordance with the CC 4.0BY-SA copyright Agreement. Please attach the original source link and this statement for reprint.

Original link: https://blog.csdn.net/zyj66666/article/details/74003041

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.