If you are planning to upgrade or make any configuration change on your MySQL database the first advice usually is: – Benchmark! How should we do that benchmark? People usually run generic benchmark tools like sysbench, tpcc or mysqlslap that are good to know the number of transactions per seconds that a database can do [...]
This post is a step-by-step guide to set up Percona XtraDB Cluster (PXC) in a virtualized test sandbox. I used Amazon EC2 micro instances, but the content here is applicable for any kind of virtualization technology (for example VirtualBox). The goal is to give step by step instructions, so the setup process is understandable and [...]
I’m speaking at POSSCON in Columbia,SC next week (March 28). My talk will be about Open Source software Percona Produces – Percona Server, Percona Xtrabackup, Percona Toolkit, Percona XtraDB Cluster. If you want to get a birds eye view about Open Source software Percona has created this is a great talk to attend. We’re also [...]
On coming PL MySQL conference 2012 I will give one tutorial: Percona XtraBackup: install, usage, tricks. This tutorial I will do in joint with Alexey Kopytov, the lead developer of Percona XtraBackup. Our intent is to provide the comprehensive overview of the XtraBackup architecture and features, and we will touch future roadmap. This is all [...]
There and in coming posts I am going to cover main features of Percona XtraDB Cluster. The first feature is High Availability. But before jumping to HA, let’s review general architecture of the Percona XtraDB Cluster.
I tend to speak highly of the random query generator as a testing tool and thought I would share a story that shows how it can really shine. At our recent dev team meeting, we spent approximately 30 minutes of hack time to produce test cases for 3 rather hard to duplicate bugs. Of course, [...]
Last week I helped 2 different customers with infinite replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them.
A while ago I started a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t add anything to this discussion, I got sidetracked, and then time passed, and I no longer think it’s a good idea to publish those blog posts [...]
Time for our weekly review of the news! The big news this week is that Percona XtraBackup is ready to try out on Windows. Otherwise, there’s just more steady progress. One quick note, sort of a “to whom it may concern,” is that the proper trademarked names of our products include “Percona Server”, “Percona XtraDB”, [...]
I just realized that we haven’t blogged a list of our sessions at the O’Reilly MySQL Conference and Expo (#mysqlconf) yet. Here is a hopefully complete list.