MySQL Review
Highly recommended open source database for small/medium sized organizations


Pros:- 

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.

Cons:- 

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.
1 visitor found this review helpful

2 Comments

it_user10923Vendor

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

No offense, Con #3 is wrong, also some others are wrong too.

http://dev.mysql.com/doc/refman/5.0/en/stored-routines.html 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...

05 October 13
kapilmalik1983ConsultantTOP REVIEWER

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

07 December 14
Guest
Why do you like it?

Sign Up with Email