Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 205 Next 30 Older Entries

Displaying posts with tag: Percona Software (reset)

Percona celebrates its 7th anniversary by giving to open source ecosystem
+3 Vote Up -0Vote Down

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...]
Your troubles are over, pt-heartbeat 2.1
+2 Vote Up -0Vote Down

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 Monitoring Plugins 1.0.4 release: Now with Galera graphs
+2 Vote Up -0Vote Down

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



  [Read more...]
Growth of Percona software releases
+1 Vote Up -0Vote Down

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...]
Percona Toolkit 2.1.10 is now available
+2 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Toolkit 2.1.10 on July 18th, 2013 (Downloads are available here).

Bugs Fixed:

  • Unfortunately, the relatively new --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
  [Read more...]
Percona Toolkit 2.2.4 is now available
+2 Vote Up -0Vote Down

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:

  • pt-query-digest --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,
  [Read more...]
An Ubuntu PPA of daily builds of Percona XtraBackup
+1 Vote Up -0Vote Down

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...]
Crash-resistant replication: How to avoid MySQL replication errors
+2 Vote Up -0Vote Down

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 5.1.70-14.8 now available
+1 Vote Up -0Vote Down

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 5.6.12-60.4 second Release Candidate now available
+1 Vote Up -0Vote Down

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

  [Read more...]
Limited disk space? Compact backups with Percona Xtrabackup 2.1
+1 Vote Up -0Vote Down

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 5.1.69-14.7 now available: A drop in replacement for MySQL
+0 Vote Up -0Vote Down

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 5.6.11-60.3 first Release Candidate now available
+3 Vote Up -0Vote Down

Percona Server for MySQL version 5.6.11-60.3

Percona is glad to announce the first Release Candidate release of Percona Server 5.6.11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.6.11, including all the bug fixes in it,

  [Read more...]
How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
+0 Vote Up -0Vote Down

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 5.5.31-30.3 now available
+1 Vote Up -0Vote Down

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...]
Percona XtraBackup 2.1.3 for MySQL available for download
+1 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our download site here and Percona Software Repositories.

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...]
Percona XtraBackup 2.1.2 for MySQL available for download
+1 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 18, 2013. Downloads are available from our download site here and Percona Software Repositories.

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.

Bugs Fixed:

  • Using
  [Read more...]
Is Synchronous Replication right for your app?
+5 Vote Up -0Vote Down

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:

  • Transaction commit takes approximately the worst packet round trip time (RTT) between any two nodes in your cluster.
  • Transaction apply on slave nodes is still asynchronous from client commit (except on the original node where the transaction is
  [Read more...]
Percona XtraBackup 2.1.0 ‘release candidate’ for MySQL available for download
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our download site here. For this RC release, we will not be making APT and YUM repositories available, just base deb and RPM packages

This is an Release Candidate quality release and is not intended for production. If you want a high-quality, generally available release, the current stable version should be used (currently

  [Read more...]
Follow these basics when migrating to Percona XtraDB Cluster for MySQL
+0 Vote Up -0Vote Down

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these basics.

log_slave_updates is REQUIRED

You need to have log_slave_updates enabled on the cluster node acting as async slave for replicated events from the async master to be applied to the other

  [Read more...]
Percona Server 5.5.30 with TokuDB for MySQL
+2 Vote Up -0Vote Down

Percona Server with TokuDB

I was excited to see that TokuDB for MySQL from Tokutek is now open source. I believe this is a great technology and it was a significant restriction on the adoption when it was distributed only in a binary format with a proprietary license.

So I went and built Percona Server 5.5.30 with TokuDB’s storage engine. This is an experimental build and I am just going to play with it. The build procedure is somewhat complicated and confusing and this stage, so I want to share it with the entire MySQL


  [Read more...]
Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
+0 Vote Up -0Vote Down

In our last 5.5 series release of Percona Server, we included a regression in the RPM packaging that prevented the server from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of its state before updating. This caused some problems for some users, especially if automatic upgrading was configured on machines with running database servers.

We’ve now

  [Read more...]
MySQL alternative Percona Server 5.1.68 -14.6 now available
+1 Vote Up -0Vote Down

Percona Server for MySQL version 5.1.68-14.6

Percona is glad to announce the release of Percona Server  5.1.68 -14.6 on April 19, 2013 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona

  [Read more...]
Is your MySQL buffer pool warm? Make it sweat!
+2 Vote Up -0Vote Down

Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to Kyle Oppenheim at Groupon for contributing to this project and post. We’ll be posting Part 2 on Thursday. I’ll be at the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there – I’d love to connect and talk more about MySQL buffer pools or anything else that’s on your mind!

There


  [Read more...]
Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
+1 Vote Up -0Vote Down

The Percona Live MySQL Conference and Expo begins next Monday and runs April 22-25, 2013. Attendees will see great keynotes from leaders in the industry including representatives from Oracle, Amazon Web Services, HP, Continuent, and Percona. They can also participate in thought provoking Birds of a Feather sessions on Tuesday night and the Wednesday night Community Networking Reception will be fun and entertaining with the presentation of the Community Awards and the Lightning Talks.

If you

  [Read more...]
Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
+2 Vote Up -0Vote Down

In addition to the problem with trx_list scan we discussed in Friday’s post, there is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this structure from heap. The problem is that the heap for that allocation is destroyed on each commit and thus the read view memory is reallocated on the next transaction.

There

  [Read more...]
Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
+0 Vote Up -0Vote Down

We just released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups on the fly (full documentation here). This feature is different than simply piping the backup stream through the openssl or gpg binaries, which is what some people have used in the past. A big benefit of using the built-in encryption is that multiple CPU cores can be used for encryption

  [Read more...]
Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
+1 Vote Up -0Vote Down

Facebook is a major user of MySQL and has pushed the performance limits of the technology. Their MySQL experts have deep, hands on knowledge of the technology. I’m pleased to welcome Mark Callaghan, Software Engineer for Database Infrastructure at Facebook, back again this year to the Percona Live MySQL Conference & Expo to share his expertise. Mark was a keynote speaker at last

  [Read more...]
Announcing Percona Server for MySQL 5.1.68 -14.5
+1 Vote Up -0Vote Down

Percona Server for MySQL version 5.1.68-14.5

Percona is glad to announce the release of Percona Server for MySQL 5.1.68 -14.5 on March 15, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68 -14.5 is now the current stable release in the 5.1 series. All

  [Read more...]
Oracle Technical Experts at the Percona Live MySQL Conference and Expo
+12 Vote Up -0Vote Down

I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Percona Live MySQL Conference and Expo. The conference takes place April 22-25, 2013 at the Santa Clara Convention Center and Hyatt Santa Clara.

Tomas Ulin, VP, MySQL Engineering for Oracle, will present an invited keynote talk on “Driving MySQL Innovation” during the Tuesday morning opening keynotes. With the recent release of MySQL 5.6, conference attendees will hear about the latest developments of this

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 90 of 205 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.