Monthly Archives - June 2012

Release 1.0.1 of Percona Monitoring Plugins

Version 1.0.1 of the Percona Monitoring Plugins is released. This is a routine bug-fix release that addresses several minor issues.
The Percona Monitoring Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as […]

Read more

Addressing Hot Schema Changes in MySQL

As ones data model evolves changing the database schema becomes painful, especially for big databases where the table must be taken offline. Fortunately, Tokutek introduced online schema changes starting in TokuDB v5.0.
A typical schema change involves adding or deleting a column from a table. These operations usually require the table to be rebuilt offline since the […]

Read more

Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN

I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment.  They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other.
Test Environment
The test environment included AWS EC2 nodes in US-East and US-West (Oregon).  The ping RTT latency between […]

Read more

Percona Toolkit versions 2.0.5 and 2.1.2 released

The Percona Toolkit team is happy to announce the release of Percona Toolkit versions 2.0.5 and 2.1.2. These are bug-fix releases in the 2.0 and 2.1 series, respectively. These releases fix many dozens of bugs, and we suggest that users upgrade to the latest versions of the tools.
The complete list of changes is […]

Read more

NO Security vulnerability in Percona Server / XtraDB Cluster provided binaries

Many of you heard of this nasty security vulnerability in MySQL, and as we are getting a lot of inquiries how does it affect Percona Server, I decided to address it in this post.

The issue exists in the source code of MySQL 5.5.23 or earlier and MySQL 5.1.62 or earlier. The same is true […]

Read more

Fractal Tree Indexing and Filesystems – HotStorage 2012

Modern file systems are well equipped to deal with large writes. One area that remains challenging however is to efficiently write out “microdata”, such as metadata and small portions of large files, while showing good I/O utilization when the data is read back. This challenge is evident with mount options like “noatime” which disables […]

Read more

Announcement of Percona XtraDB Cluster 5.5.24

I am happy to announce next version Percona XtraDB Cluster 5.5.24, which is mostly jump to the current version of Percona Server.
It includes an important bug fix:

table with no PK but still having UK, can cause crash in slave using PA

Binaries are available from downloads area or from our repositories.
For this release we provide […]

Read more

Basement Nodes: Turning Big Writes into Small Reads

Executive Summary
Fast indexing requires the leaves of a Fractal Tree® Index to be big. But some queries require the leaves to be small in order to get any reasonable performance. Basements nodes are our way to achieve these conflicting goals, and here I’ll explain how.
Big Leaves
On many occasions, we at Tokutek have pointed out […]

Read more