On Mon, April 16, 2007 10:22, Joseph Cheng wrote:> Hi...I was pleased to see MySQL 5.0.22 and PHP5 in CentOS 5.0 and as much
as I
> need these updates I think I should be safe and not upgrade until CentOS
5.1
> is released. But for now I am running CentOS 4.4 with stock MySQL and PHP
rpm
> packages. I need to upgrade MySQL to 5.0 and I noticed there is a
mysql-server-
> 5.0.22-1.centos.1.i386.rpm package in the centosplus directory. There is
also a
> mysql-server-5.0.27-1.el4.centos.i386.rpm package but I think I should
stick
> to .22 so that the eventual upgrade to CentOS 5.1 will be easier. I have
two
> questions for any of the MySQL administrators running CentOS 4.4...
>
> 1. What has been your experience like with the mysql-server-5.0.22-
> 1.centos.1.i386.rpm centosplus package on high load sites?
With a tuned config I am very satisifed. With the stock config, not so much.
> 2. Is it better to just use the official RPM from MySQL instead?
> http://mysql.org/get/Downloads/MySQL-5.0/MySQL-server-community-5.0.37-
> 0.rhel4.i386.rpm/from/pick
There are a lot of factors to consider. Generally speaking it depends on how
much
(or little) administration you want to deal with. Also, they like to throw in
the
occasional regression on those community releases - but that generally isn't
an
issue.
> My concern with the official MySQL rpm is that it's version 5.0.37 and
will be
> different from the one in CentOS 5.1 So for now I think I would like to use
> 5.0.22 with stock PHP 4.3.9 then later upgrade PHP to version 5.1 also from
> centosplus. Any performance or stability reason not to? Please share your
> experience and opinions. TIA!
Remember that in a worst case scenario you can always dump your DBs in and out
of
the two version to upgrade/downgrade (note the compatibility option with
mysqldump).
With some data sets this might not be practical, but there are various things
you
can do.
Anyone is free to contact me off list if you have any CentOS+MySQL questions. I
currently admin several thousand MySQL servers. I'm not going to drag that
out in
this list as the point is CentOS, not really MySQL. On that topic I am very
satisifed. MySQL runs great on CentOS 4.4.
-Ryan