MySQL

0
1169
mysql

MySQL is a global relational database system and probably the most widely used application in this category. The software is available as a free open-source version as well as a commercial version for various operating systems. Many web hosting providers offer the ability to integrate MySQL as part of their packages. Numerous dynamic websites use the software as a basis.

The history and origin of MySQL

MySQL was developed in the year 1994 by the Swedish company MySQL AB, which was acquired by Sun Microsystems 2008. These two companies have been part of the California Oracle Corporation since the year 2010. The name came from the first name of the daughter of Michael Wildenius, one of the founders of the company. Wildenius and Axmark started 1994 with the development of the database system. Initially, it served as a clone for MySQL and should provide databases of the UNIREG software for web applications. In the year 1995 an internal release took place, 1997 the application under the version 3.1 was published. This should 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 designed for excellent performance. In part, this was at the expense of availability and stability. At the beginning, the scope of functions was limited, only a few types of tables and no transactions were possible. In January 2001 came the version 3.23 on the market, which enabled transactions and had two types of tables. In March 2003 was followed by release 4.0, 2004 4.1 end and in October 2005 release of MySQL 5.0, each with advanced features. In November 2008 was released version 5.1, 2012 followed MySQL 5.6. 5.7 followed in October and the 5.7.17 release was 2016 in mid-December.

MySQL - the basis of many dynamic websites

The relational database system is available free of charge as an open source version as well as in a commercial version for different operating systems. MySQL consists of several administration programs, a database, user 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 operate a large number of MySQL servers. The system can run under Windows, Linux, Unix, Mac OSX, i5 / Os, Open VMS, among others, and there are more than 20 platforms in total. Many web hosting providers offer MySQL as part of their software packages. An official manual is available, and free support is offered in numerous forums and user groups. Oracle offers support licenses of various performance levels for its Enterprise Edition, but for a fee. Often there is a combination with other software applications or environments for the Hosting dynamic websites.

The characteristics of MySQL

The database system was written in the programming languages ​​C and C ++. It uses kernels that allow multi-threading. The software can therefore take advantage of multiple CPUs, if they exist. A high processing speed and optimal management of the memory are guaranteed. At the same time, you can create and manage multiple databases on a MySQL server. Depending on the operating system, the number of tables used varies. The software makes access to records possible, as well as delete, modify or add. Individual databases can be partitioned, so the working speed can be improved. Content management systems can use MySQL as a reliable and powerful database (eg WordPress, TYPO3, Drupal or Joomla).

The advantages of MySQL

MySQL stores, manages, displays and modifies the data in spreadsheets, while at the same time functioning 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 permissions management and optimal performance. Furthermore, it is very flexible due to its compatibility with more than twenty different platforms.