RE: MySQL versus Oracle

From: <Jared.Still_at_radisys.com>
Date: Fri, 31 May 2002 14:59:53 -0800
Message-ID: <F001.00471A68.20020531145953@fatcity.com>

How about Oracle *and* MySql?

Has anyone designed a methodology and/or process for using MySql in mostly read databases to save on licensing?

Replication for instance. I am currently replicating portions of 2 different schemas from different databases onto a 3 different schemas in a single database.

This is to satisfy some reporting requirements for users of these systems ( I do *NOT* turn these folks loose on my production SAP with Crystal reports! )

These are currently a combination of snapshots/materialized views ( same thing I know, but I have some 8.0 databases ), and are refreshed every 5 minutes.

A reliable methodology to due this to MySql rather than Oracle could save some $$. All they do is query the tables at the replicated end.

I'm not too sure the a 5 minute refresh cycle would work though. The code in Oracle is in the kernel: very fast. Roll your own in Perl or C might not be fast enough for this.

And then there are the fast/complete refresh methods to deal with, as well os PK or ROWID based.

Any ready made architectures out there for this?

Jared

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 31 2002 - 17:59:53 CDT