MySQL and Server Software
In MySQL is defined as a database management system. It is suitable for different operating system or as software for open source. For dynamic websites, it is the appropriate basis.
Developed. It was entickelt schwedischn of the company MySQL AB and acquired in 2008 by Sun Microsystems. Sun Microsystems was 2010 in the possession of wine from Oracle.
The program is both a Licensed Product, on the other hand, a free software.
The composition of MySQL Created one of the first name of the daughter of the co-founder, and the SQL code which means "structured query language" means.
The software runs on Linux, Windows, OS / 2, MacOS, and Unix. In Windows, there is however a restriction.
The program is set up, here are several databases to one another. It can exestieren in the database several tables. The tables can be different. A maximum size is determined only by the appropriate operating system.
An earlier version of SQL (3.0) provided only a limited language range, a more recent version (5.0) offers a greatly expanded language support.
As of version 3.23 you can have access to a replication system. It is being used in computer clusters. In this system the more databases are assigned.
The most common use of MySQL is used for data storage for web services. It is very often associated with the Apache Web server and PHP (scripting language) is preferred. Many services on the Web run several MySQL servers. Included also is used as the database system.
It is the most widely database system in the world. 64 000 downloads a day and about 6 million installations are made. As it comes to Twitter, Wikipedia, and Google YouToube used.
Because of the perfomance, it is primarily in ANSI C + + and ANSI C installed.
1994 MySQL as a clone was programmed for mSQL to provide Anwedungen in Web databases.
In 1997, the software with the version 3.21 was introduced to the market. The software was designed for fast performance and huge Datenmegen what was at the expense of stability.
With the version 3.23 is possessed with transactions with two types of tables.
In March 2003, the 4.0 version was launched and had a feature where you could cache results (query cache).
In October 2004, version 4.1 was available. With it, you could save in the tables different character sets. There were also supports Unicode.
The 5.0 release came in October 2005 on the market. They support all types of objects in SQL3 standard (user defined function, stored procedure, trigger, index, alias, view).
A 5.2 version was available as an alpha test, but was later merged with the 6.0 version.