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
1 | # yum install Percona-XtraDB-server Percona-XtraDB-client |
Debian platform.
1. Add Percona repository to the sources.list
1 2 | deb http://repo.percona.com/apt lenny main 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
1 | # apt-get install percona-xtradb-server percona-xtradb-client |
The binaries for supported platforms are located on https://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
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
Nice work. Do you have release notes for all of the changes between XtraDB and the InnoDB plugin?
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).
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.
Sebastien,
I guess we’re talking about debian according to names.
libpercona- is built from https://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.
Mark,
There is XtraDB changelog on https://www.percona.com/docs/wiki/percona-xtradb:info:xtradb_changelog
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.
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
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
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!
Aleksandr,
Thanks for answer 🙂
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.
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..
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.
@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.
Bonjour, je lili
Merci pour le partage