Re: oracle - mysql comparison

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1089413320.371216_at_yasure>...
> Alex Filonov wrote:
>
> >>
> >>No comparison and you have missed the most important questions you
> >>should be concerned about unless you are running a hotdog stand.
> >>
> >>1. Where to we call for support if there is a problem we can't solve?
> >
> >
> > mysql.com
>
> Not exactly the same thing as opening a Level 1 TAR.
>

I don't know all details of MySQL support, but I think you can get pretty good support, including phone hotline, for the price comparable with the price of Oracle support.

> > Being open source product doesn't mean "not supported". You can buy
> > support contract.
>
> True. But being available 7x24 and able to support you in the way
> Oracle support does requires paying money: And lots of it.
>

Sure. Oracle support is not cheap either.

> >>2. How do we recover transactions that occur between the last backup
> >> and the time when the system fails?
> >
> > There is limited crush recovery.
>
> Compared with Oracle ... very limited. And it is the issues related
> to Murphy's Law that are most important to consider.
>

Judging by industy experience (Yahoo! and Google are both using MySQL on a big scale), things aren't that bad...

Myself, I wouldn't recommend MySQL for critical applications as yet. But things are moving pretty fast in the Open Source world...

> >>3. Can we recover from object and/or file corruption?
> >>
> >>Very simply ... ask your management what the cost is to the company
> >>for every hour the system is unavailable. Then compare that to the
> >>less than $800 cost for licensing Oracle SE1.
> >>
> >>But if you truly need EE capabilities such as partitioning then stick
> >>with Oracle. You won't find it anywhere else.
> >>
> >>Daniel Morgan
>
> Daniel Morgan
Received on Mon Jul 12 2004 - 10:22:26 CDT