MariaDB 5.5.40 for CentOS 7

nmb

Verified User
Joined
Sep 13, 2008
Messages
223
I just updated MariaDB to 5.5.40 and noticed that on CentOS 7, the files download from DirectAdmin is specific for CentOS 6 which is actually works fine on CentOS 7. (Something like -> MariaDB-5.5.40-centos6-x86_64-shared.rpm)

However, I found that MariaDB also released files for CentOS 7 here -> http://ftp.yz.yamagata-u.ac.jp/pub/dbms/mariadb/mariadb-5.5.40/yum/centos7-amd64/rpms/

Not sure if there is anything different (Files for CentOS 7 are smaller though) but I think we should use the one made for CentOS 7 now.
 
There is no 32-bit version, so we opted for the CentOS 6 packages.
The CentOS 7 likely just has settings for the systemctl rather than /etc/init.d, but custombuild handles that anyway.
I don't think using the CentOS 6 versions will be an issue, but if anyone does, by all means, let us know :)

John
 
There is no 32-bit version, so we opted for the CentOS 6 packages.
The CentOS 7 likely just has settings for the systemctl rather than /etc/init.d, but custombuild handles that anyway.
I don't think using the CentOS 6 versions will be an issue, but if anyone does, by all means, let us know :)

John

Well, while upgrading yesterday and posted on the board, I stopped it to check your answer first, then, I went ahead and updated again. However, the update didn't work as it should, below is the error I got :

--2014-10-17 16:50:47-- http://files.directadmin.com/servic....40//MariaDB-5.5.40-centos6-x86_64-compat.rpm
Resolving files.directadmin.com (files.directadmin.com)... 69.30.193.202, 216.144.254.90
Connecting to files.directadmin.com (files.directadmin.com)|69.30.193.202|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2788448 (2.7M) [text/plain]
Saving to: 'MariaDB-5.5.40-centos6-x86_64-compat.rpm'

100%[======================================>] 2,788,448 71.8KB/s in 60s

2014-10-17 16:51:48 (45.2 KB/s) - 'MariaDB-5.5.40-centos6-x86_64-compat.rpm' saved [2788448/2788448]

Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-client.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-devel.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-server.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-shared.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-common.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-compat.rpm
Stopping mysqld ...
Updating MariaDB 5.5.39 to
warning: MariaDB-5.5.40-centos6-x86_64-client.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:MariaDB-compat-5.5.40-1.el6 ################################# [ 9%]
2:MariaDB-common-5.5.40-1.el6 ################################# [ 18%]
3:MariaDB-client-5.5.40-1.el6 ################################# [ 27%]
4:MariaDB-server-5.5.40-1.el6 ################################# [ 36%]
error: unpacking of archive failed on file /usr/sbin/mysqld;5440e6b6: cpio: read failed - No data available
error: MariaDB-server-5.5.40-1.el6.x86_64: install failed
5:MariaDB-devel-5.5.40-1.el6 ################################# [ 45%]
6:MariaDB-shared-5.5.40-1.el6 ################################# [ 55%]
Cleaning up / removing...
7:MariaDB-devel-5.5.39-1.el6 ################################# [ 64%]
error: MariaDB-server-5.5.39-1.el6.x86_64: erase skipped
8:MariaDB-client-5.5.39-1.el6 ################################# [ 73%]
9:MariaDB-shared-5.5.39-1.el6 ################################# [ 82%]
10:MariaDB-common-5.5.39-1.el6 ################################# [ 91%]
mysql.service is not a native service, redirecting to /sbin/chkconfig.
Executing /sbin/chkconfig mysql off
mv: cannot stat '/etc/systemd/system/mysql.service': No such file or directory
Giving mysqld a few seconds to start up...
Error: Server version (5.5.39-MariaDB) does not match with the version of
the server (5.5.40-MariaDB) with which this program was built/distributed. You can
use --skip-version-check to skip this check.
FATAL ERROR: Upgrade failed
Failed to ALTER DATABASE `#mysql50#ib_logfile-old` UPGRADE DATA DIRECTORY NAME
Error: Error on rename of './ib_logfile-old/ib_logfile0' to './ib_logfile@002dold/ib_logfile0' (Errcode: 13)
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
Shutting down MySQL.. SUCCESS!
Starting MySQL.. SUCCESS!

Then, I tried it a second time with ".build mysql". Below is what I got :

--2014-10-17 17:10:41-- http://files.directadmin.com/servic....40//MariaDB-5.5.40-centos6-x86_64-server.rpm
Resolving files.directadmin.com (files.directadmin.com)... 216.144.254.90, 69.30.193.202
Connecting to files.directadmin.com (files.directadmin.com)|216.144.254.90|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 45087580 (43M) [text/plain]
Saving to: 'MariaDB-5.5.40-centos6-x86_64-server.rpm'

100%[======================================>] 45,087,580 171KB/s in 11m 4s

2014-10-17 17:21:46 (66.4 KB/s) - 'MariaDB-5.5.40-centos6-x86_64-server.rpm' saved [45087580/45087580]

Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-client.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-devel.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-server.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-shared.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-common.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-5.5.40-centos6-x86_64-compat.rpm
Stopping mysqld ...
Updating MariaDB 5.5.40 to
warning: MariaDB-5.5.40-centos6-x86_64-client.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing... ################################# [100%]
package MariaDB-compat-5.5.40-1.el6.x86_64 is already installed
package MariaDB-common-5.5.40-1.el6.x86_64 is already installed
package MariaDB-client-5.5.40-1.el6.x86_64 is already installed
package MariaDB-devel-5.5.40-1.el6.x86_64 is already installed
package MariaDB-shared-5.5.40-1.el6.x86_64 is already installed
mysql.service is not a native service, redirecting to /sbin/chkconfig.
Executing /sbin/chkconfig mysql off
mv: cannot stat '/etc/systemd/system/mysql.service': No such file or directory
Giving mysqld a few seconds to start up...
Error: Server version (5.5.39-MariaDB) does not match with the version of
the server (5.5.40-MariaDB) with which this program was built/distributed. You can
use --skip-version-check to skip this check.
FATAL ERROR: Upgrade failed
Failed to ALTER DATABASE `#mysql50#ib_logfile-old` UPGRADE DATA DIRECTORY NAME
Error: Can't create database 'ib_logfile-old'; database exists
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
Shutting down MySQL.. SUCCESS!
Starting MySQL... SUCCESS!
 
Hmm... I don't see MariaDB-server in this list... not sure why:
Code:
Preparing... ################################# [100%]package MariaDB-compat-5.5.40-1.el6.x86_64 is already installed
package MariaDB-common-5.5.40-1.el6.x86_64 is already installed
package MariaDB-client-5.5.40-1.el6.x86_64 is already installed
package MariaDB-devel-5.5.40-1.el6.x86_64 is already installed
package MariaDB-shared-5.5.40-1.el6.x86_64 is already installed

Can you double check that you've got the current version of the build script?
Code:
./build version
Currently: 2.0.0-RC7 (rev: 1069)

and then try:
Code:
./build update
./build mysql
John
 
There is no 32-bit version, so we opted for the CentOS 6 packages.
The CentOS 7 likely just has settings for the systemctl rather than /etc/init.d, but custombuild handles that anyway.
I don't think using the CentOS 6 versions will be an issue, but if anyone does, by all means, let us know :)

John

Is a there need for a 32-bit package at all, isn't CentOS 7 64-bit only?
 
Is a there need for a 32-bit package at all, isn't CentOS 7 64-bit only?

Yes, but they do provide select libraries it seems in 32 bit (from redhat)

Red Hat Enterprise Linux 7 will only provide 64-bit ISO's, thus allowing only a 64-bit operating environment. However, 32-bit is supported in the following ways:
  • RHEL 7 will continue to provide selected libraries in both 32-bit and 64-bit, allowing 32-bit applications to run in the 64-bit RHEL 7 OS environment. This functionality also exists for RHEL 5 & 6 as documented in the knowledge article: How to install 32-bit packages on a 64-bit system
  • RHEL 7 will continue to support the multilib toolchain, allowing applications to be compiled for both 32-bit and 64-bit.
  • RHEL 7 can host, using KVM virtualization technology, both 32-bit and 64-bit virtual guest instances of RHEL 5 and RHEL 6
While RHEL 7 will not natively support 32-bit hardware, certified hardware can be searched for in the certified hardware database.
 
Back
Top