MySQL

MySQL

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.

MySQL is the world's second most widely used open-source relational database management system

MySQL Services

The official MySQL 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

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

Easily extended

MySQL works on many system platforms. MySQL is 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 MySQL databases

Lots of systems and programming languages

mySQL Features

MySQL 5.1 has two different variants: the open source MySQL Community Server and the commercial Enterprise Server. MySQL 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.

© Copyright 2012 - Acumen Consulting - St. Louis