The development history of cloud database MySQL

The development history of cloud database MySQL

Want to know more about MySQL database: Getting started with MySQL database

(This course takes you to understand the world of databases through the most popular open source database MySQL. Let Xiaobai also be able to master common database usage skills and understand the storage structure of databases, suitable for introductory database learners and front-end learners!)

The history of MySQL can be traced back to 1979. At that time, Oracle was just a little trouble, and there was no shadow of Microsoft's SQL Server. There is a person named Monty Widenius, who works for a small company called TcX, and designed a report tool in BASIC, which can run on a computer with 4M clock speed and 16KB memory. Soon after, this tool was rewritten in C language and ported to the Unix platform. At that time, it was just a very low-level report-oriented storage engine. This tool is called Unireg.
However, this small company has limited resources and Monty is extremely talented. In the face of the disadvantages of limited resources, he is more able to realize his potential, always trying to write the most efficient code. And thus formed a habit. There are some other colleagues with Monty. Few people can persist in writing those codes until 20 years later, but Monty did.
In 1990, some of TcX's customers began to request SQL support for its API. At that time, some people thought of using commercial databases directly, but Monty felt that the speed of commercial databases was unsatisfactory. Therefore, he directly used the mSQL code to integrate it into his storage engine. Unfortunately, the effect is not very good. As a result, Monty became ambitious and determined to rewrite a SQL support himself.
In 1996, MySQL 1.0 was released, only for a small group of people, which is equivalent to an internal release. In October 1996, MySQL 3.11.1 was released, ha ha, there is no 2.x version. Initially, only the binary version under Solaris was provided. A month later, the Linux version appeared.
In the next two years, MySQL was ported to various platforms in turn. When it was released, the licensing strategy adopted was somewhat different: free commercial use was allowed, but MySQL could not be bundled with its own products for release. If you want to publish together, you must use a special license, which means it costs money. Of course, commercial support also needs money. Others, whatever the user can use. This special license has brought some revenue to MySQL, thus laying a good foundation for its continued development. (Think about it, PostgreSQL has been limited to a low point for several years, which may be related to its completely free, without any restrictions).
MySQL3.22 should be an iconic version that provides basic SQL support.
The first version of MySQL relational database was released in January 1998. It uses the multithreading mechanism provided by the core of the system to provide a complete multithreading operation mode, provides programming interfaces (APIs) for programming languages such as C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl, and supports multiple field types And provides a complete operator to support the SELECT and WHERE operations in the query.
MySQL is open source, so anyone can download it under the General Public License and modify it according to individual needs. MySQL has attracted much attention because of its speed, reliability and adaptability.
From 1999 to 2000, a company was established in Sweden, called MySQL AB (AB means "stock company" in Swedish). I hired a few people and worked with Sleepycat to develop the Berkeley DB engine. Because BDB supports transaction processing, MySQL has since supported transaction processing.
In April 2000, MySQL organized the old storage engine and named it MyISAM. At the same time, in 2001, Heikiki Tuuri proposed to MySQL, hoping to integrate their storage engine InnoDB, which also supports transaction processing and row-level locks.
Now, unfortunately, both BDB and InnoDB seem to have been acquired by Oracle. In order to eliminate competitors, even if they are open source, they are unscrupulous.
The official combined version of MySQL and InnoDB is 4.0.
To MySQL 5.0, in December 2003, there began to see things such as View, stored procedures, of course, there were many bugs in the meantime.
On January 16, 2008, MySQL was acquired by Sun.
Recently, Monty Widenius, the founder of MySQL, has submitted his resignation to Sun. head is going to go.
It is said that the company acquired by Sun is so fateful, I don't know what the future will be like for MySQL, I hope it will go well all the way. I believe that the vitality of MySQL is still very long.

Today, the combination of mysql and php is absolutely perfect. Many large websites also use mysql database. The development prospect of mysql is very bright!

More quality courses:

Alibaba Cloud University official website (Alibaba Cloud University-official website, innovative talent workshop under the cloud ecology )