Topic: MySQL 5.6.19

Hi Remi,
Current Generally Available Release of MySQL is 5.6.19 (with a lot of interesting feature, such as EXPLAIN UPDATE).

Do you plan to make it available in your great repo?

Thanks!

Re: MySQL 5.6.19

No, I don't plan to provides update to MySQL 5.6.

I prefer to concentrate myself on PHP stuff, and PHP doesn't use libmysql anymore.

For database I recommend to use RHSCL which provides mysql 5.5 and mariadb 5.5 (and perhaps, in a near future, mysql 5.6, mariadb 10.0).

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

3 (edited by Zane 2014-07-28 14:44:50)

Re: MySQL 5.6.19

Ok, thanks!

Meanwhile, I discovered that MySQL can be installed from an official repo http://dev.mysql.com/doc/refman/5.6/en/ … -repo.html

For me this is golden: any specific reasoning against it?

Re: MySQL 5.6.19

I have absolutely no confidence with Oracle packaging.

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.6.19

Unfortunately it doesn't work.

I rely on remi for PHP:

yum --enablerepo=remi install php php-mysql

But when I try to install mysql-community-server from the official repo...

yum --enablerepo='mysql*-community*,base' install mysql-community-server

I get this:

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.prometeus.net
 * epel: mirror.proserve.nl
 * extras: mirrors.prometeus.net
 * remi: remirpm.mirror.gymkl.ch
 * updates: mirrors.prometeus.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.4-0.3.m14.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.4-0.3.m14.el6 for package: mysql-community-server-5.7.4-0.3.m14.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.7.4-0.3.m14.el6 for package: mysql-community-server-5.7.4-0.3.m14.el6.x86_64
--> Processing Dependency: perl(DBI) for package: mysql-community-server-5.7.4-0.3.m14.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.4-0.3.m14.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.4-0.3.m14.el6 for package: mysql-community-client-5.7.4-0.3.m14.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.7.4-0.3.m14.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.7.4-0.3.m14.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.38-1.el6.remi will be obsoleted
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.4.31-1.el6.remi.x86_64
--> Finished Dependency Resolution
Error: Package: php-mysql-5.4.31-1.el6.remi.x86_64 (@remi)
           Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Removing: mysql-libs-5.5.38-1.el6.remi.x86_64 (@remi)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Obsoleted By: mysql-community-libs-5.7.4-0.3.m14.el6.x86_64 (mysql57-community-dmr)
               Not found
           Available: mysql-libs-5.5.37-1.el6.remi.x86_64 (remi)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Available: mysql-libs-5.1.71-1.el6.i686 (base)
               Not found
           Available: mysql-libs-5.1.73-3.el6_5.i686 (updates)
               Not found
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Could you please give me a hand? I would understand if not :-)

Re: MySQL 5.6.19

Use php-mysqlnd instead of php-mysql.

Notice: php 5.5 and 5.6 doesn't provides php-mysql (which rely on libmysqlclient), but only php-mysqlnd.

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.6.19

It works! Once again you saved the day! Thank you very, very much!

Re: MySQL 5.6.19

[root@test tmp]# yum clean
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Error: clean requires an option: headers, packages, metadata, dbcache, plugins, expire-cache, rpmdb, all
[root@test tmp]# yum clean all
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Cleaning repos: base elasticsearch-1.3 epel extras mysql-connectors-community mysql-tools-community mysql56-community remi remi-php55 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
[root@test tmp]# yum update  -y
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Determining fastest mirrors
epel/metalink                                                                                                                                                                 |  28 kB     00:00
 * base: mirrors.coreix.net
 * epel: epel.check-update.co.uk
 * extras: mirror.econdc.com
 * remi: remi.check-update.co.uk
 * remi-php55: remi.check-update.co.uk
 * updates: mirrors.coreix.net
base                                                                                                                                                                          | 3.7 kB     00:00
base/primary_db                                                                                                                                                               | 4.4 MB     00:02
elasticsearch-1.3                                                                                                                                                             | 2.5 kB     00:00
elasticsearch-1.3/primary_db                                                                                                                                                  | 3.8 kB     00:00
epel                                                                                                                                                                          | 4.4 kB     00:00
epel/primary_db                                                                                                                                                               | 6.3 MB     00:01
extras                                                                                                                                                                        | 3.3 kB     00:00
extras/primary_db                                                                                                                                                             |  19 kB     00:00
mysql-connectors-community                                                                                                                                                    | 2.5 kB     00:00
mysql-connectors-community/primary_db                                                                                                                                         | 7.0 kB     00:00
mysql-tools-community                                                                                                                                                         | 2.5 kB     00:00
mysql-tools-community/primary_db                                                                                                                                              |  16 kB     00:00
mysql56-community                                                                                                                                                             | 2.5 kB     00:00
mysql56-community/primary_db                                                                                                                                                  |  59 kB     00:00
remi                                                                                                                                                                          | 2.9 kB     00:00
remi/primary_db                                                                                                                                                               | 1.0 MB     00:00
remi-php55                                                                                                                                                                    | 2.9 kB     00:00
remi-php55/primary_db                                                                                                                                                         | 164 kB     00:00
updates                                                                                                                                                                       | 3.4 kB     00:00
updates/primary_db                                                                                                                                                            | 5.4 MB     00:02
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.21-2.el6 will be obsoleting
---> Package mysql-community-libs.x86_64 0:5.6.21-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.21-2.el6 for package: mysql-community-libs-5.6.21-2.el6.x86_64
---> Package mysql-community-libs-compat.x86_64 0:5.6.21-2.el6 will be obsoleting
---> Package mysql-community-server.x86_64 0:5.6.21-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql-community-common.x86_64 0:5.6.21-2.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================================================
 Package                                                    Arch                                  Version                                     Repository                                        Size
=====================================================================================================================================================================================================
Installing:
 mysql-community-client                                     x86_64                                5.6.21-2.el6                                mysql56-community                                 18 M
     replacing  mysql.x86_64 5.5.39-1.el6.remi
 mysql-community-libs                                       x86_64                                5.6.21-2.el6                                mysql56-community                                1.9 M
     replacing  mysql-libs.x86_64 5.5.39-1.el6.remi
 mysql-community-libs-compat                                x86_64                                5.6.21-2.el6                                mysql56-community                                1.6 M
     replacing  mysql-libs.x86_64 5.5.39-1.el6.remi
 mysql-community-server                                     x86_64                                5.6.21-2.el6                                mysql56-community                                 53 M
     replacing  mysql-server.x86_64 5.5.39-1.el6.remi
Installing for dependencies:
 mysql-community-common                                     x86_64                                5.6.21-2.el6                                mysql56-community                                299 k

Transaction Summary
=====================================================================================================================================================================================================
Install       5 Package(s)

Total download size: 74 M
Downloading Packages:
(1/5): mysql-community-client-5.6.21-2.el6.x86_64.rpm                                                                                                                         |  18 MB     00:04
(2/5): mysql-community-common-5.6.21-2.el6.x86_64.rpm                                                                                                                         | 299 kB     00:00
(3/5): mysql-community-libs-5.6.21-2.el6.x86_64.rpm                                                                                                                           | 1.9 MB     00:00
(4/5): mysql-community-libs-compat-5.6.21-2.el6.x86_64.rpm                                                                                                                    | 1.6 MB     00:00
(5/5): mysql-community-server-5.6.21-2.el6.x86_64.rpm                                                                                                                         |  53 MB     00:11
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                4.5 MB/s |  74 MB     00:16
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  file /usr/lib64/mysql/libmysqlclient.so.16.0.0 from install of mysql-community-libs-compat-5.6.21-2.el6.x86_64 conflicts with file from package compat-mysql51-5.1.54-1.el6.remi.x86_64
  file /usr/lib64/mysql/libmysqlclient_r.so.16.0.0 from install of mysql-community-libs-compat-5.6.21-2.el6.x86_64 conflicts with file from package compat-mysql51-5.1.54-1.el6.remi.x86_64

Error Summary
-------------

I guess I need to remove that library?  But doing so looks a little scary... as it removes mysql server and many other things!


[root@test tmp]# yum remove compat-mysql51
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package compat-mysql51.x86_64 0:5.1.54-1.el6.remi will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be erased
--> Processing Dependency: perl(DBD::mysql) >= 1.0 for package: percona-toolkit-2.2.6-1.noarch
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.5.39-1.el6.remi.x86_64
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: vixie-cron for package: yum-cron-3.2.29-43.el6.centos.noarch
--> Processing Dependency: cronie = 1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be erased
---> Package percona-toolkit.noarch 0:2.2.6-1 will be erased
---> Package redhat-lsb-core.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.el6.centos.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased
---> Package redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos will be erased
---> Package redhat-lsb-printing.x86_64 0:4.0-7.el6.centos will be erased
---> Package yum-cron.noarch 0:3.2.29-43.el6.centos will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6_5.1.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-22.el6_5.1 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================================================
 Package                                            Arch                                  Version                                             Repository                                        Size
=====================================================================================================================================================================================================
Removing:
 compat-mysql51                                     x86_64                                5.1.54-1.el6.remi                                   @remi                                            4.2 M
Removing for dependencies:
 cronie                                             x86_64                                1.4.4-12.el6                                        @base                                            174 k
 cronie-anacron                                     x86_64                                1.4.4-12.el6                                        @base                                             43 k
 crontabs                                           noarch                                1.10-33.el6                                         @base/$releasever                                2.4 k
 mysql-server                                       x86_64                                5.5.39-1.el6.remi                                   @remi                                             45 M
 percona-toolkit                                    noarch                                2.2.6-1                                             @percona                                         5.8 M
 perl-DBD-MySQL                                     x86_64                                4.013-3.el6                                         @base                                            338 k
 postfix                                            x86_64                                2:2.6.6-6.el6_5                                     @updates                                         9.7 M
 redhat-lsb-core                                    x86_64                                4.0-7.el6.centos                                    @base/$releasever                                 22 k
 redhat-lsb-graphics                                x86_64                                4.0-7.el6.centos                                    @base/$releasever                                0.0
 redhat-lsb-printing                                x86_64                                4.0-7.el6.centos                                    @base/$releasever                                0.0
 sysstat                                            x86_64                                9.0.4-22.el6_5.1                                    @updates                                         823 k
 yum-cron                                           noarch                                3.2.29-43.el6.centos                                @updates                                          28 k

Transaction Summary
=====================================================================================================================================================================================================
Remove       13 Package(s)

Installed size: 66 M
Is this ok [y/N]: n
Exiting on user Command

Any help gratefully received, thank you.

Re: MySQL 5.6.19

This is an issue with a third party repo I'm not aware of (and don't want to be...)

compat-mysql51 is a compatibility library for base system.
So you have to find how to provide this library with the repo you are using.

So better to ask them.

Sorry, but I can't help for packages not from my repo.

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.6.19

perhaps you should try

$ yum shell
> remove compat-mysql51
> install mysql-community-libs-compat
> run
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.6.19

THANK YOU!
That worked a treat.

Re: MySQL 5.6.19

smile

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