MySQL Review

Highly recommended open source database for small/medium sized organizations


1) MySQL is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source. 

2) MySQL is ideally suited for small/medium sized organizations for faster performance. 

3) MySQL can be used in client/Server architecture as well as it can also be embedded in standalone applications. 

4) MySQL is fast, east to use, highly extensible, lightweight, scalable, and reliable database. 

5) MySQL supports clustering in the network for redundancy. 

6) MySQL provides flexibility to modify environment variables/kernel settings to limit the amount of memory usage for increasing performance. 

7) MySQL is strongly recommended for web applications, middleware and LAMP architecture systems. 

8) MySQL can be integrated with ldap to provide centralized authentication. It can also be integrated with LAMP/WAMP, web applications and number of programming languages. It is widely used for phpadmin and wordpress. 

9) MySQL is platform independent and can be run in mixed OS platform like windows, linux, ubuntu etc. It gives compatibility even over different OS during backup and restore. Data can be backed up from one OS and can be restored on other OS.


1) MySQL can be integrated with ldap, however, it is very complex, tedious and time consuming. 

2) MySQL support is available through communities like other open source projects which means that it is sometimes scarce and hard to find. 

3) MySQL doesn't have some of RDBMS features like foreign keys, transaction, rollback and subselect. 

4) MySQL also doesn't have tablespaces, role management, snapshots, synonyms and packages. 

5) MySQL uses both InnoDB and MyISAM, however, it gives slower performance when using InnoDB as compared to MyISAM for using simple queries due to complexity of InnoDB. 

6) MySQL does not provide good development and debugging tools, so it’s cumbersome to write large SQL statements.

Alternate Vendors:- Oracle, DB2, Sybase, Postgres, Informatica!!

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More MySQL reviews from users
...who work at a Computer Software Company
...who compared it with SQL Server
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: September 2021.
534,468 professionals have used our research since 2012.
Add a Comment
ITCS user

author avatarit_user10923 (Developer at a tech vendor with 51-200 employees)

Some of the pros and cons simply aren't correct...

No offense, Con #3 is wrong, also some others are wrong too. even 5.0 has SP, but it's old, so don't use it, just update to 5.6 and dont look back, or use third-party service like RDS, MemSQL, etc...

author avatarit_user2652 (Project Manager at a non-tech company with 10,001+ employees)
Top 20PopularVendor

I have researched more on the pros and cons I listed and modified them accordingly.