MySQL, Open Source Relational Database
MySQL is a well-known open source relational database management system (RDBMS) written in C and C++ owned by Oracle Corporation. MySQL is widely used by developers due to its compatibility with multiple website applications. MySQL is an essential component of LAMP web application software stack that also includes Linux, Apache, and PHP/Perl/Python. Lots of applications and large-scale websites use MySQL database – WordPress, Joomla, Drupal, Facebook, Google, Flickr, Twitter, and YouTube.
There are several different editions that run on different platforms and operating systems such as Windows, OS X, FreeBSD, Solaris, and other variants of Unix and Linux.
MySQL Community Edition is a freely downloadable version of MySQL that is supported by a large community of developers. Its main features are:
- Pluggable Storage Engine Architecture with multiple storage engines
- MySQL Partitioning that helps manage large database applications
- MySQL Replication for improving scalability
- MySQL Workbench for SQL development, visual modeling, and administration
- Information Schema that enables easy access to metadata
- MySQL Connectors such as ODBC, JDBC, .NET for building different applications in multiple programming languages
- Stored Procedures to improve developer productivity, etc.
My SQL has multiple commercial editions:
- MySQL Standard Edition is commonly used for developing scalable Online Transaction Processing (OLTP) applications
- MySQL Enterprise Edition has a comprehensive set of management tools, advanced features, and technical support that can reduce costs for developing and management of mission-critical MySQL applications. The tools include Oracle Enterprise Manager for MySQL, MySQL Enterprise Monitor, MySQL Enterprise Firewall, MySQL Enterprise Encryption, MySQL Enterprise Audit, and more.
- MySQL Cluster Carrier Grade Edition is designed for development of web, cloud, and communications services and has SQL & NoSQL APIs that make possible to blend the best features of both relational and NoSQL technologies
- MySQL Classic Edition is considered to be the ideal embedded database for development of read-intensive applications and is available to OEMs, ISVs, and VARs.