Is MySQL better than MSSQL ?


Top Questions

Mysql is the most popular open source database server right now. It is used by large enteprise level companies and small, single websites. Is mysql actually better?

---------------------------------
Mysql 5.0 vs. Microsoft SQL 2005
---------------------------------

Features

* Mysql 5.X now offers support for cursors, complete views, and stored procedures. However, Foreign Key support is still in its early stages.
* SQL 2005 has native support for xml, multi-dimensional data querying, and Visual Studio .net integration.

Cost

* Microsoft provides a free license for development use. $1400 for a commercial license.
* Mysql is free ($0) for commercial and non-commerical use. It is also possible to purchase a commerical license (to get around the GPL license) for $400.

Performance

* Mysql: MyISAM database table type uses less space and memory. Innodb and NDB clusters also now use 20% less space (new to 5.0).
* SQL 2005: needs more disk storage and memory requirements.

Replication

* Mysql: One way replication using a binary log, which can easily be replicated to multile machines.
* SQL 2005: Multiple forms of replication (snapshot,transactional, and merge), which are more complex and offers a greater degrees of flexibility.

Recovery

* SQL 2005: Very robust. There are multiple failsafes in place to prevent data loss. New features in this version also allow rapid restoration and data protection.
* Mysql: Falls very short in this respect. An unexpected shutdown of your server can cause data loss.

Thanks to tometasoftware

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
3 + 10 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Check It !

Tweet It

W3 Updates

Stay informed on our latest news!

Syndicate content