Percona Server version 5.6.13-61.0
Based on MySQL 5.6.13, including all the bug fixes in it,[Read more...]
Percona Server version 5.6.13-61.0
Based on MySQL 5.6.13, including all the bug fixes in it,[Read more...]
Percona Server provides users with a variety of powerful benefits including enterprise-grade features, high performance in demanding use cases, rich diagnostics, and access to unique Percona XtraBackup capabilities, all for free and open source. In addition, Percona Server is a drop-in MySQL replacement. Compatibility with MySQL has important ramifications (as well as some risks) as Giuseppe Maxia highlighted in a recent blog post about MySQL alternatives. Our commitment to drop-in compatibility with MySQL has important benefits for Percona Server users and drives our[Read more...]
Companies say they value the enterprise-grade features and high performance that Percona Server delivers for free and use the software to power critical business applications, hot new apps, and even a growing web host.
We’d love to hear from you. If you use Percona Server or our other software in a production environment,[Read more...]
I recently blogged on setting up Experimental Git mirror of Oracle MySQL trees up on GitHub. I’m now happy to announce that there are also mirrors for:
I’ve also updated the Oracle MySQL GIT mirror to include MySQL 5.7 and the (now abandoned) MySQL 6.0. I include the abandoned 6.0 tree as it can provide useful archaeology as to where some code came from.
I’d love to hear about any positive/negative experiences using these[Read more...]
Percona XtraDB Cluster (PXC) is different enough from async replication that it can be a bit of a puzzle how to do things the Galera way. This post will attempt to illustrate the basics of setting up 2 node PXC cluster from scratch.Requirements
Two servers (could be VMs) that can talk to each other. I’m using CentOS for this post. Here’s a dirt-simple Vagrant setup: https://github.com/jayjanssen/two_centos_nodes to make this easy (on Virtualbox).
These servers are talking over the 192.168.70.0/24 internal network for our example.
jayj@~/Src $ git clone https://github.com/jayjanssen/two_centos_nodes.git jayj@~/Src $ cd two_centos_nodes jayj@~/Src/two_centos_nodes $[Read more...]
While we are working hard on the final push of Percona Server 5.6 GA (I know that many people are waiting on this, but stay with us – we want to ensure that we have a quality release with great performance), I decided to make an experimental build of Percona Server 5.6 with the TokuDB engine.
It’s available here: http://www.percona.com/downloads/TESTING/Percona-TokuDB/.
If you are interested, please test it and provide us with feedback. If things look good, in couple months we may release an official Percona Server 5.6 with TokuDB.
The post[Read more...]
Percona XtraBackup 2.0.8 was released September 4.
Percona is glad to announce the release of Percona XtraBackup 2.0.8 on September 4, 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.
This release is the current GA (Generally[Read more...]
Percona Server version 5.1.71-14.9
Percona is glad to announce the release of Percona Server 5.1.71-14.9 on August 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.71, including all the bug fixes in it, Percona Server 5.1.71-14.9 is now the current stable release in the[Read more...]
Percona Server version 5.5.33-31.1
Percona is glad to announce the release of Percona Server 5.5.33-31.1 on August 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.33, including all the bug fixes in it, Percona Server 5.5.33-31.1 is now the current stable release in the[Read more...]
We receive this question about the ibdata1 file in MySQL very often in Percona Support.
The panic starts when the monitoring server sends an alert about the storage of the MySQL server – saying that the disk is about to get filled.
After some research you realize that most of the disk space is used by the InnoDB’s shared tablespace ibdata1. You have innodb_file_per_table enabled, so the question is:
Percona Toolkit’s pt-archiver is one of the best utilities to archive the records from large tables to another tables or files. One interesting thing is that pt-archiver is a read-write tool. It deletes data from the source by default, so after archiving you don’t need to delete it separately.
As it is done by default, you should take care before actually running it on then production server. You can test your archiving jobs with the – dry-run OR you can use the[Read more...]
This release is the current GA (Generally Available) stable release in the 2.1 series. Percona XtraBackup is an open source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.
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[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[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.
* 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
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[Read more...]
--utcoption 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
--utcby specifying “
--output jsonincludes query examples as of v2.2.3. Some people might not want this because it exposes real data. New option,
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[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[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[Read more...]
Percona Server for MySQL version 5.6.12-60.4
Based on the recently released MySQL 5.6.12, including all[Read more...]
One very interesting feature, “Compact Backup,” is introduced in Percona XtraBackup 2.1. You can run “compact backups” with the –compact option, which is very useful for those who have limited disk space to keep the database backup. Now let’s first understand how it works. When we are using –compact option with Innobackupex, it will omit the secondary index pages. This will make the backups more compact and this way they will take less space on disk but the[Read more...]
Percona Server for MySQL version 5.1.69-14.7
Percona is glad to announce the release of Percona Server 5.1.69-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes in it. All of[Read more...]
Percona Server for MySQL version 5.6.11-60.3
Based on MySQL 5.6.11, including all the bug fixes in it,[Read more...]
If you are using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix your cluster in case it breaks after a distribution upgrade that implies an update of pacemaker from 1.1.7 to 1.18. You can also follow the official documentation here.
The version of Pacemaker (always considered as Technology Preview by RedHat) provided with 6.4 is 1.1.8-x which is not 100% compatible with 1.1.7-x see this report.
So if you want to upgrade,[Read more...]
Percona Server for MySQL version 5.5.31-30.3
Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.31, including all the bug fixes in it, Percona Server 5.5.31-30.3 is now the current[Read more...]
This release fixes a high priority bug. It’s advised to upgrade your latest 2.1 version to 2.1.3 if you’re using the Percona XtraBackup with[Read more...]
This release fixes number of high-priority bugs since version 2.1 became GA. It’s advised to upgrade your latest 2.1 version to 2.1.2. This release is the latest stable release in the 2.1 series.
I talk with lot of people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not to think too much about is if moving from async to synchronous replication is right for their application or not.Facts about Galera replication
There’s a lot of different facts about Galera that come into play here, and it isn’t always obvious how they will affect your database workload. For example: