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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
