Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a centos5.5 system and have MySQL 5.0.27 install. Now I want to upgrade this to MySQL 5.5.28(Latest). I have two questions,

  1. What is the difference between RPM(Redhat) which is recommended and Generic binary tarball. Do they have performance difference, i.e. will the Specific RPM build perform better than generic tarball?

  2. What is the process of RPM upgrade of the same.

share|improve this question

migrated from stackoverflow.com Nov 2 '12 at 8:38

This question came from our site for professional and enthusiast programmers.

add comment

3 Answers

Beware that the RPMs distributed by MySQL themselves are not binary compatible with your system and will break compatibility with other existing software, as well as breaking the dependency chain that yum maintains. (MySQL intends to fix its RPM packages in version 5.7.)

For people needing an updated version of MySQL, I generally recommend using the remi repository, since he provides packages with maximum backward compatibility that will not break yum (or other things!).

share|improve this answer
    
I'm seeing this question now after 'community' made it pop up. The oracle-provided RPM's are OK to use again these days. –  Dennis Kaarsemaker Sep 22 '13 at 20:09
add comment

1 . The RedHat RPM has been built specifically for RedHat OS. That should mean that general dependencies and features are ensured to work on that system. It will be built for a specific range of RedHat releases and/or kernel versions.

Also installing via RPM will (hopefully) give a sane and clear error if a dependency is not found so you can easily go and install it.

The tarball is, as you say, a generic binary build. In most circumstances it should work but won't be specifically built for RedHat and any OS-specific file paths or constraints.

2 . RPM upgrade process:

rpm -Uvh rpmname.rpm

U is upgrade, v is verbose so you get details, h is print a hash as it installs (looks nicer)

share|improve this answer
add comment

I would suggest sticking with the version in the stock yum repository unless you have a compelling feature-based reason to upgrade. RHEL/CentOS backports security fixes from upstream versions into their packages so they remain secure.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.