Topic: MySQL 5.5 and the mistery of stability

Hello,

I decided to use Remi repository because CentOS (and so RHEL) repository does not allow me to install recent versions of software, because, as people say, RHEL team only provides versions that are considered as "stable".

And currently Centos repo only provides MySQL 5.1.

So my question is: why MySQL 5.5 is NOT considered as stable by RHEL?

What do I risk by using MySQL 5.5, considering that I am using it to host thousands of databases?

Thank you.

Regards.

Roberto

Re: MySQL 5.5 and the mistery of stability

At time of RHEL-5 release, MySQL 5.0 was the stable version.
So to not break compatibility, RHEL/CentOS-5 will always provide 5.0.

At time of RHEL-6 release, MySQL 5.1 was the stable version.
So to not break compatibility, RHEL/CentOS-6 will always provide 5.1.

RHEL-7 will very probably provides MySQL 5.5 and MariaDB 5.5

So this is not related to the version stability, but to the full OS stability and keeping full compatibility on update.

For RHEL-6, Red Hat provides MySQL 5.5 and MariaDB 5.5 in the new RHSCL 1.0 product. There is no backport (yet) for CentOS.

Goal of remi repository is always "provide the latest".
I don't know yet if I'm going to provide MySQL 5.6 or MariaDB. And I don't know yet if I will provides these as standard RPM or as SCL.
For now, I keep MySQL 5.5

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Re: MySQL 5.5 and the mistery of stability

Ok thanks for the info.

Now I need be reassured a little bit.

My system version is the following:

CentOS release 6.3 (Final)

Linux 2.6.32-279.9.1.el6.x86_64 #1 SMP Tue Sep 25 21:43:11 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux


And version of MySQL packages currently installed are the following:

compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-libs-5.5.28-1.el6.remi.x86_64
mysql-5.5.28-1.el6.remi.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-server-5.5.28-1.el6.remi.x86_64


Now, with the above versions, can I safely update the operating system and MySql? Or are there any risk of incompatibilty? Have you done some tests in order to check if latest version of Centos (6.4) and latest version of MySql by Remi work well together?

Thank you.

Roberto

Re: MySQL 5.5 and the mistery of stability

roby wrote:

Now, with the above versions, can I safely update the operating system and MySql? Or are there any risk of incompatibilty? Have you done some tests in order to check if latest version of Centos (6.4) and latest version of MySql by Remi work well together?

Yes you can update.
And, FYI, all my packages are build against 6.4.

But of course, trying on a test environment is always preferable.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Re: MySQL 5.5 and the mistery of stability

Ok thank for the info.

I have one more question: since my current version of MySql Server is 5.5.28, and latest version of MySQl by Remi is 5.5.34 (if I am not wrong), and so it is just a minor release, do I still have to run "mysql-upgrade" after upgradation?

Thank you.

Roberto

Re: MySQL 5.5 and the mistery of stability

I think running mysql_upgrade is not mandatory, but its a good practice, even for minor version.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi