MySQL is an Oracle-based Open Source Relational Database (RDBMS) management system based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX, and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web applications and online publishing.
MySQL is an important component of a corporate open source stack called LAMP. LAMP is a web development platform that uses Linux as its operating system, Apache as its web server, MySQL as its relational database management system, and PHP as its object-oriented scripting language. (Perl or Python is sometimes used instead of PHP.)
Originally designed by the Swedish company MySQL AB, MySQL was acquired by Sun Microsystems in 2008 and later by Oracle when it bought Sun in 2010. Developers can use MySQL under the GNU General Public License (GPL), but companies need to obtain a Oracle’s commercial license.
Today, MySQL is the RDBMS behind many of the world’s top sites and numerous consumer and corporate applications, including Facebook, Twitter, and YouTube.
How MySQL Works
MySQL is based on a client-server model. The core of MySQL is the MySQL server, which handles all database instructions (or commands). The MySQL server is available as a separate program for use in a client-server network environment and as a library that can be embedded (or linked) to separate applications.
MySQL operates in conjunction with various utility programs that support the administration of MySQL databases. Commands are sent to MySQLServer via the MySQL client, which is installed on a computer.
MySQL was originally designed to handle large databases quickly. Although MySQL is typically installed on only one machine, it can send the database to multiple locations because users can access it through different MySQL client interfaces. These interfaces send SQL statements to the server and then , display the results.
MySQL Key Features
MySQL allows data to be stored and accessed on various storage engines, including InnoDB, CSV, and NDB. MySQL is also capable of replicating data and partitioning tables for better performance and durability. MySQL users do not need to learn new commands; they can access your data using standard SQL commands.
Introduction to the MySQL Starter Tutorial
MySQL is written in C and C ++ and accessible and available on more than 20 platforms including Mac, Windows, Linux and Unix. RDBMS supports large databases with millions of records and supports many data types, including signed or unsigned integers, 1, 2, 3, 4, and 8 bytes; FLOAT; DOUBLE; CHARACTERS; VARCHAR; BINARY; VARBINARY; TEXT; BLOB; MEETING; TIME; DATE TIME; TIMESTAMP; YEAR; SET; ENUM; and OpenGIS space types. Fixed and variable length string types are also supported.
For security, MySQL uses an access privilege and an encrypted password system that allows host-based verification. MySQL clients can connect to MySQL Server using various protocols, including TCP / IP sockets on any platform. MySQL also supports various client and utility programs, command line programs, and administration tools such as MySQL Workbench.
MySQL branches, also known as forks, include the following:
Drizzle, a lightweight open source database management system under development based on MySQL 6.0;
MariaDB, a popular community-developed “drop-in” replacement for MySQL that uses MySQL APIs and commands; and
Percona Server with XtraDB, an enhanced version of MySQL known for horizontal scalability.