PlanetMysql.ru – информация о СУБД MySQL

We’re opening up registration for our new training courses today.  In short: we are moving from two days to a new four-day format.  The new additions are created by:

• Splitting our current InnoDB day in half. We now have one day for DBAs, and one day just on InnoDB topics.
• A new Operations Day – covering how to maintain MySQL in production.

Our developer course has also undergone revision, and we now have more query tuning examples, and a new instrumentation chapter.

What is operations training?

Many companies split their technical staff between development, and operations.  The operations team is responsible for tasks such as capacity planning, backup/disaster recovery, and carrying a pager. They are the heroes that fight fires.

Our operations day of training is delivered as a hands on class.  Attendees will be divided into teams, and given a series of challenges to complete on EC2 machines.  As part of the development of this course we wrote a sample LAMP application, embedded with minor flaws which students will need to fix while they try and keep the application up.

Where can you attend?

We’re starting off by branding the operations day as a ‘BETA’.  You can attend for only $100 at San Francisco Thursday, 30 Sep 2010, New York Thursday, 14 Oct 2010 or Vancouver Thursday, 21 Oct 2010. There is also a discount of attending all four days for $1,450 if you book before 30 August.

After our initial BETA, the courses will be available in more USA and international locations. A partial list is already available on the training section of our website. We will confirm more cities in the coming weeks.

Entry posted by Morgan Tocker | No comment

Add to: | | | |

Dear Community,

Percona Server version 5.1.47-rel11.0 is available for download now.

The changes in this release include:

New features

• Percona Server is now based on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8.
• XtraDB now uses the fast recovery code released in InnoDB Plugin version 1.0.8, instead of Percona's earlier fast-recovery code.
• Added the --percona_innodb_doublewrite_path option to place the double-write-buffer into its own file (issue #584299). The feature is sponsored by Large Social Network website.
• Added the --suppress_log_warning_1592 option to disable logging of error code 1592.
• Added the --microseconds_in_slow_query_log option to use microsecond precision for the slow query log's timestamps (issue #358412).
• Added the --use_global_log_slow_control option to control slow-query logging globally without restarting, similar to --use_global_long_query_time.
• Added the --query_cache_strip_comments option to strip comments from query before using it in query cache.
• Added a global Innodb_deadlocks counter to SHOW STATUS, based on a patch by Eric Bergen (issue #569288, issue #590624).
• Added more tests to the MySQL test framework.

Fixed bugs

• #573100 Can't compile 5.1.46
• #573104 separate name in INNODB_SYS_TABLES table
• #580324 Security bug in upstream
• #586579 Percona Server 11 fails to compile with CFLAGS=-DUNIV_DEBUG
• #569156 CentOS 5: mysql-server conflicts with MySQL-server
• #589639 Recovery process may hang when tablespaces are deleted during the recovery
• #570840 deb package conflicts with libdbd-mysql-perl

The binary packages are available on our website.

Starting from this release there is a uniform naming scheme for Percona binaries for 5.0 and 5.1 based packages. RPM are named as:
Percona-Server-<sub package>-<package suffix>-<mysql version>-<release number>.<revision number>.<os code>.<platform>.rpm
Examples:

Here:

• "Percona-Server" is a name of the product.
• "server" or "client" - sub-package
• 51 - suffix, which means the packages are based on 5.1.x versions

Together "Percona-Server-server-51" is the package name.

• 5.1.47 is the MySQL version the package is based on
• rel11.0 is  release number
• 46 is BZR revision
• rhel5 is an operating system code
• x86_64 is a platform

Percona Server obsoletes Percona XtraDB both on rhel and debian paltform. To install RPM or DEB package from Percona repository you just have to do "yum install Percona-Server-server-51". If there is Percona-XtraDB installed it will be replaced by Percona Server. However Percona-Server doesn't obsolete MySQL, so you have to deinstall it first. Conflicts are inevitable otherwise.

If there are MySQL dependant  applications already installed, you might want to install Percona Shared Compat package before installing Percona Server.

The latest source code of Percona Server, including development branch you can find on LaunchPAD.

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

For support, commercial and sponsorship inquiries contact Percona

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

As you may know MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases of Percona Server 5.0 and Percona Server / XtraDB 5.1 with security patches.

Fixed bugs:

• Bug#53371, CVE-2010-1848
• Bug#53237, CVE-2010-1850
• Bug#50974, CVE-2010-1849

Release Percona Server 5.0.91-rel22 is available in our download area:
http://www.percona.com/downloads/Percona-Server-5.0/Percona-Server-5.0.91-22/

Release Percona Server/XtraDB 5.1.45-rel10.2 is available also ( we backported patches from 5.1.47 to 5.1.45):
http://www.percona.com/downloads/Percona-Server-5.1/Percona-Server-5.1.45-10.2/

Updated RPM and DEB are also available in our repositories.

We know that there still are many active MySQL 4.0 and MySQL 4.1 installations and we understand how hard it is upgrade 4.0/4.1 to 5.1. With published exploits these installation are now under serious risks, that’s why we have prepared patches for MySQL 4.0 and MySQL 4.1. The binaries with security fixes for MySQL 4.0/4.1 are available under Percona Maintenance package.

Entry posted by Vadim | No comment

Add to: | | | |

Dear Community,

Percona Server 5.0.90, build 21 is available for use.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.90
• The name of the packages are changed to Percona-SQL-server, Percona-SQL-client, etc.

Fixed bugs:

• Fixed Bug #539190
• Fixed Bug #479106
• Fixed tests mysql, mysql_upgrade, ssl*

See release notes for earlier changes.

RPMs and DEB packages are available in Percona repository.

As usual you can download binaries and sources with the patches from Percona web site.

To upgrade from MySQL server to Percona SQL you need remove MySQL installation first, then install Percona-SQL-server and Percona-SQL-client:

If you are running applications which depend on libmysqlclient, install  Percona-SQL-shared-compat

before removing MySQL

The Percona Server lives on Launchpad : https://launchpad.net/percona-server and you can report bug to Launchpad bug system:

https://launchpad.net/percona-server/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

innodb_rw_lock.patch

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Dear Community,

Percona Server 5.0.90, build 21 is available for use.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.90
• The name of the packages are changed to Percona-SQL-server, Percona-SQL-client, etc.

Fixed bugs:

• Fixed Bug #539190
• Fixed Bug #479106
• Fixed tests mysql, mysql_upgrade, ssl*

See release notes for earlier changes.

RPMs and DEB packages are available in Percona repository.

As usual you can download binaries and sources with the patches from Percona web site.

To upgrade from MySQL server to Percona SQL you need remove MySQL installation first, then install Percona-SQL-server and Percona-SQL-client:

If you are running applications which depend on libmysqlclient, install  Percona-SQL-shared-compat

before removing MySQL

The Percona Server lives on Launchpad : https://launchpad.net/percona-server and you can report bug to Launchpad bug system:

https://launchpad.net/percona-server/+filebug. The documentation is available on our Wiki

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

innodb_rw_lock.patch

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Percona wants to upgrade our documentation to improve its readability
and to make it more useful for you, our clients and partners. We are
so busy developing software and handling your needs that we have
trouble finishing all the documentation! We think you can help.

Helping us will give you a chance to interact closely with lead Perona
developers and learn more about Percona’s products as well as our
development process.

Tasks include talking to developers, writing text, and interacting
with an editor. (Andy Oram, our O’Reilly editor on the book High
Performance MySQL, will take on the volunteer role.) You should have
some understanding of MySQL and Percona’s extensions, and of way
XtraDB and XtraBackup work.

Documents we want to start with include:

* Product features (we made a start at

http://www.percona.com/docs/wiki/percona-xtradb:features:start)

* Release notes

* Installation instructions for XtraBackup

Eventually we’ll also upgrade our user guides, a bigger job.

If this work intrigues you, please contact Andy Oram and
andyo@praxagora.com. Andy has offered to coordinate efforts for free,
although we will pay him for professional editing.

Entry posted by Vadim | No comment

Add to: | | | |

Dear Community,

The notice is hereby given that next version 1.2 of XtraBackup software is released.

The list of changes in this version includes:
Changelog:

• XtraBackup supports now XtraDB 10
• tar4ibd supports variable page size and fast_checksum of XtraDB
• Supported 32bit platform for Centos 5, Centos 4, Debian lenny and etch, Ubuntu Karmic, Jaunty, Intrepid, Hardy, FreeBSD

Fixeb bugs in this release:

• Bug #550776: "--use-memory" is not used at InnoDB-Plugin based version

The binary packages for as well as source code of the XtraBackup is available on http://www.percona.com/percona-builds/XtraBackup/XtraBackup-1.2/.

Debian and RPM are available in Percona repository.

Since now debian packages in Percona APT repository are signed by our private key.

To check authenticity of the packages you need to install the public key:

To verify source code, you have to install the key in trastedkeys.gpg:

The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki.

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

We've just launched training for London, Seattle, San Francisco, Atlanta, Orlando, Columbus, Dallas, San Diego, Denver, Minneapolis, New York City, Chicago & Washington DC.  This is in addition to Los Angeles, Raleigh & Toronto - which had previously been scheduled.

If you organize a meetup group in one of these cities, get in touch.  In the last six months we've visited community events in New York, Los Angeles, Atlanta, Seattle, Chicago, Boston, Washington DC and Montreal.  If schedules overlap, we'd be happy to add you to that list.

Entry posted by Morgan Tocker | No comment

Add to: | | | |

Dear Community,

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

Due to political reasons 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 obsoltest mysql-server packages, so upgrade is pretty straightforward.
Instead of updating currently installed packages Percona-XtraDB should be installed. It will repleace currently installed mysql-server, mysql-client, etc.

Centos platform.
1. If you didn't install yet Percona YUM repo, please do it. It is avaiable noth 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

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that's just single workload. That's why we are looking into different benchmarks, and one
of them is TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration.

You can download it from our Lauchpad Percona-tools project, it's
bzr branch lp:~percona-dev/perconatools/tpcemysql

Important DISCLAIMER:
Using this package you should agree with TPC-E License Agreement,
which in human words is:

• You can't name results as "TPC Benchmark Results"
• You can't compare results with results published on http://www.tpc.org/ and you can't pretend the results are compatible with published by TPC.

And we are not going to do anything from that, your primary goals is XtraDB/InnoDB performance research and/or compare with available Storage Engines for MySQL.

The workload in tpce is quite different from tpcc. Tpcc is write intensive, while tpce
is read oriented.
To give more details, there is stats for 10 seconds:

The result is quite chatty,

but it allows you to see count of 11 different transactions per 10 secs and 90% response time.

and final result

where you can see count of successful TR (TradeResult) transactions, and
the summary result in TpsE (transactions per seconds).

Expect our results soon!

Entry posted by Vadim | No comment

Add to: | | | |