MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. Free-software-open source projects that require a full-featured database management system often use MySQL.

This database is the world’s second most widely used open-source relational database management system

MySQL Services

Graphical

The official Workbench is a free integrated environment developed by MySQL AB, that enables users to graphically administer MySQL databases and visually design database structures.

A nice GUI for ease of use

Command Line

MySQL ships with many command line tools, from which the main interface is ‘mysql’ client.Third-parties have also developed tools to manage servers.

Easily extended

Programming

This database works on many system platforms. It’s written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyzer. Many programming languages with language-specific APIs include libraries for accessing databases

Lots of systems and programming languages

Features

The 5.1 version has two different variants: the open source Community Server and the commercial Enterprise Server. 5.5 is offered under the same licenses. They have a common code base and include many features.

Highly available and stable, MySQL has many advantages

Ensuring high availability requires a certain amount of redundancy in the system. For database systems, the redundancy traditionally takes the form of having a primary server acting as a master, and using replication to keep secondaries available to take over in case the primary fails. This means that the “server” that the application connects to is in reality a collection of servers, not a single server. In a similar manner, if the application is using a sharded database, it is in reality working with a collection of servers, not a single server. In this case, a collection of servers is usually referred to as a farm.