Introduction to MySQL :
MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael “Monty” Widenius. The first version of MySQL appeared on 23 May 1995. It was initially created for personal usage from mSQL based on the low-level language ISAM, which the creators considered too slow and inflexible. They created a new SQL interface, while keeping the same API as mSQL. By keeping the API consistent with the mSQL system, many developers were able to use MySQL instead of the (proprietarily licensed) mSQL antecedent.
MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyzer.MySQL works on many system platforms, including AIX, BSDi, FreeBSD, HP-UX, eComStation, i5/OS, IRIX, Linux, OS X, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos and Tru64. A port of MySQL to OpenVMS also exists.
The MySQL server software itself and the client libraries use dual-licensing distribution. They are offered under GPL version 2,beginning from 28 June 2000 (which in 2009 has been extended with a FLOSS License Exception) or to use a proprietary license.
Support can be obtained from the official manual.Free support additionally is available in different IRC channels and forums. Oracle offers paid support via its MySQL Enterprise products. They differ in the scope of services and in price. Additionally, a number of third party organisations exist to provide support and services, including SkySQL Ab and Percona.
MySQL has received positive reviews, and reviewers noticed it “performs extremely well in the average case.” and that the “developer interfaces are there, and the documentation (not to mention feedback in the real world via Web sites and the like) is very, very good”.It has also been tested to be a “fast, stable and true multi-user, multi-threaded sql database server”.
MySQL Version 5.7 :
New version of the world’s most popular open source database is up to 3x faster than MySQL 5.6 in benchmark tests.
Oracle today announced the general availability of MySQL 5.7, the latest version of the world’s most popular open source database. The new version delivers greater performance, scalability and manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases.
— MySQL (@MySQL) October 19, 2015
“MySQL 5.7 delivers a wide range of innovations allowing developers, database administrators and DevOps teams to build and manage next-generation Web and cloud-based applications capable of processing ever increasing volumes of data,” said Tomas Ulin, vice president, MySQL Engineering, Oracle. “MySQL 5.7 builds upon Development Milestone Releases that have enabled users to preview, test and provide feedback during the development process – and as a result, this release has been a collaborative process involving many members of the MySQL community.”
— heise Developer (@heisedc) October 19, 2015
— Vishal Sharma (@vishne0) October 19, 2015
Ulin will provide an overview of what’s new in MySQL 5.7 during the upcoming MySQL Central @ OpenWorld “State of the Dolphin” address in San Francisco on Monday, October 26 at 4.00 pm. Additionally, a webcast will be held on November 11, 2015, at 9.00 a.m. US Pacific Time.
— stoker (@stoker) October 19, 2015
“Booking.com’s initial testing of the Development Milestone Releases has shown promising improvements that will enable us to perform online configuration and schema changes with less downtime,” said Nicolai Plum, senior systems architect, Booking.com. “The multi-source and parallel replication improvements in MySQL 5.7 GA will help us to continue scaling our global e-commerce business with ease and we look forward to deploying it soon.”
Key enhancements in MySQL 5.7, which deliver greater performance and scalability, include:
In benchmark tests using SysBench Read-only Point-Selects, at 1,024 connections, MySQL 5.7 delivered 1,600,000 queries per second (QPS) — 3x faster than MySQL 5.6.
New capabilities include increased performance and concurrency, enhanced on-line operations, spatial indexes, native partitioning and more.
Enhancements to MySQL’s replication features include multi-source replication, enhanced Global Transaction Identifiers (GTIDs), and improved multi-threaded slaves for better scalability and availability.
A new MySQL optimizer dynamic cost model provides better query performance and greater user control.
Primary manageability enhancements within MySQL 5.7 include:
Allows for efficient and flexible storage, search and manipulation of schema-less data. Enhancements include a new internal binary format, support for easy integration within SQL, and index management on the JSON Documents using generated columns.
Enables instrumentation for memory, transactions, stored routines, prepared statements, replication and locks.
Provides helper objects that answer common performance, health, usage and monitoring questions.
Delivers easier and safer instance initialization, setup and management.
Provides spatial index support in InnoDB, GeoJSON and GeoHash support.
Also now generally available is the new MySQL Router, which simplifies application development by intelligently routing queries to MySQL databases for increased performance and uptime. MySQL Router also provides cross-language support for MySQL Fabric, making it simpler to manage groups of MySQL databases and delivering both high availability and scalability through automated data sharding.
For early testing and feedback, MySQL Group Replication is available at http://labs.mysql.com. Group Replication delivers active/active write-anywhere replication clusters to MySQL, with support for automatic conflict detection and resolution.
MySQL 5.7 is scheduled to be available for download at http://dev.mysql.com/downloads/ on October 26, 2015. Terms, conditions and restrictions apply.