Monthly Archives - October 2012

Minimizing Downtime from Lengthy AWS Outages

Well, it happened again…  Another lengthy EBS outage in the US-East region impacted several sites across the net.  While failures like this are rare, they can be quite costly and translate into headaches for the operations team when impact production systems for any length of time.  At Percona, we routinely help clients architect and […]

Read more

Special Pass/Hotel Bundled Pricing for Percona Live London

I’m pleased to announce special bundled hotel/conference pass packages for the Percona Live London MySQL Conference which is December 3-4, 2012 at The Millennium Gloucester Conference Centre in London. The conference features tutorials December 3rd and breakout sessions December 4th. A networking reception will follow the Tuesday sessions.
Four special, money-saving bundles are available, whether […]

Read more

Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!

Continuous integration of new features and bug fixes is great – but what if a small change in seemingly insignificant code causes a major performance regression in overall server performance?
We need to ensure this does not happen.
That said, performance regressions can be hard to detect. They may hide for some time (or be masked), and […]

Read more

Presenting at tomorrow’s NoVA MySQL Meetup (DC Area)

At tomorrow’s NoVA MySQL October Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use Cases.” The meetup is 7 pm Tuesday, October 23, 2012, and will be held at AOL Campus HQ in Dulles VA.
Most databases employ B-trees to achieve a good tradeoff between the ability to update […]

Read more

Recovering from a bad UPDATE statement

Did you just run an UPDATE against your 10 million row users table without a WHERE clause?  Did you know that in MySQL 5.5 that sometimes you can recover from a bad UPDATE statement?  This is possible if you are running in binlog_format=ROW !
Imagine this scenario:

Shell

CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
[…]

Read more

Merit of Private Training

Percona has offered Training for years, and I have personally delivered my share of Public and Private training.  Below are my thoughts on the different training delivery options and how to choose the one that fits your needs.
The Onsite Public training is perhaps the most conventional type.  We get people from different people and go over our standard […]

Read more

My Talk Next Week at HighLoad++

Next week I’ll be visiting Moscow to talk at Highload++. The conference will take place during Monday 22nd and Tuesday 23rd at the Radisson hotel. I will be giving my personal version of an indexing talk that my colleagues have given in meetups and conferences in the US.

Highload++ conference is targeted to address the […]

Read more

Presenting “MongoDB and Fractal Tree Indexes” at MongoDB Boston 2012

I’ll be presenting “MongoDB and Fractal Tree Indexes” at MongoDB Boston 2012 on October 24th.  My presentation covers the basics of B-trees and Fractal Tree Indexes, the benchmarks we’ve run so far, and the development road map going forward.
I’ve been to this one day conference twice now and both times came away with a […]

Read more

Report on XLDB Tutorial on Data Structures and Algorithms

Bradley and I (Michael) gave the tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference last month.

The tutorial was organized as follows:

Module 0: Tutorial overview and introductions. We describe an observed (but not necessary) tradeoff in ingestion, querying, and freshness in traditional database.
Module 1: I/O model and cache-oblivious analysis.
Module 2: Write-optimized data structures. […]

Read more

Using pt-table-checksum with Percona XtraDB Cluster

As of Percona Toolkit v2.1.5, pt-table-checksum works correctly with Percona XtraDB Cluster, but it doesn’t work quite like a traditional replication setup because cluster nodes are not like traditional replicas.  In this post I demonstrate how to use pt-table-checksum with Percona XtraDB Cluster.
First, you’ll need Percona Toolkit v2.1.5 or newer and Percona XtraDB Cluster 5.5.27-23.6 […]

Read more