Sai430

Team Project Report on MySQL

MySQL is defined as a relational database management system (RDBMS) base on SQL(Structure Query Language. It was originally developed by Michael Widenius and David Axmark in the beginning of 1994.

The first version of MySQL appeared on 23 May 1995. It was initially created for personal usage from mSQL based on the low-level language ISAM, which the creators considered too slow and inflexible. They created a new SQL interface, while keeping the same API as mSQL. By keeping the API consistent with the mSQL system, many developers were able to use MySQL instead of the (proprietarily licensed) mSQL antecedent.

MySQL run on all platforms out there, including the popular OS Linux, Unix and Windows. MySQL is most often associated with web-based applications and online publishing and is an important component of an open source enterprise stack called LAMP. LAMP is a Web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language. (Sometimes Perl or Python is used instead of PHP.

Pros and Cons of MySQL

Pros

1. MySql is free and Open Source

2. Available on (32 and 64 bit) including Windows: 

(RedHat, SuSE, Fedora, Solaris, HPUS, AIX, SCO, FreeBSD, Mac OS, 

Windows)

3. Unique Query Cache (stores query and result set)

4. More support and help

Cons

1. Stability Issues

2. Poor Performance Scaling

3. Functionality need addons

4. Not fully compliance

Conclusion:

After doing research on MySQL despite the cons, MySQL is still widely use and very easy to set up. It’s support all platform. It’s have lots of community support. Most company want something that are easy to use and allow them to freely add more feature on top of it without worrying about licensing issues.