About NewTechnoBuzz
Advertise
Contact Us

Tuesday, July 8, 2014

MySQL Overview

MySQL is the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. It is commonly used for database services for other open source applications, such as Drupal and Wordpress.

The MySQL Web site (http://www.mysql.com) provides the latest information about MySQL software.

The MySQL server provides a database management system with querying and connectivity capabilities, as well as the ability to have excellent data structure and integration with many different platforms. It can handle large databases reliably and quickly in high-demanding production environments. The MySQL server also provides rich function such as its connectivity, speed, and security that make it suitable for accessing databases.
The MySQL server works in a client and server system. This system includes a multiple-threaded SQL server that supports varied backends, different client programs and libraries, administrative tools, and many application programming interfaces (API)s.

Below are some of the characteristic of MySQL:

  • MySQL is a database management system.
  • MySQL databases are relational.
  • MySQL software is Open Source.
  • The MySQL Database Server is very fast, reliable, scalable, and easy to use.
  • MySQL Server works in client/server or embedded systems.
  • A large amount of contributed MySQL software is available.

Features of MySQL

affiliate_link
  • Supports a broad subset of ANSI SQL 99, as well as extensions.
  • Cross-platform support.
  • Supports stored procedures, using a procedural language that closely adheres to SQL/PSM.
  • Multiple storage engines, allowing one to choose the one that is most effective for a table in application.
  • Native storage engines InnoDB, MyISAM, Merge, Memory (heap), Federated, Archive, CSV, Blackhole, NDB Cluster.
  • Supports Shared-nothing clustering through MySQL Cluster.
  • Partitioned tables with pruning of partitions in optimizer.
  • Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.
  • Built-in Replication support (i.e. Master-Master Replication & Master-Slave Replication) with one master per slave, many slaves per master. Multi-master replication is provided in MySQL Cluster, and multi-master support can be added to unclustered configurations using Galera Cluster.
  • Supports Full-text indexing and searching.
  • Embedded database library.
  • ACID compliance when using InnoDB and NDB Cluster Storage Engines SSL support
  • Transactions with savepoints when using the default InnoDB Storage Engine. The NDB Cluster Storage Engine also supports transactions.
  • X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using the default InnoDB storage engine
  • A set of SQL Mode options to control runtime behavior, including a strict mode to better adhere to SQL standards.

Advantages

  • MySQL is an open source database system. Hence it can be downloaded and used by the developer for free.
  • MySQL is robust and it provides excellent performance due to usage of MyISAM.
  • MySQL occupies very less disk space.
  • MySQL can be easily installed in all major operating systems like Microsoft Windows, Linux, UNIX.
  • MySQL can be easily learnt using the tutorials that are available on internet.
  • Though MySQL is open source, it offers most of the features provided by Oracle and other leading databases.
  • MySQL is best suited for small and medium applications.

Limitations

MySQL does not currently comply with the full SQL standard for some of the implemented functionality, including foreign key references when using some storage engines other than the default of InnoDB.

Until MySQL 5.7, triggers are limited to one per action / timing, meaning that at most one trigger can be defined to be executed after an INSERT operation, and one before INSERT on the same table. No triggers can be defined on views.

I hope this article helped you to understand. Please feel free to post any comment or question if you have any.

0 comments