On 5/31/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > John Paul Ashenfelter wrote: > > > > <anecdote> > > True story. MySQL and Informix recently were competing for a contract > > at a large enterprise (which I can't name). The *software license* > > ONLY for Informix for their 96 (!) processor SGI Origin (maybe it was > > 48 -- doesn't really matter all that much) was $1.2M. MySQL's > > per server commercial license was $600 -- the same as it is for a 1 > > CPU Dell 750 server. > > </anecdote> > > > > Obviously Informix would have to bring about 1.2 million dollars of > > extra value to the project to displace MySQL. This is obviously a bit > > of an edge case as far as comparisons go > > Not at all. Oracle is $4K per CPU for standard edition. Only when > you have more then 4 CPUs in your organisation, you are not > allowed to run standard edition and you have to get Enterprise > Edition. That is $40K per CPU. Add some extra GIS, OLAP or > clustering features at $10-20K per CPU and you easily spend $60K > per CPU. Redundant production servers at 2 CPUs, staging > environment, all processors double core (double pay) and you are > out $700K. And that is basically for 3 dual CPU systems.
You're right on -- and it's not all that different for MS-SQL with the Enterprise Edition costing 25k/processor plus additional for the enterprise Windows server, clustering addons, and the like. Or for DB2 which tends to be somewhere between the MS and Oracle in pricing. And all this gets worse (especially with Oracle) when dual+ core single chips start shipping. While MS currently is treating a dual-core processor as a single processor, Oracle isn't. So that quad processor server with 4 cores per chip is... 16 Oracle processor licenses. Of course in a large scale MySQL deployment, you're *probably* buying a $10-30k support license and paying for Red Hat Enterprise -- though the nice thing is that you aren't *required* to pay for those things unless you need/want them. No, I meant the edge case was purely a ridiculous number of processors on what's effectively a supercomputer (data warehousing project) ;) Let's see what Oracle on 96 processors costs :) Which is much more likely on a mid-range Sun box running multicore chips in the coming year or so. > At a 3-year write-off, how many DBAs can you hire for that money? It depends... Oracle DBAs or MySQL DBAs? ;) -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208119 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
