MySQL is a relational database system used worldwide and probably the most frequently used application in this Category. Available is the Software as free open source version as well as commercial version for different operating systems. Numerous Web hosting-Provider offer the possibility to integrate MySQL as part of their packages. Numerous dynamic web presences use the software as a basis.
The history and development of MySQL
MySQL was developed in 1994 by the Swedish company MySQL AB, which was acquired by Sun Microsystems in 2008. Since 2010, these two companies have been part of the Californian Oracle Corporation. The name originated from the first name of the daughter of Michael Wildenius, one of the company founders. Wildenius and Axmark started developing the database system in 1994. Initially it served as a clone for MySQL and was intended to Databases the UNIREG software for web applications. In 1995 an internal release took place, in 1997 the application was published under version 3.1. This was to signal that the core of MySQL already has a long history. Right from the start, the software was able to process large amounts of data and was based on excellent Performance laid out. Partly this was due to Costs availability and stability. At the beginning, the range of functions was limited, only a few table types and no transactions were possible. In January 2001, Version 3.23 was released, which allowed transactions and had two table types. Version 4.0 followed in March 2003, 4.1 at the end of 2004 and the release of MySQL 5.0 in October 2005, each with extended Functions. Version 5.1 was released in November 2008, followed by MySQL 5.6 in 2012. 5.7 followed in October, the release of version 5.7.17 was mid-December 2016.
MySQL - the basis of many dynamic websites
The relational database system is both free of charge is available as an open source version as well as a commercial version for different operating systems. MySQL consists of several administration programs, a Databaseuser interfaces and libraries. In connection with PHP and Apache it forms the basis of many dynamic websites. It has been installed on more than 50 million servers worldwide. Google, Twitter, Facebook & Co. use its architecture and run a large number of MySQL servers. The system is executable under Windows, LinuxUnix, Mac OSX, i5/Os, Open VMS, in total there are more than 20 platforms. Many web hosting providers offer MySQL as part of their software packages. An official manual is available, free support is offered in numerous forums and user groups. Oracle offers for its Enterprise-Edition support licenses of the different service levels, but for a fee. Often a combination with other software applications or environments for Hosting of dynamic web pages.
The features of MySQL
The database system was written in the programming languages C and C++. It uses kernels that make multi-threading possible. The software can therefore use the Advantages of several CPUs, if they are available. A high processing speed and optimal memory management are guaranteed. At the same time you can use a MySQL-Server multiple databases create and manage. Depending on the operating system, the number of tables used varies. The software makes it possible to access records, as well as delete, modify or add records. Individual databases can be partitioned, thus improving the working speed. Content Management systems can use MySQL as a reliable and powerful database (e.g. WordPress, TYPO3, Drupal or Joomla).
The advantages of MySQL
MySQL stores, manages, displays and changes the Data in tables, at the same time it works as a client-server. This means that the respective database acts as a server. The database system works fast, user-friendly and stable. Another advantage is its multithreaded and multi-user capability, easy authorization management and optimal performance. Furthermore it is very flexible due to its compatibility with more than twenty different platforms.