How to Install MySQL on Ubuntu 16.04 LTS?

Introduction

MySQL is a relational database that is used to store data. It is most widely used database provides set of advance features, management tools, technical support, scalability and security. It is a product of Oracle Corporation and first released on 23 may 1995.

RDBMS manages data into one or multiple data tables where data may be associated with each other. These types of relations aid in structuring the data. An RDBMS, such as MySQL, operates with OS to work with a relational database in the storage system, permits network access, manages users, backup creation, and provides a testing database of a computer in addition to SQL and relational database.MySQL includes stand-alone clients that permit users to directly interact with MySQL database with SQL.

Overview of MySQL

MySQL is specified in C++ and C. Its SQL parser is specified in yacc. MySQL works on various system platforms, such as Tru64, SCO UnixWare, Sanos, SCP OpenServer, Symbian, SunOS, Solaris, QNX, Oracle, OpenSolaris, OS/2 Warp, Novell NetWare, OpenBSD, NetBSD, macOS, Microsoft Windows, IRIX, Linux, IBM i, ArcaOS, FreeBSD, eComStation, HP-UX, AIX, and BSDi,. A MySQL port to OpenVMS exists as well.

The MySQL server software and the client libraries utilize dual-licensing distribution. These both are provided upon GPL V2 or a proprietary license.

The official manual can provide support. Additionally, free support is available in specific IRC forums and channels. Oracle provides paid support with MySQL Enterprise products. They are different in price and service scope. Several third-party enterprises are additionally available to offer services and support.

Brief History of MySQL

MySQL was developed by MySQL AB, a Swedish company, discovered by Allan Larsson, Swedes David Axmark, and Finland Swede Michael "Monty" Widenius. The actual MySQL development was started in 1994 by Axmark and Widenius.

Initially, it was developed for personal use from low-level ISAM language-based mSQL, which the developers considered inflexible and too slow. They developed a SQL interface, although keeping a similar API to mSQL. Consistent API using the mSQL system, several developers can use MySQL rather than the MySQL antecedent.

Features of MySQL

MySQL has two editions. The first one is the Proprietary Enterprise Server, and the second one is the open-source MySQL Community Server. Some important features in MySQL 5.6 are listed below:

Supports cross-platform facility
A large ANSI SQL 99 subset and extensions
Stored procedures with the help of a procedural language that observes PSM/SQL closely
Updatable views
Triggers
Information schema
Cursors
Online DDL if utilizing the InnoDB Storage Engine.
X/Open XA DTP (distributed transaction processing) support
Savepoint transactions when utilizing the default InnoDB Storage Engine.
SSL support
Sub-SELECTs
Query caching
Support for built-in replication
Unicode support
Commit grouping, collecting multiple transactions using multiple connections to increase the count of commits/second.
The developers publish MySQL Server's minor updates.

Project Forks of MySQL

Several MySQL forks are available, including the below:

Current

Percona Server for MySQL: It is forked via Percona and concentrates on retaining compatibility using the MySQL releases (Official). XtraDB is also added to Percona Server for MySQL. XtraDB is the fork of Percona of the InnoDB Storage Engine.
MariaDB: It is a MySQL RDBS community-developed fork intended to be freed upon the GNU GPL. MariaDB has been governed by the actual MySQL developers, who angled it because of a few considerations about its acquisition via Oracle.

Abandoned

WebScaleSQL: It was the MySQL 5.6 software branch and was introduced on 27 March 2014 by Twitter, LinkedIn, Google, and Facebook as a combined effort to offer a centralized integration structure to extend MySQL along with new aspects specific to the large-scale deployments, including creating replicated databases executing on many server farms. WebScaleSQL focused on supporting MySQL development in large-scale environments. The source code of the project is licensed upon V2 of the GNU GPL and hosted over GitHub.
Drizzle: It was an open-source/free software RDBS that was forked with the new-defunct 6.0 MySQL DBMS development branch. Drizzle includes a server/client architecture and utilizes SQL as the main command language, like MySQL. Drizzle was shared under the 2 and 3 versions of the GNU GPL with portions, such as the replication messaging and protocol drivers, upon the BSD license.
OurDelta: This distribution was developed by Open Query, an Australian company that had two different versions. The first version is 5.0, which is MySQL-based, and the second version is 5.1, which is MariaDB-based. It added patches designed via Open Query and other important MySQL community members, including Google and Jeremy Cole. When the patches were added to the mainline of MariaDB, the objectives of OutDelta were obtained, and OurDelta passed over its packaging toolchain and build to Monty Program.

In this tutorial, we will install MySQL on Ubuntu 16.04 LTS. This whole process includes the following steps.