All about Programming

Mysql is the world’s most used open source relational database management system (RDBMS)
that runs as a server providing multi-user access to a number of databases.

The source code of MySQL has been made available under the terms of the GPL from the owner MySQL AB,
which is now owned by Oracle Corporation. This, its performance and the fact that it runs on nearly all available
platforms made it such popular for many web projects.

MySQL Features

- A broad subset of ANSI SQL 99, as well as extensions
- Cross-platform support
- Stored procedures
- Triggers
- Cursors
- Updatable Views
- Information schema to provide easy access to metadata
- Strict mode (Values don’t get truncate if they don’t fit the underlying datatype)
- 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, and Cluster storage engines; savepoints with InnoDB
- SSL support
- Query caching
- Sub-SELECTs
- Replication to improve application performance and scalability (Master-Master Replication & Master-Slave Replication)
- Full-text indexing and searching using MyISAM engine
- Embedded database library
- Unicode support
- ACID compliance when using transaction capable storage engines
- Partititoned tables with pruning of partitions in optimiser to improve performance and management of large database applications
- Shared-nothing clustering through MySQL Cluster
- Hot backup (Using mysqlhotcopy, MyISAM tables only)
- MySQL Connectors (ODBC, JDBC, .NET, etc) for building applications in multiple languages
- Multiple Storage Engines:
- InnoDB
- MyISAM
- NDB (MySQL Cluster)
- Memory
- Merge
- Archive
- CSV

Some graphical clients

[amazon_carousel widget_type="SearchAndAdd" width="600" height="200" title="Books" market_place="" shuffle_products="False" show_border="False" keywords="MySQL" browse_node="" search_index="Books" /]