>
> MySQL - as I said at our meeting, we would not be comfortable
> with this
> as an enterprise strength solution. MySQL is unsupported freeware and
> lacks enterprise management functionality.
True, if you ask me.
> It has a small limited feature
> set compared to ORACLE, DB/2
True. No subselects, referential integrity, etc... you know the list.
> and is lacking the functionality to support
> data replication
False. It can do replicating.
> and has little capability for generating
> management info.
"Management info" ?
> There are question marks around the scalability of the
> product.
The presence of those questionmarks tell you more about this persons
knowledge
of mysql then the actual state of mysql. It's true that mysql doesn't
support clustering as
some enterprise level databases do.
> I'm not
> sure of the locking algorithms used (whether row level or
> record level) - the
> fact that it is not generally used in multi-user solutions is
> a good enough
> indication that this is not accepted database technology for
> industrial-strength
> multi-user systems.
A website is generally not a multi-user system though. If Slashdot and
Yahoo!
aren't enough "website" for you then I don't know what is.
> The fact that it is unsupported freeware would mean that an
> end user would
Unsupported by who? You can buy support contracts from mysql as far as I
know,
and there's this list. Unsupported.... well, it's a lot easier to get
mysql support
then it is to get oracle support. That I know from experience.
> potentially be "held to ransom" by a DBA with specific
> knowledge.
MySQL isn't THAT specific that only two people in the world know about
it or anything.
> The mySQL
> security model is also not sufficiently developed for any
> system that involves
> money.
I tend to agree. I'm not too fond of the security system myself.
> I would not be prepared to sign-off any solution containing mySQL.
>
> --End Quote--
>
MySQL might not be the best tool for all jobs. In fact, it might not
even be the best tool for your job, but
I don't know.
However, MySQL does shine as a relatively lightweight database solution.
It retrieves data like no other system out there,
and with new tabletypes like innodb you can have row level locks,
transactions and better multiuser support too.
All I can recommend to you is that you take the demands of your project
and compare the different database systems out there.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
