Open Source Databases "50% Cheaper"
pete314 writes, "Open source databases can cut the total cost of ownership of a database by up to 60% compared to the cost of running proprietary databases from Oracle, Microsoft or IBM. According to data collected by Forrester Research, the savings average about 50%. Open source databases however still struggle to reach mission-critical enterprise applications because enterprises perceive them to be less secure and stable."
enterprises also want paralleling clusters and failover clusters. The open source databases are getting there, give it few more years.
For those of us who can't afford to run a commercial database package, and have been running open source databases from the beginning, this isn't news. MySQL and Postgres are your friends.
"Lame" - Galaxar
First, if you're afraid of command-line work, you aren't running Oracle, or anything else in that class.
Second, unless you're doing something out of the ordinary, simply installing mysql or postgres in the same way you usually install programs (be that apt-get, rpm, MS Installer, etc). is all you need to get the database up and running. The same is true of the GUI tools to manage the database -- the Windows installer for postgres includes PgAdminIII in the same package as the database itself.
I'm not bashing MS SQL Server, but let's not pretend it has some magical ease-of-use that doesn't exist in other packages.
I actually found sql server to be quite expensive - from licensing (which was running > $80k for a 4-way on enterprise edition) to labor.
The lack of command-line features meant that many operational activities that could be automated required a dba to manually do the job via the gui. And lets not even talk about how you had to completely recreate DTS packages when promoting them from dev to test to prod...
So, there are labor savings that you can get on sql server vs oracle, db2, postgresql, etc - but the lack of a command line interface wasn't a driver in my experience.
> People are far more dependable when they're working for money than for charity.
not when they suck - which they frequently do when working on product support teams.
yes, I'm glad that I'm working with supported products - but I also avoid calling them like the plague. It is very much a worst-case scenario.
Do you seriously think any CIO with a functioning brain cell is going to go with free unsupported software when they can't even find a single reference to such databases from any certified performance evaluation companies or organizations?
The downtime cost of one single failure in a five year period for a mission critical system can easily run 100 times the cost of a commercial product with support. Only bean counting fools risk their entire business without properly assessed risks and disaster recovery plans.
Not having someone to source the recovery of the smouldering crater that was your data center is a huge issue.
I do not fail; I succeed at finding out what does not work.