At 12:27 AM 7/14/99 -0600, you wrote:
>I likely will not use one database for everything. Based on the
>information I have received in this thread, I will likely use MySQL for
>the individual stores (because of its light footprint), MySQL for the
>web site, and something else, likely Oracle for the central repository
>that feeds the MySQL web site and the stores.
This is what I often do, too. I'll use a cluster of fast, lightweight
databases on the front-end and I'll run an enterprise-type database (take
your pick) on the back-end to aggregate the data, run reports, etc. This
is a flexible architecture that scales well and can deliver high
availability to the customer without costing a fortune. Also, if the
repository has no real-time load requirements placed on it, you can use
much cheaper hardware for the enterprise database than you would otherwise.
>James: Since you have been a consultant for Oracle and are fimiliar with
>DB2, which of the two would you recommend as the central repository?
>For this, I would like a more flexible security model, decent
>performance, triggers (peferably that can reach external programs),
>DBI/DBD interface, scalability (ability to run accross clusters is a
>definate bonus). Ability to run on Linux, FreeBSD and (ack!) WinNT is a
>bonus as well. I think that if I used MySQL for this repository, I may
>have to write a whole suite of Perl scripts to secure the database and
For what you want to do, I would go with whatever is cheapest :^)
Seriously, both have all the features you require (although triggers
accessing external programs isn't a very straight-forward trick many
times), both will scale well, and both have a plethora of interfacing tools
although you'll find more stuff for Oracle, mostly because it is more
prolific. Neither natively supports FreeBSD to my knowledge, although you
can almost certainly run the Linux binaries on FreeBSD. As an avid user
and supporter of FreeBSD, I sincerely hope they support this platform
someday. Oracle runs better on NT, but better is relative. Nothing ever
runs "really well" on NT!