MySQL Community Server 5.5.8 - Remi's RPM repository

MySQL Community Server 5.5.8

Par Remi le jeudi 23 décembre 2010, 00:14 - Archives - Lien permanent

RPM of the first Release Candidate of MySQL Community Server 5.5 are available in remi repository for fedora and remi-test for Enterpise Linux (RHEL, CentOS, ...).

From now, this stable version (Generally Available (GA) Release) is available in the remi repository for fedora, and so will replace the 5.1 version. It stay for some time in the remi-test repository for Enterprise Linux (but I don't plan to maintain 5.1 package for a long time).

To read :

This build use a spec file close to the one from Rawhide

The Federated, Archive and Blackhole storage engines are provided as plugin. See the comments in the configuration file.

WARNING: before upgrading, a full backup of your databases seems mandatory (a logical dump using mysqldump for example).

Simplest way to install is to use yum !

yum --enablerepo remi-test update mysql-server

For whose who prefer the download and manual installation, see the repository

WARNING: database created with an older version couldn't be used directly. You need to start the server without right management to run the database upgrade and create new right table (else, the server will fail to start and will record the message: [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.proxies_priv' doesn't exist) .

Running the mysql_upgrade command is mandatory. It checks all tables in all databases for incompatibilities with the current version of MySQL Server. If a table is found to have a possible incompatibility, it is checked. If any problems are found, the table is repaired. In all case, reading the documentation is recommended:

The service init script have been improved in this version to allow to run this quite simply:

# start in rescue mode (with --skip-grant-tables and --skip-networking options)
service mysqld startsos
mysql_upgrade
# re-launch in normal mode
service mysqld restart

Packages available for fedora >= 9.

Packages available for enterprise linux >= 4 (running on this server).

Commentaires

1. Le mercredi 22 décembre 2010, 23:21 par Marek

service mysqld startsos
Usage: /etc/init.d/mysqld {start|stop|status|restart|condrestart|try-restart|reload|force-reload}

On CentOS 5.5 64-bit

2. Le mercredi 22 décembre 2010, 23:22 par Marek

I did something wrong. I've updated directly from Oracle.

Will try again with your repo.

3. Le mercredi 22 décembre 2010, 23:29 par Remi

Yes, the "startsos" mode is specific to my RPM. I have add it to simplify the upgrade process.

4. Le jeudi 23 décembre 2010, 10:59 par Marek

Do I have to stop MySQL first before running yum and then startsos?

5. Le jeudi 23 décembre 2010, 11:57 par Remi

@Marek: No

During the "yum update", service is restarted.

After the yum update, check if mysqld is running

1/ if it's running, update was ok, no others need than running a mysql_upgrade, as always (it was ok for me on 5.1.54 to 5.5.8 update, on this server)

2/ if it's not running, you need to use the above command (startsos) to be able to achieve mysql_upgrade (if was ko for me on 5.5.6 to 5.5.7 update)

6. Le jeudi 23 décembre 2010, 18:38 par Remi

I've just finish to build the remaining RPM (fedora >= 9 and EL >= 5), older versions doesn't have the minimal required cmake version.

7. Le dimanche 26 décembre 2010, 22:13 par Marek

Just updated to MySQL 5.5.8 from 5.1.50. Server rebooted, but I need to run mysql_upgrade.

How long it should take to run it ?

I got:

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments

and it's staying this way very long so far...

8. Le dimanche 26 décembre 2010, 22:19 par Marek

OK. It works ;)

9. Le mardi 28 décembre 2010, 18:04 par Remi

Update to 5.5.8-2 (fedora 13 and 14), synced with rawhide changes.

10. Le dimanche 9 janvier 2011, 13:32 par Reindl Harald

Hm compat-mysql51-5.1.54 seems to missing libmysqlclient.so.16 :-(

pure-ftpd beenden: [FEHLGESCHLAGEN]
pure-ftpd starten: /usr/sbin/pure-ftpd: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
[FEHLGESCHLAGEN]

[root@srv-rhsoft:~]$ ls /usr/lib64/mysql/
insgesamt 16M
drwxr-xr-x 2 root root 4,0K 2010-12-29 16:47 plugin
-rwxr-xr-x 1 root root 12K 2010-12-29 16:29 mysqlbug
-rwxr-xr-x 1 root root 6,9K 2010-12-29 16:42 mysql_config
-rwxr-xr-x 1 root root 2,1M 2010-12-22 21:03 libmysqlclient_r.so.16.0.0
-rwxr-xr-x 1 root root 2,9M 2010-12-29 16:42 libmysqlclient.so.161.0.0
lrwxrwxrwx 1 root root 18 2010-12-29 16:48 libmysqld.so.0 -> libmysqld.so.0.0.1
-rwxr-xr-x 1 root root 11M 2010-12-29 16:42 libmysqld.so.0.0.1
lrwxrwxrwx 1 root root 26 2010-12-27 17:36 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 root root 25 2010-12-29 16:47 libmysqlclient.so.161 -> libmysqlclient.so.161.0.0

11. Le dimanche 9 janvier 2011, 13:59 par Reindl Harald

Please provide a src.rpm for compat-mysql51
http://rpms.famillecollet.com/SRPMS... has none
Rebuild pure-ftpd with mysql 5.5 devel does not work as solution :-(

libpureftpd.a(libpureftpd_a-log_mysql.o): In function `pw_mysql_check':
/home/builduser/rpmbuild/BUILD/pure-ftpd-1.0.29/src/log_mysql.c:454: undefined reference to `make_scrambled_password'
collect2: ld returned 1 exit status
make[2]: *** [pure-ftpd] Error 1
make[2]: *** Waiting for unfinished jobs...

12. Le dimanche 9 janvier 2011, 15:39 par Remi

@Reindl : please use the forums...

.src.rpm uploaded

$ rpm -qf  /usr/lib64/mysql/libmysqlclient.so.16
compat-mysql51-5.1.54-1.fc14.remi (x86_64)

13. Le dimanche 9 janvier 2011, 16:05 par Reindl Harald

thank you and sorry, next time i search forum

interesting: after reinstall with "rpm ivh --force" it works
seems there happened something wrong while plaing with personal builds of mysql5.5 in the past, i noticed this after reboot today because pure-ftpd did run since last year :-)

14. Le dimanche 9 janvier 2011, 18:59 par Remi

Update to 5.5.8-3 (fedora 9 to 12, for now), synced with rawhide changes.

15. Le mercredi 12 janvier 2011, 18:04 par Remi

Add the EL-4 build

16. Le jeudi 10 février 2011, 19:22 par Remi

Archived entry, see mysql-5.5.9

Remi's RPM repository - Blog