What's up guys, about this article we know what is MySQL its features, and its advantages and disadvantages.
What is MySQL?
MySQL is an open-source relational database management system. As with other relational databases, MySQL stores data in tables made up of rows and columns. Users can define, manipulate, control, and query data using Structured Query Language, more commonly known as SQL. MySQL’s name is a combination of “My,” the name of MySQL creator Michael Widenius’s daughter, and “SQL”.
A flexible and powerful program, MySQL is the most popular open-source database system in the world. As part of the widely-used LAMP technology stack (which consists of a Linux-based operating system, the Apache web server, a MySQL database, and PHP for processing), it’s used to store and retrieve data in a wide variety of popular applications, websites, and services.
MySQL has been offered under two different editions: the open-source MySQL Community Server and the proprietary Enterprise Server. MySQL Enterprise Server is differentiated by a series of proprietary extensions which install as server plugins, but otherwise, share the version numbering system and are built from the same code base.
Major features as available in MySQL 5.6:
A broad subset of ANSI SQL 99, as well as extensions
Stored procedures, using a procedural language that closely adheres to SQL/PSM
Online Data Definition Language (DDL) when using the InnoDB Storage Engine.
Performance Schema that collects and aggregates statistics about server execution and query performance for monitoring purposes.
A set of SQL Mode options to control runtime behavior, including a strict mode to better adhere to SQL standards.
X/Open XA distributed transaction processing (DTP) support; two-phase commit as part of this, using the default InnoDB storage engine
Transactions with savepoints when using the default InnoDB Storage Engine. The NDB Cluster Storage Engine also supports transactions.
ACID compliance when using InnoDB and NDB Cluster Storage Engines
Sub-SELECTs (i.e. nested SELECTs)
Built-in replication support
Asynchronous replication: master-slave from one master to many slaves or many masters to one slave
Semi synchronous replication: Master to slave replication where the master waits on replication
Synchronous replication: Multi-master replication is provided in MySQL Cluster.
Virtual Synchronous: Self-managed groups of MySQL servers with multi-master support can be done using: Galera Cluster or the built-in Group Replication plugin
Full-text indexing and searching[b]
Embedded database library
Partitioned tables with the pruning of partitions in the optimizer
Shared-nothing clustering through MySQL Cluster
Multiple storage engines, allowing one to choose the one that is most effective for each table in the application.[c]
Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.
MySQL is easy to use
However MySQL's social nature and the following unbending stockpiling constructions may appear to be prohibitive, the plain worldview is maybe the most instinctive, and at last, takes into account more noteworthy convenience.
Indeed, MySQL makes numerous concessions to supporting the most extensive conceivable assortment of information structures, from the standard however rich coherent, numeric, alphanumeric, date, and time types, to further developed JSON or geospatial information. Past simple information types and far-reaching work in highlight set, the MySQL environment likewise incorporates an assortment of devices, facilitating everything from the server the executives to announcing and information investigation.
Notwithstanding the RDBMS's overall engineering, clients can constantly observe a MySQL highlight permitting them to display and classify information how they wish. MySQL stays quite possibly the most direct data set technology to learn and utilize.
MySQL Advantages And Disadvantages
Features of MySQL:
MySQL is a Relational Database Management System or RDBMS which means that it stores and presents data in tabular form, organized in rows and columns.
MySQL is more secure as it consists of a solid data security layer to protect sensitive data from intruders and passwords in MySQL are encrypted.
MySQL is available for free to download and use from the official site of MySQL.
MySQL is compatible with most of the operating systems, including Windows, Linux, NetWare, Novell, Solaris, and other variations of UNIX.
MySQL provides the facility to run the clients and the server on the same computer or different computers, via the internet or local network.
MySQL has a unique storage engine architecture which makes it faster, cheaper, and more reliable.
MySQL gives developers higher productivity by using views, Triggers, and Stored procedures
MySQL is simple and easy to use. You can build and interact with MySQL with only the basic knowledge of MySQL and a few simple SQL statements.
MySQL has a client-server architecture. There can be any number of clients or application programs that communicate with the database server (MySQL) to query data, save changes, etc.
MySQL is scalable and capable of handling more than 50 million rows. This is enough to handle almost any amount of data. Although the default file size limit is 4GB it can be increased to 8TB.
MySQL allows transactions to be rolled back.
MySQL is very flexible as it supports a large number of embedded applications.
Disadvantages of MySQL:
MySQL is not very efficient in handling very large databases.
MySQL doesn’t have as good a developing and debugging tool as compared to paid databases.
MySQL versions less than 5.0 do not support COMMIT, stored procedure and, ROLE.
MySQL is prone to data corruption as it is inefficient in handling transactions.