MySQL is an open-source relational database management system (RDBMS) and probably the most popular RDBMS. The MySQL name is a combination of "My", the name of co-founder Michael Widenius' daughter, and "SQL", the abbreviation for Structured Query Language. It works on most operating systems including Windows, Linux, Solaris, and FreeBSD. MySQL is also part of LAMP, an open-source web application software stack; LAMP is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. It is also part of popular applications such as Joomla, WordPress, Drupal, etc. It is also used by popular websites such as Google, YouTube, Facebook, Twitter, Flickr, etc.
MySQL was initially owned and managed by a Swedish firm MySQL AB which was later acquired by Oracle Corporation. MySQL was developed by Widenius and Axmark in 1994 and first released in May 1995; the latest stable version, at the time of this writing, MySQL 5.7.17 was released in December 2016. MySQL source code is available under the terms of the GNU General Public License. It also follows a dual-licensing model with several paid editions available for proprietary use that offer additional functionalities such as paid support.
MySQL was written in C/C++ programming languages and its SQL parser was written in yacc. Users can also graphically administer MySQL databases and visually design database structures using the integrated MySQL Workbench, also developed by MySQL AB. Additionally, MySQL features include:
- Supports creation of subqueries, updatable views, cursors, stored procedures, and triggers
- Implements broad subset of ANSI SQL 99 standard, as well as extensions.
- API support for JDBC (Java), VB, C#, etc.
- Uses multiple native storage engines InnoDB, MyISAM, Merge, Memory (heap), Federated, Archive, CSV, Blackhole, NDB Cluster with option to select independently for each table. InnoDB Storage Engine allows transactions with savepoints, online DDL, and distributed transaction processing (DTP) support with two phase commit.
- Complies with ACID properties when using InnoDB and NDB Cluster Storage Engines.
- Allows full-text indexing and searching
- Embedded database library and support for Unicode characters
- Allows caching of queries for efficient processing
- Highly secured with SSL support
- Allows to collect multiple transactions and commit them together.
- Includes information schema and performance schema that collects and collects statistics about server execution and query performance for monitoring purposes. One can also control runtime behavior with SQL Mode options.
- Includes replication functionality with one master per slave, many slaves per master.
More on Free and Open Source software, their fundamentals, philosophy, development models and business models in ...
To Order this book click here