Slashdot Mirror
MySQL A Threat To The Big Database Vendors?
geekinexile writes: "Bloomberg is running a story on the growth of MySQL as an alternative to the big commercial database systems." The story mentions PostgreSQL as well, and presents a generally positive view of both.
I work for Conectiva (Brazil), involved in a project where a minor telecom company is replacing most of their Ora*le databases to PostgreSQL. Mostly due to cost reduction (should be for a more noble cause, but...)
Note, this is the first step of a big project involving migration to free plataforms everywhere it is possible inside the company.
IMHO it's a good idea, but they must keep in mind that there already are some limitations that I'm sure it'll be solved ASAP. Of course that a little of investment in the FreeSoftware/OpenSource comunity will help a lot too, but this is subject for another project ;o)
-=-=-=-=
I know life isn't fair, but why can't it ever be un-fair in MY favor!?
Data comes in one way and gets read many times and that's the sort of use MySQL's raw speed will blow both postgres and oarcle away at.
I disagree, every test I've ever done or read in the last 3 years, postgres is as fast or faster than MySQL (using reasonable sized data not "100 test records"). Do you have a link to a benchmark on recent versions of each (without magic 3rd party patches)?
Education is a better safeguard of liberty than a standing army.
Edward Everett (1794 - 1865)
Back in the day (about 2-3 years ago) MySQL was a bit of a pain to configure correctly under Linux and a bit moreso under other UNIXen. PostgreSQL was insane. I tried to get it to work on my box, and I'm a C programmer with many years of experience in understanding other people's code and installation systems.
I finally gave up. I got it installed and mostly working, but I just had better things to do and I wasn't at all happy with the number of hand-tweeks that were required. I slapped MySQL in place and never turned back.
I think a lot of folks were in the same boat, but had even less patience for PostgreSQL's difficult installation.
Now, I understand the two are about the same, and both are available with the major Linux distributions. However, now PostgreSQL has to work its way out of the hole its in. Admins like me will be loath to give up the DB we know best in favor of one that burned us, even if it was long ago.
IMHO, views and stored procedures amount to short scripts, and were added to companies making databases at the right time (pre-boom) to make a new class of database that was term'd Enterprise but realy just meant hybrid DB engines with scripting support.
Well, we are talking about relational database management systems, not a "database file". An RDBMS is the middleware between you and the database file, and facilitates crazy, insane features like concurrency control, transactional control, and most importantly security. Both views and stored procedures are very important facets of security in any modern RDBMS as they allow you to hide the internals of your database, and to only provide applications the ability to have certain constrained "I/O windows" into your database (hell, my normal design norm is to only allow interactions with stored procs, which themselves only operate through constrained views). There is nothing gimmicky about these features, and they are crucial for an "enterprise" system.
Guys,
Let me offer my view on the Bloomberg article. It is a huge success for the whole open source community that MySQL gets written about in a publication which is for non-techies only. It is an indication that open source development is not in vain - that open source is becoming a viable alternative even in the most conservative IT shops.
So in stead of arguing for and against this or that open source database, let's work together to become even stronger in the business world!
A key reason for MySQL's huge installed base is that Monty and David - the founders - focused on speed, reliability, and ease of management. That's why Bloomberg is writing about MySQL. And that is also the way to find paying customers who make it possible to hire more programmers and further develop the product.
I am sorry if this sounds like marketing speech. We at MySQL AB are working our butts off to conquer the business world. Now as we are doing so, it will benefit all open source databases. Will you help us?
Marten Mickos, CEO, MySQL AB