MySQL 5.0
Overview
MySQL is a fully featured open source RDMS (Relational Database Management System). According to the MySQL website, MySQL is also the worlds most popular, with over 100 million copies of its software downloaded.
Acquired in 2008 by Sun Microsystems, MySQL AB now provides a community and an enterprise server product. The community server is free under the GPL license agreement.
Applications
MySQL is sometimes criticized for being buggy and its inability to utilize multiple CPU cores can restrict its applications. However, this hasn't in any way effected its adoption and is very popular with applications and is used by many of the world's largest and fastest-growing organizations such as Yahoo!, Flickr, Facebook, Wikipedia, Google, Nokia, YouTube, Wikipedia, and Booking.com.
Features
- Stored procedures
- Triggers
- Cursors
- Updatable Views
- True VARCHAR support
- X/Open XA distributed transaction processing (DTP) support
- 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)
- ACID compliance using the InnoDB, BDB and Cluster engines
- Shared-nothing clustering through MySQL Cluster
Platforms
Versions of MySQL are available for more the 30 of the most popular operating systems past and present. MySQL itself was written in C and C++ however, libraries for accessing MySQL are available for all the major programming languages.
For a full database comparison please see this link here.
Related Articles:
