Archive

Archive for the ‘Why MySQL?’ Category

Why MySQL?

September 15, 2009 Leave a comment

 

 

Graveled at commercial software licensing? Are you looking for a stable database platform but sweating at the hefty price tags attached to mainstream products from Microsoft, Oracle and other vendors? MySQL may be for you!  MySQL is a well-respected product that is more than capable of commercial operation. As of April 2009, MySQL offers MySQL 5.1 in two different variants: the MySQL Community Server and Enterprise Server, both having common code base and include the below features.

 

MySQL Features:

  • A broad subset of ANSI SQL 99, as well as extensions.
  • Cross-platform support.
  • Stored procedures.
  • Triggers.
  • Cursors.
  • Updatable Views.
  • True Varchar support.
  • INFORMATION_SCHEMA.
  • Strict mode.
  • X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle’s InnoDB engine.
  • Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, MySQL Archive for storing historical data in little space).
  • Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB.
  • SSL support.
  • Query caching.
  • Sub-SELECTs (i.e. nested SELECTs).
  • Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
  • Full-text indexing and searching using MyISAM engine.
  • Embedded database library.
  • Partial Unicode support (UTF-8 sequences longer than 3 bytes are not supported; UCS-2 encoded strings are also limited to the BMP).
  • Partial ACID compliance (full compliance only when using the non-default storage engines InnoDB, BDB and Cluster).
  • Shared-nothing clustering through MySQL Cluster

MySQL Enterprise Server is released once per month and the sources can be obtained either from MySQL’s customer-only Enterprise site or from MySQL’s Bazaar repository, both under the GPL license. The MySQL Community Server is published on an unspecified schedule under the GPL and contains all bug fixes that were shipped with the last MySQL Enterprise Server release. Binaries are no longer provided by MySQL for every release of the Community Server. Read more…