Today we’re celebrating Percona’s 7th anniversary. A lot has changed in these past 7 years – we have grown from a two-person outfit focused exclusively on consulting to a 100-person company with teammates in 22 different countries and 18 different states, now providing Support, Consulting, RemoteDBA, Server Development and Training services.
We also made our mark in open source software development, creating some of the most popular …
[Read more]Poor pt-heartbeat 2.1: it was perfectly fine through Percona Toolkit 2.1.7, but it’s had a rough life since. Its troubles are finally over as of Percona Toolkit 2.1.10. At a conference recently, a user joked to me that “Percona Toolkit is awesome, but you really broke pt-heartbeat.” It’s true, and if you haven’t heard or experienced the story, here it is for the record.
Since the dawn of time, pt-heartbeat had computed slave lag like:
t1=time (Perl) --> replicate --> t2=time (Perl); lag = t2 - t1
Surprisingly, that worked for many years despite what should have been an obvious problem: different time zones: t1 could be in PST …
[Read more]Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.
Changelog:
* Added Galera/MySQL Monitoring Template for Cacti
* Added “Disk Read/Write Time per IO Request (ms)” graph
* Added “MySQL InnoDB Buffer Pool Efficiency” graph
* Switched ss_get_mysql_stats.php to PHP MySQLi extension and
made it working with SSL (bug 1193097)
* Added user info to the max_duration check of
pmp-check-mysql-innodb plugin (bug 1185513)
* ss_get_mysql_stats.php default values for ‘$status’ array were
null instead of 0 (bug 1070268)
* Introduction of innodb_read_views_memory overrode the InnoDB
total memory allocated …
It was once said that “real artists ship.” In looking over the history of Percona software releases, we are currently shipping more software than ever before.
First, let’s look at Percona Server. Let’s look at all major versions: 5.1, 5.5 and 5.6 as well as the total for each year. The estimate for 2013 comes from assuming the second half of 2013 is similar to the first half.
Percona Server releases per year
In 2011, when Percona Server 5.5 came along, we see a sharp reduction in Percona Server 5.1 releases (remember that there’s at least one Percona Server 5.1 release for each Oracle MySQL 5.1 release, and this reduction is likely a reflection of the reduction of releases from Oracle). In 2011, 2012 and 2013 we see a pretty steady number of Percona Server 5.1 releases. It seems that 5.1 is not going anywhere yet.
For Percona Server 5.5, we see an increase in 2012, which likely mirrors an …
[Read more]Percona is glad to announce the release of Percona Toolkit 2.1.10 on July 18th, 2013 (Downloads are available here).
Bugs Fixed:
--utc option
for pt-heart was still broken because “MySQL interprets
date as a value in the current time zone and converts it to an
internal value in UTC.” Now the tool works correctly with
--utc by specifying “SET
time_zone='+0:00'“, and older versions of the tool can
be made to work by specifying --set-vars
"time_zone='+0:00'". Bug fixed …Percona is glad to announce the release of Percona Toolkit 2.2.4 on July 17th, 2013 (Downloads are available here and from the Percona Software Repositories).
New Features:
--output json
includes query examples as of v2.2.3. Some people might not
want this because it exposes real data. New option,
--output json-anon, has been implemented. This
option will provide the same data without query examples. It’s …Run Ubuntu and want to try new features of Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA) percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated.
We are currently building for Ubuntu lucid (10.04LTS), Precise (12.04), Quantal (12.10) and Raring (13.04).
To add the repository to your Ubuntu system, simply run:
sudo add-apt-repository ppa:percona-daily/percona-xtrabackup
You will now have daily builds of Percona XtraBackup available to install.
Currently, we are in the process of working on the 2.1.4 release. The daily builds currently include some code that is destined for 2.1.4 including: fixes for bugs: …
[Read more]Percona Server’s “crash-resistant replication” feature is useful in versions 5.1 through 5.5. However, in Percona Server 5.6 it’s replaced with Oracle MySQL 5.6′s “crash safe replication” feature, which has it’s own implementation (you can read more about it here).
A MySQL slave normally stores its position in files master.info and relay-log.info which are updated by slave IO_THREAD & slave SQL_THREAD respectively. The file master.info contains connection info & replication coordinates showing how many events were fetched from the master binary log. The relay-log.info, on the other hand, represents info showing the positions where the slave applied those events. You can read more about slave status logs …
[Read more]Percona Server version 5.1.70-14.8
Percona is glad to announce the release of Percona Server 5.1.70-14.8 on July 3nd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.70, including all the bug fixes in it, Percona Server 5.1.70-14.8 is now the current stable release in the 5.1 series. All of Percona‘s software is …
[Read more]Percona Server for MySQL version 5.6.12-60.4
Percona is glad to announce the second Release Candidate release of Percona Server 5.6.12-60.4 on June 27th, 2013 (Downloads are available here and from the Percona Software Repositories).
Based on the recently released MySQL 5.6.12, including all the bug fixes in it, Percona Server 5.6.12-60.4 is the second RC release in the Percona …
[Read more]