MySQL and its Distinguishing Features by hkksew3563rd


									MySQL is a relational database management system which is better known as
RDBMS, it runs as a server providing multi-user access to a number of databases.
MySQL is officially named for original developer Michael Widenius's daughter My.
MySQL works on many different system platforms, including AIX, BSDi, FreeBSD,
HP-UX, i5/OS, Linux, Mac OS X etc just to name a few. The MySQL development
project has made its source code available under the terms of the GNU General Public
License, as well as under a variety of proprietary agreements. It was owned and
sponsored by a single firm, the Swedish company MySQL AB which is now owned
by Oracle Corporation.
 Free-software projects that require a full-featured database management system
often use MySQL. MySQL is also used in many high-profile, large-scale World Wide
Web products. The "M" in the acronym of the popular LAMP software stack refers to
MySQL. Its popularity for use with web applications is closely tied to the popularity
of PHP. MySQL is primarily an RDBMS and therefore ships with no GUI tools to
administer MySQL databases or manage data contained within. The MySQL
community has created several forks such as Drizzle, OurDelta, Percona Server, and
MariaDB. All of these forks were in progress before the Oracle acquisition.
 MySQL has many features which sets it apart from other RDBMS systems. Let have
a look at these features.
 鈥?Multiple storage engines, allows one to choose the one that is most effective for
each table in the application (in MySQL 5.0, storage engines must be compiled in; in
MySQL 5.1, storage engines can be dynamically loaded). 鈥?Customized storage
engines. 鈥?Native storage engines like Falcon, Merge, Memory, CSV, Blackhole,
Cluster etc. 鈥 ?Partner-developed storage engines. 鈥 ?Community-developed
storage engines. 鈥?Commit grouping, gathering multiple transactions from multiple
connections together to increase the number of commits per second.
 MySQL has many versions of it that has hit the market since its advent. MySQL
Server 6.0.11-alpha was announced 22 May 2009 as the last release of the 6.0 line.
Future MySQL Server development uses a New Release Model. Features developed
for 6.0 are being incorporated into future releases.
 The author of this article is an expert in custom software development and has also
written various articles on web development and web design India in the last five

To top