EmergencyEMERGENCY? Get 24/7 Help Now!

Minimizing Downtime from Lengthy AWS Outages

 | October 24, 2012 |  Posted In: Cloud and NoSQL, MySQL

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 deploy […]

Read More

Special Pass/Hotel Bundled Pricing for Percona Live London

 | October 24, 2012 |  Posted In: Events and Announcements, MySQL

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!

 | October 23, 2012 |  Posted In: Benchmarks, Events and Announcements, Percona Software, Quality Assurance

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 […]

Read More

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

 | October 22, 2012 |  Posted In: Tokutek, TokuView

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

 | October 19, 2012 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

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:

We run an accidental UPDATE statement that […]

Read More

Merit of Private Training

 | October 19, 2012 |  Posted In: MySQL

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++

 | October 18, 2012 |  Posted In: Tokutek, TokuView

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

Report on XLDB Tutorial on Data Structures and Algorithms

 | October 15, 2012 |  Posted In: Tokutek, TokuView

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: […]

Read More

Using pt-table-checksum with Percona XtraDB Cluster

 | October 15, 2012 |  Posted In: Insight for DBAs, Percona Software, 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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.