[atomic-testing] Mysql 5.1.43

[scott]

This is the first test build on the road to supporting Mysql 5.1 officially in the repository. Please use this thread to note any package conflicts, or other concerns with using 5.1 in your environment. Like PHP, this will be a full change to the newer packages and the 5.0 series will be retired.

Changelog:
None! First release

To upgrade:
yum --enablerepo=atomic-testing upgrade mysql

[johnthomas001]

Thanks for the great RPM's.

I'd like to run/test Mysql 5.1, but I am having trouble upgrading. Following are the relevant yum results:

Error: Missing Dependency: libmysqlclient.so.15 is needed by package perl-DBD-mysql-4.013-1.el5.rf.i386 (installed)
Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15) is needed by package perl-DBD-mysql-4.013-1.el5.rf.i386 (installed)
Error: Missing Dependency: libmysqlclient.so.15 is needed by package php-mysql-5.2.12-3.el5.art.i386 (installed)
Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15) is needed by package php-mysql-5.2.12-3.el5.art.i386 (installed)

I am running CentOS 5.4. I have my atomic repo's configured as follows:

Code: Select all

[atomic]
name = atomicrocketturtle.com
mirrorlist = http://www.atomicorp.com/mirrorlist/atomic/centos-5-$basearch
enabled = 1
priority = 1
protect = 0
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
gpgcheck = 1
includepkgs=php*

[atomic-testing]
name = atomicrocketturtle.com - (Testing)
mirrorlist = http://www.atomicorp.com/mirrorlist/atomic-testing/centos-5-$basearch
enabled = 1
priority = 1
protect = 0
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
gpgcheck = 1
includepkgs=mysql*

Code: Select all

CentOS54[root@http ~]# rpm -qa | grep mysql
mysql-5.0.90-1.el5.art
perl-DBD-mysql-4.013-1.el5.rf
mysql-libs-5.0.90-1.el5.art
mysql-server-5.0.90-1.el5.art
php-mysql-5.2.12-3.el5.art

I tried
yum clean all
yum upgrade

I tried many other settings in my atomic.repo file, but the result has always been the same error regarding the missing libmysqlclient.so.15 file.

[scott]

yup, it's going to need a -compat package to bridge the 5.0 linked in stuff to 5.1

[Highland]

To make this easy to do, here's the RPM you will need for CentOS 5 (other OSes are available, btw). You will have to install this manually.

32 bit
64 bit

Remember to restart mysqld afterward (you may need to clean your my.cnf to get this working, i.e. skip-bdb is no longer necessary)
Then run mysql_upgrade

[johnthomas001]

Interesting, should those be included in the repo here?

[scott]

No, bad versioning on those. Not recommended

[Highland]

Where else should we get them from? I couldn't find them anywhere else and 5.1 installed right away after adding it.

[scott]

I havent done any yet, but when I do they will be using more conservative versioning. So the ones you identified will look "newer" when they are really older.

[Highland]

There are some issues with 5.1.43 and replication. These are fixed in 5.1.44. I would urge you to consider the leap to 5.1.45, however, as there are a couple of minor bugs that are fixed in there that are causing issues as well.

[scott]

Done, 5.1.45 should be up in atomic-testing shortly

[scott]

mysql 5.1.46 will be available in the testing repository shortly. This is the last period for comments on adopting this into the stable repo [atomic], unless there are any reservations I would like to adopt the 5.1 series and retire 5.0 in march.

[breun]

March of what year?

[scott]

MMX Anno Dominae

[breun]

Hm, so it has been retired already then?

[scott]

Oh sorry, I ment the metric march; may.