mysql-5.5.9
+
Par Remi le jeudi 10 février 2011, 20:21 - Archives - Lien permanent
RPM of MySQL Community Server 5.5.9 GA 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
Remi, please fix the example in supplied configuration file in rpm :)
to enabled semisynchronous replication, you should use
[mysqld]
plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
...instead of...
[mysqld]
rpl_semi_sync_master=semisync_master.so
rpl_semi_sync_slave=semisync_slave.so
keep a great job, thanks!
@fp, as indicated in the configuration file : "# Add to the above plugin-load option, if needed", so if you follow this tips, you will get the good line ;)
I don't want to add another plugin-load line (even as comment), as this will break the one already used for archive and blackhole engines.
Archived entry, see mysql-5.5.10