On Wed, Apr 11, 2001 at 07:15:10PM -0700, Peter Jay Salzman wrote:
<pete's intro snipped>
> ----- Forwarded message from j ohnzie zie <[EMAIL PROTECTED]> -----
>
> Date: Wed, 11 Apr 2001 18:57:22 -0700 (PDT)
> From: j ohnzie zie <[EMAIL PROTECTED]>
> Subject: help needed
> To: [EMAIL PROTECTED]
>
> Dear sirs:
>
> I am a freeBSD user. But now we want to install red
> hat linnux on our 2 web servers(HP made), and install
> MySQL to a database server(HP also). Could u please
> suggest which Linux version and MySQL version I should
> choose.
>
> Currently My OS is Free BSD, Mysql is 3.22.
>
> I may choose Red Hat prossional as OS in the two
> servers, because there are two servers there, should I
> need cluster server or not?
>
> Thank you for helping.
>
> Best regards
>
>
> John Zie
If it must be redhat, then definitely use version 6.2. It was stable,
whereas I don't consider 7.0 (is it 7.1 now? either way...) stable. I
use it at home, but had to "downgrade" several things because they
weren't stable enough for my needs. If they aren't stable enough for
my personal needs, I'm sure that a production environment is "right
out."
As to what version of mySQL you should get, go with the "postgresql"
version :)
Okay, okay, if you really must use mySQL, the latest release version
should be fine; but after having brief experience with both, I
*strongly* prefer postgresql because it is much more robust, and is
designed the way real database engines ought to be. For instance,
mySQL doesn't support rolling back transactions, which IMO is very
important for any critical database needs; and I also miss nested
SELECT statements in mySQL, which are available in postgres.
Micah
