March 14, 2010

Percona-XtraDB version 9.1

Posted by Aleksandr Kuzminsky |

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

PLAIN TEXT
CODE:
  1. # yum install Percona-XtraDB-server Percona-XtraDB-client

Debian platform.

1. Add Percona repository to the sources.list

PLAIN TEXT
CODE:
  1. deb http://repo.percona.com/apt lenny main
  2. deb-src http://repo.percona.com/apt lenny main

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

PLAIN TEXT
CODE:
  1. # apt-get install percona-xtradb-server percona-xtradb-client

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

Posted by Aleksandr Kuzminsky @ 9:13 pm :: announce, mysql  
Print This Post Print This Post book mark Percona-XtraDB version 9.1 in del.icio.usdel.icio.us :: submit Percona-XtraDB version 9.1 to digg.comdigg  
Comment RSS  
Related posts: :XtraDB / InnoDB internals in drawing::XtraDB storage engine release 1.0.3-7::XtraDB storage engine release 1.0.4-8:
 

13 Comments »

  1. 1. Sebastien

    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

    Comment :: March 15, 2010 @ 4:14 am

  2. 2. Mark Callaghan

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

    Comment :: March 15, 2010 @ 7:50 am

  3. 3. Jeffrey Gilbert

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

    Comment :: March 15, 2010 @ 9:11 am

  4. 4. Sean Milheim

    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.

    Comment :: March 15, 2010 @ 9:56 am

  5. 5. Aleksandr Kuzminsky

    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.

    Comment :: March 15, 2010 @ 10:52 am

  6. 6. Aleksandr Kuzminsky

    Mark,

    There is XtraDB changelog on http://www.percona.com/docs/wiki/percona-xtradb:info:xtradb_changelog

    Comment :: March 15, 2010 @ 11:00 am

  7. 7. Aleksandr Kuzminsky

    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.

    Comment :: March 15, 2010 @ 11:59 am

  8. 8. peter

    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

    Comment :: March 15, 2010 @ 2:17 pm

  9. 9. Aleksandr Kuzminsky

    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

    Comment :: March 15, 2010 @ 2:38 pm

  10. 10. Jeffrey Gilbert

    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!

    Comment :: March 15, 2010 @ 4:15 pm

  11. 11. Sebastien

    Aleksandr,

    Thanks for answer :)

    Comment :: March 16, 2010 @ 2:27 am

  12. 12. Sean Milheim

    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.

    Comment :: March 16, 2010 @ 8:04 am

  13. 13. Matthieu

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

    Comment :: March 17, 2010 @ 12:27 am

 

Subscribe without commenting

Trackbacks/Pingbacks