Now that we are in the New Year, it is time to settle back into work and make plans for 2013. As part of your professional development planning, consider Percona MySQL Training.

Percona will be holding the following MySQL Training classes in the first quarter:

• January
  • Live Virtual Training – DBA Training for MySQL: January 7-10, 2013
  • Chicago, Illinois, USA : January 14-17, 2013
  • London, UK: January 14-17, 2013
• February
  • Frankfurt, DE: February 4-7, 2013
  • San Francisco, CA, USA: February 4-7, 2013
• March
  • New York, NY, USA: March 11-14, 2013

To view these training events, and others, go to percona.com/training.

Percona Live London wrapped up last week to very positive reviews from attendees and sponsors like those from Johan De Meersman.

Percona was pleased to provide an engaging event for MySQL community members that featured engaging tutorials, highly rated breakout sessions, a very well-attended Tuesday community networking reception sponsored by Clustrix, and keynotes from a variety of industry experts:

• Peter Zaitsev, Percona
• Monty Widenius, Monty Program Ab
• Robert Hodges, Continuent
• Frank Terburg, Clustrix

We were pleased to see such a varied and all inclusive group of MySQL community members in attendance. A few facts about the attendees:

• 52% were from the United Kingdom and 35% were from other parts of Europe that included representatives from countries including Finland, The Netherlands, …

On December 19th at 1 PM Eastern / 10 AM Pacific, I will be giving a
webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know
About”.

As a Consultant, I make heavy use of Percona Toolkit tools while
solving customers’ problems, and I have used this experience to select
what I consider to be the top 10 tools everyone working with MySQL
should know about. I will present each of the selected tools using
examples based on real-world cases.

You can sign up by clicking the “Register” button here. Hope to see
you next week!

The Web And PHP Magazine just published an article describing Percona XtraDB Cluster written by Liz van Dijk and Kenny Gryp. It is a pretty high-level introduction to the technology, so definitely give it a read if you’ve been wanting to give it a closer look.

Go to their website http://www.webandphp.com and download Issue number 9 for free!

As Percona Live London is raging in the UK, I thought it fitting to remind everyone about the next big Percona Live: MySQL Conference and Expo 2013 in Santa Clara, Californa on April 22-25, 2013.  You can register NOW for this conference, and the Super Saving Registration deadline ends on December 28th, so be sure to register early if you already know you’ll be there.

As promised, I wanted to keep giving updates on the committee’s progress in selecting the program for the conference.  As many people know, the selections and …

On Monday I will deliver with Seppo Jaakola from Codership a tutorial on Percona XtraDB Cluster (Percona Server + Galera).

Already in London and you don’t know how to consume the hotel’s bandwidth ? If you attend this tutorial, you can download the Virtual Box appliance we will use during the session.

Two versions are available:

• PLUK 2012 Appliance (32-bit)
• PLUK 2012 Appliance (64-bit)

How to test them:

1. Open the downloaded file with Virtual Box
2. Install all 3 machines
…

Time for another poll! I wonder What CPU Architecture do you use for running MySQL in Production ? I guess most of the game here is between Intel and AMD x86-64 variants though I wonder if there is still a lot of use for others in the wild. If I am missing some Architecture which is still alive in your data center please post a comment and I will add it to the list.
Please select all what applies. If you would like to share what works better for you in the comments I appreciate it.

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.

One of my favorite tools in the Percona Toolkit is pt-query-digest.  This tool is indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your database load.

But the report you get from pt-query-digest is only as good as the log of queries you give it as input.  You need a large enough sample of query logs, collected over a period of time when you have representative traffic on your database.

You also need the log to include all the queries, not just those that take more than N seconds.  The reason is that some queries are individually quick, and would not be logged if you set the long_query_time configuration variable to 1 or more seconds. …

If you are interested by a great and revolutionary HA solution for MySQL or even if you already have some experience with PXC and/or Galera, I invite you to attend the tutorial I will deliver in Percona Live MySQL Conference London 2012 (PLUK2012), December 3rd : Percona XtraDB Cluster in a nutshell.

Small amount of theory and a lot of exercises and examples to really tame the beast that PXC is !

A Codership engineer will also be present and happy to help me answering your questions.

Note to attendees: please bring your laptop with a recent Virtual Box installed and enough free space to store 3 VMs (+/-2G per VM). As said …

Have you been using Percona Server ? Interested to Try ? Using Percona Server in Production Tutorial at Percona Live, London is a great talk for you.

In my experience working with customers I discovered many people are not aware about number of unique features Percona Server offers and how they can help you to achieve better performance and stability in your MySQL environment. I start this talk with many general features which MySQL and Percona Server share giving advice on best production configuration and best practices and then move to special features which are unique to Percona Server. I provide specific examples how to use the features and what benefits they provide.

See you there !