Re: oracle - mysql comparison

ttyp32000_at_yahoo.com (jonathan) wrote in message news:<f05e664d.0407081323.7b5e428c_at_posting.google.com>...
> hey all,
>
> I realize that this question might pop up from time to time, but I
> haven't seen it a while and things might of changed, so -
>

Take a good look at http://www.mysql.com

> Right now (July 2004) how does mysql stand up in comparison to oracle?
> We are seriously considering migrating our multi-processor oracle
> system to mysql to save on licensing costs, and would need several
> features that mysql may or may not have:
>
> - replication

Limited (comparing to Oracle).

> - archive logging

No

> - interoperability with oracle/database links with oracle

Not sure. Nothing supported by Oracle. Maybe some 3rd party tools.

> - PL/SQL type language/stored procedures

Very limited SQL stored functions and procedures (ANSI 2003?), like in DB2.

> - roles
> - oracle migration scripts/conversion

Not sure it's possible. Like with any other databases, you'd need a lot of manual work.

> - embedded java API

No

> - partitioning/tablespace assignment

Tablespaces. No partitioned tables in Oracle sense (limited partitioning for clusters).

> - import/export tools
> - equivalent oracle datatypes

Not exactly. Lots of C-type datatypes, no good support for VARCHAR yet.

> - multi-processor support

Yes.

> - performance (relatively equivalent or better)
>

You wouldn't know till you try... Everybody likes performance of MySQL with non-transactional tables, but I wouldn't base serious applications on them...

> In addition, have any oracle DBAs out there gone through the
> conversion process between mysql and oracle? If so, what were the
> gotchas/catches that you went through? What are features that are
> there that you like or feel are missing? I apologize in advance for
> the cross-post, but I did want to get as wide a range of opinion as
> possible..
>
> Thanks much,
>
> jon
Received on Fri Jul 09 2004 - 12:00:34 CDT