October 30, 2014

Percona-XtraDB version 9.1

Dear Community,

We are announcing today the new version 9.1 of XtraDB storage engine.

The name of binaries has changed to Percona-XtraDB. It is applicable to all packages including RPM, DEB and tar.gz packages.

New features in version 9.1:

  • MySQL 5.1.43 is taken as the basis
  • packages name changed to Percona-XtraDB
  • Enabled support of SSL
  • Enabled profiling
  • Added script to sort LRU dump
  • New supported platforts are added. The full list includes:
    • CentOS 5 (x86_64 and i386)
    • CenOS 4 (x86_64 and i386)
    • Debian lenny (x86_64 and i386)
    • Debian etch (x86_64 and i386)
    • Ubuntu  Jaunty (x86_64 and i386)
    • Ubuntu Intrepid (x86_64 and i386)
    • Ubuntu Hardy (x86_64 and i386)
    • FreeBSD 8 (x86_64 and i386)
    • OpenSolaris (x86_64)

Fixed bugs:

  • Bug #506894: buf_flush_LRU_recommendation() is too optimistic
  • Fixed mysql-tests:
    • mysql
    • mysql_upgrade
    • ssl tests
    • enabled rpl_killed_ddl and innodb-autoinc tests


Percona-XtraDB obsoletes mysql-server packages, so upgrade is pretty straightforward.
Instead of updating currently installed packages Percona-XtraDB should be installed. It will replace currently installed mysql-server, mysql-client, etc.

Centos platform.
1. If you didn’t install yet Percona YUM repo, please do it. It is available both for x86_64 and i386.

2. Install Percona-XtraDB

Debian platform.

1. Add Percona repository to the sources.list

Instead of “lenny” put the name of your distribution.
2. Update the repository with “apt-get update”
3. Install Percona-XtraDB package

The binaries for supported platforms are located on http://www.percona.com/percona-builds/Percona-XtraDB/Percona-XtraDB-5.1.43-9.1/ .
The latest source code of XtraDB, including development branch you can find on LaunchPAD.

Please report any bugs found on Bugs in Percona XtraDB server.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona

About Aleksandr Kuzminsky

Aleksandr is a consultant and data recovery specialist.
He is a former Percona employee.

Comments

  1. Sebastien says:

    Hello,

    I’am going to try percona xtra db replacing mysql 5.1.44.
    Installation was easy, and no problem appear.

    But, libmysql is replacing by libpercona-mysql, and nagios-plugins dont work any more.

    Did you plubish source of libpercona anywhere ?

    Thanks

  2. Mark Callaghan says:

    Nice work. Do you have release notes for all of the changes between XtraDB and the InnoDB plugin?

  3. Jeffrey Gilbert says:

    Is there planned support in your yum repo for php-mysql with php 5.2.10(the test builds for centos)? I had quite a time trying to get that working on my dev machine and ended up rolling back to mysql 5.1 or 5.0 (can’t remember off the top of my head).

  4. Sean Milheim says:

    One thing we noticed when testing this on Debian is all packages that rely on mysql-server, mysql-client etc. were all wanting to uninstall the percona packages and install mysql-server packages.

  5. Aleksandr Kuzminsky says:

    Sebastien,

    I guess we’re talking about debian according to names.
    libpercona- is built from http://www.percona.com/percona-builds/Percona-XtraDB/Percona-XtraDB-5.1.43-9.1/deb/jaunty/x86_64/percona-xtradb-dfsg-5.1_5.1.43-xtradb-1.0.6-9.1-60.jaunty.11.tar.gz (assuming you’re running jaunty).
    However, nagios-plugins depends on libmysqlclient15off while while MySQL-5.1 and respectively Percona-XtraDB provides libmysqlclient16.
    I filed a bug https://bugs.launchpad.net/percona-xtradb/+bug/539190 for this issue.

  6. Aleksandr Kuzminsky says:
  7. Aleksandr Kuzminsky says:

    Jeffrey,

    We are not planning to add php-mysql to the Percona repo due to lack of resources.
    You can easily install it with MySQL-shared-compat-5.1.40-2 package.
    I.e. once you installed Percona-XtraDB-server and Percona-XtraDB-client, install MySQL-shared-compat-5.1.40-2.
    Then “yum install php-mysql” will work.

  8. peter says:

    Aleksandr,

    Many dependencies may break if you install MySQL 5.1 (or percona versions) on CentOS 5 as there is a lot of software which is linked to libmysqlclient15.so I think we just need to have shared-compat package which will include 15.so (at least) or may be even 14.so

  9. Aleksandr Kuzminsky says:

    Peter,

    There is MySQL-shared-compat in our repo. it provides .12.so – .16.so:

    MySQL-shared-compat.x86_64 : MySQL shared client libraries for MySQL 5.1.40, 5.0.87, 4.1.22 and 4.0.26

  10. Jeffrey Gilbert says:

    Aleksandr,

    That’s good enough, if not better than supporting it yourself. Wasn’t aware that would work. I’ll give this a whirl when I get back to that server. Thanks for the tip!

  11. Sebastien says:

    Aleksandr,

    Thanks for answer :)

  12. Sean Milheim says:

    On Debian the new package name is causing dependency issues. Example, after installing the percona-xtradb* packages when I try to install maatkit I am told that all of the percon-* packages will be Removed and replaced with mysql-* pacakges.

  13. Matthieu says:

    Sean,

    I think your problem is linked to the following bug report :

    https://bugs.launchpad.net/percona-xtradb/+bug/539190 as stated by Aleksandr

    We have the same issue here with Debian Lenny..

  14. Skaag says:

    If you run Ubuntu Lucid, make sure you do the following BEFORE you install the Percona binaries;

    apt-get remove mysql-server-core-5.1 mysql-client-core-5.1

    If you don’t do this you will end up with a broken install of the percona client/server, since there is a conflict with man pages.
    If you already started, and find yourself in a pickle, use aptitude to remove the percona binaries as well as the above binaries.
    This will clear everything nicely and you can try again to install the percona binaries, this time without any errors/warnings.

  15. @Skaag: thanks for your comment. It saved me big time so I thought I should expand on your point a little by writing out the steps. I had already messed my installation up as you stated above, and eventually succeeded in getting things right by doing this:

    apt-get remove percona-server-server
    apt-get remove mysql-server-core-5.1 mysql-client-core-5.1
    apt-get install percona-server-server

    Easy enough.

  16. Bonjour, je lili
    Merci pour le partage

Speak Your Mind

*