[CentOS] MySQL 5.0.22 on CentOS 4.4

[Ryan Simpkins]

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