My words are my thoughts and I'm a pessimist person who just thinks that Murphy's Law is what defines me. I believe that anything bad that has ever happened will continue to do so. So, if anything just cannot go wrong, it will anyway...

Caution




The content of this blog is reflected to my very on skewed perception in life. That means I do not take responsibility on any account, and therefore, read this blog at your own risk!

Personal



Profile | Web | Fotopic
PGP Public Key

Email

ydtmaemtoiestedteaonetlj

It looks like a bunch of garbled text, huh? Well, you can actually learn how to decode using by reading this post.

If you hate challenges, you might want to try jlys@[remove-this]tm.net.my but I only used this sparingly as it's the primary target for junk mails.

Hidden Tab

New Post

Interesting Stuff

Fellow Photogs

Fellow Blogger

Additional

Powered by Blogger
Get Firefox!
Weblog Commenting and Trackback by HaloScan.com

Creative Commons License
Listed on BlogShares

Wednesday, August 11, 2004

 MySQL vs M$ SQL

I have been putting a lot of creative argument to the project manager on which is a better database for our company's next project. He was a pro-supporter of Micro$oft and he puts a lot of support for M$ SQL. Being a Linux supporter and such, I prefer something that's not Micro$oft. We listed out all the advantages & disadvantages of M$ SQL & MySQL.

MySQL
Pros:
  • Stable
  • Doesn't update regularly
  • Loads of community support
  • Lots of 3rd party tools to enhance the database
  • Free

Cons:
  • Need a few additional tools to simplify the process
  • Hard to access without proper software

Micro$oft SQL
Pros:
  • Micro$oft-based (what can you expect?)
  • Easy integration to many database design
  • Ease of usage

Cons:
  • Security Issue
  • Service Pack that goes like 650 MB (the whole program itself)
  • Regular updates

The thing is that our company have the M$ SQL license but the after-maintainence is the one worrying me. We already have a lot of complaints due to Micro$oft security issue and I don't need their old product in our server. Another thing is that Micro$oft promised they will deliver the latest SQL (Yukon) ASAP. I highly doubt that.

On the other hand, MySQL has been running silently on one of the old server (P3 450, 512 MB, 10 GB HDD) with Win2k Server and guess what, I never updated the software since the day I installed it. I admit that the client side might have a little issue installing their control-centre & ODBC driver but that's the price to pay for security. I still stand firm on my decision. The small guy (server) never faced a problem except when the HDD space runs low. There was never a problem or frills that could cause me grief for the day.

I wondered if anyone could remember the day of CodeRed Worm attack where it will attached itself to IIS (Internet Information Service) and then proceeded to attack SQL servers? MySQL seem to be immune to the attack. M$ SQL was affected badly till we have to remove the whole records because the main hard drive has to be formatted (as accordingly since the IT monkeys cannot resolve the issue, so they pointed a gun to our head and enforced us to format & reload the OS for the server).

And now we're back on issue on our new branded server.

At the end the director handed down the commandments to put Windows 2000 Server on the server with M$ SQL. May God have mercy on the server's soul...

0 Comments:

Post a Comment

<< Home